Loading DataSets and App Size

[Paul]

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?

 

[Ken Tucker [MVP]]

Hi,

Here is a method that will work with sql server 2005

http://www.windowsformsdatagridhelp.com/default.aspx?ID=79afdb6a-611d-43cd-9186-def86a1baeef

Ken

 

[Paul]

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?

 

[Ken Tucker [MVP]]

Hi,

Sorry there is no simple way to page the data with sql server 2000.


Ken

 

[Paul]

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