Solved

How to load data as needed in a DataSet

Posted on 2006-10-20
4
178 Views
Last Modified: 2010-04-23
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
Comment
Question by:Synth2
4 Comments
 
LVL 10

Expert Comment

by:Kinger247
ID: 17783910
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
 
LVL 41

Accepted Solution

by:
graye earned 60 total points
ID: 17802995
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

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question