We help IT Professionals succeed at work.

How to load data as needed in a DataSet

Synth2
Synth2 used Ask the Experts™
on
Hi!

my ask is so simple. I only want to know if exist any way, in Visual Studio 2005, to load data in a DataSet as needed. I mean, in example when i use a BindingNavigator, i want to load more rows of a table when i have saw a 95% of the current loaded rows, and i want to do it automatically...Exists any way to do this? Java has an implementation of this functionality in his dataQuery object, can i do the same with a Dataset or DataTable or DataAdapter object or i have to do it with several querys?

Thanks in advance!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I don't know of an automated way to do this, but I would personally create the Dataset manually then keep adding to it as and when.
Would be easy enough to do ...
Commented:
in VB.Net 2005, the DataAdapter's Fill method as a new "overload" that allows you to fill a datatable in "chunks"...   For example, you could create a loop that would fill 1000 rows at a time, then update a progress bar (as an example), and continue to fill the DataTable with 1000 rows at a time.

http://msdn2.microsoft.com/en-us/library/kxs7kbfe.aspx