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

scrolling through records and requesting the next junk of records from the db

P: n/a
Hi,

I am doing a VB.NET application with SQL Server 2000 and I need to implement
a database search facility that will normally return lots of records. Those
records will then be displayed in a datagrid.
What I want to do is not to create a complete dataset but a partial one, and
whenever i reach the end of the partial dataset i want the database to
return the next part of the dataset.

My first guess would be to create a client cursor and fill it up with say a
100 records. The 100 records are then displayed on the datagrid (and the
vertical scroll bars appear on the datagrid). Attempting to scroll the
datagrid beyond the last (or first) record will generate a db request for
the next 100 records and so on....

The application i am working on is not a web app.

Is this the correct approach to the problem? if yes, how do i define such
cursors on SQLServer2000 ?

Thanks
Ioannis Demetriades

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.