By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,234 Members | 1,850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,234 IT Pros & Developers. It's quick & easy.

Loading DataSets and App Size

P: n/a
I have a test application that uses databinding to a table of about
20,000 records. The SQL statement for the databinding is "SELECT *
FROM tbl_CID_XRef". From this I can move forward and backward in the
data, edit, add and delete records. It all works fine. There are two
problems.

The first is that it takes awhile for the app to load. The dataset is
filling up with all the records. The second is that the app takes too
much RAM.

Do datasets have a paging feature? Where, for example, I could set it
to a specific size and only that number of records get loaded into the
dataset. Then when moving to a record that is not in that page it will
get the next page.

Or does all this have to be done manually? If so, could you give any
code examples or documentation on this?

Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi,

Here is a method that will work with sql server 2005

http://www.windowsformsdatagridhelp....6-def86a1baeef

Ken
-----------------------
"Paul" <pw****@gmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
I have a test application that uses databinding to a table of about
20,000 records. The SQL statement for the databinding is "SELECT *
FROM tbl_CID_XRef". From this I can move forward and backward in the
data, edit, add and delete records. It all works fine. There are two
problems.

The first is that it takes awhile for the app to load. The dataset is
filling up with all the records. The second is that the app takes too
much RAM.

Do datasets have a paging feature? Where, for example, I could set it
to a specific size and only that number of records get loaded into the
dataset. Then when moving to a record that is not in that page it will
get the next page.

Or does all this have to be done manually? If so, could you give any
code examples or documentation on this?

Nov 21 '05 #2

P: n/a
Ken, thanks for your response. I should have mentioned that we are
using SQL Server 2000. The link you gave me said that the solution
given would not work with 2000. Any other ideas?

Nov 21 '05 #3

P: n/a
Hi,

Sorry there is no simple way to page the data with sql server 2000.
Ken
----------------
"Paul" <pw****@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
Ken, thanks for your response. I should have mentioned that we are
using SQL Server 2000. The link you gave me said that the solution
given would not work with 2000. Any other ideas?

Nov 21 '05 #4

P: n/a
Could anyone provide some sample code for doing this in VB.NET using
SQL Server 2000 as the back-end?

Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.