sasha wrote: > 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?
For example, binding to the same object created for this is your friend. :) > 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 ? > Cause DS in ADO.NET is complete offline image of data, it's filled always with all data from select. But you can create/download layers with work i.e. with DataReader, which are able to do this. BTW: DataSet's TableAdapter is using DataReader internally so you can (I hope) download also TableAdapters & DataSets with this functionality. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- 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