I have yet two questions: 1) DataModules. In delphi there is some kind of units, similar to forms, which i can use for placing non visual components such as connections, transactions, datasets and datasources. So i can place all my datasets inside this datamodule and use it where i need. It's very convenient. Than a few forms can use same datasource + dataset and all controls synchronize automatically by delphi.
Imagine you have two forms: Goods and Sales. When you insert or edit sales you should select a good to sale, so Grid in table Goods and DropDownList in form Sales linked with same datasource/dataset which placed in datamodule. So grid on Goods form and DropDownList on sales form always show same records. Than if i open both forms Goods and Sales and change goods in goods form than this changes immediately shows in sales drop down list because of delphi synchronize it. What i can use in ADO.NET instead of that? 2) Datasets in delphi are clever. When i call DataSet.Open() than dataset fetch only records which need controls for display (or 1 record if no controls linked). For example i have form Goods with datagrid. In table Goods in database there are 1000 records, but on form Goods i can see only 100 records without scrolling. Then delphi fetches only first 100 records and it will fetch other 900 records only in case when i make client sorting or scrolling in grid or something else. How can i do the same in ADO.NET ? ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider