[2.0] disconnected data access ???

[shadowcodes]

hi guys,

i just want to know something regarding the disconnected data access...soo please give me a brief discription... in that..

and lets say there are millions of records in a table..and do we popluate all the records in to the dataset...?? each time when we need all data in database..or what happends..may be this is stupid..but..i just want to know about this

[jmcilhinney]

If you need all the records in your app then yes, you retrieve all the records. If you don't need them all then you don't get them all. If you need to provide access to all records but you don't need to show them all at once then controls like the DataGridView provide a virtual mode, where they appear to contain all the data but each "page" of data is only retrieved if and when it's needed.

[shadowcodes]

hi thanx for your reply..but can u explain little more on virtual mode..like does it works like paging..and when clicking on the next page does it get them from the database..or from the dataset which is already populated?...

[jmcilhinney]

http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.virtualmode.aspx