Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
golden_manish
Starting Member
13 Posts |
 Posted - 2009-10-02 : 12:20:01
|
| Hi guys, I need to implement a .Net equivalent of Java's Scrolling Resultset.i.e, a SP in SQL Server will return me an incremental++ sub-set of the actual data every time i call it. This call will be in the background asynchronously, and i will be filling a dataset/datatable on the server side.Not sure if there is a solution in SQL Server 2008 or will have to manage in .net (latest version). But would like some suggestion to start with.Thanks in advanceManish |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 13:12:29
|
| you mean some kind of table refresh in page with latest results |
 |
|
|
golden_manish
Starting Member
13 Posts |
Posted - 2009-10-02 : 13:59:16
|
| Hi visakh16,No don't actually mean, a page refresh.Ex. A table has 100000 records. I need to show the user the data instantly. The idea is to call a SP behinds the scene, and take the first 1000 records and show it to the user. And keep on retrieving the data asynchronously from the sp and updating the serverside datastore.I am using ajax to update the screen.ThanksManish |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 14:07:06
|
| why retrieving in batches? any problem in populating entire data first itself? or does data gets retrived based on some action/input from user? |
|
|
|
golden_manish
Starting Member
13 Posts |
Posted - 2009-10-02 : 15:03:38
|
| The data is too big, the user will have to wait for mins for the sp to be executed completely and then return the data.Hence I was thinking of breaking the retrieval into batches and update the screen using ajax.The trigger can be a scroll on the grid or page change.ThanksManish |
|
|
|
|
|
|
Scrolling Resultset