Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

How to load data as needed in a DataSet

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!
0
Synth2
Asked:
Synth2
1 Solution
 
Kinger247Commented:
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 ...
0
 
grayeCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now