How can I get result set from SP

[essa2000]

Dears;
I want to have result set from back end means using SP. e.g.
I have 1000 records in a table and I want to fetch 100 records first and then on fressing next button I want to get next 100 ( from 101 to 200 ). To make the performance good.

Pleaes , help me out.

essa2000

 

[tlbroadbent]

What is the Front End program? VB? C++? ASP? Access?

How are you connecting to SQL Server? ADO? ODBC? Something else? Terry

http://www.defendscouting.com/

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[essa2000]

VB is the front End program.
I am using ADO 2.5

essa2000

 

[tlbroadbent]

Check the articles at the following links

Paging: Use ADO, getrows, or a Stored Procedure?

http://www.15seconds.com/Issue/010308.htm

Paging through Records using a Stored Procedure

http://www.aspfaqs.com/webtech/062899-1.shtml

LISTING 4: Paging Results from a SQL Server Query

http://www.sqlmag.com/Files/09/20176/Listing_04.txt

You might also find helpful info at these links.

Performance Tuning VB Application for SQL Server

http://www.swynk.com/sqlhome/tips/mcgeheeprog1.asp

ADO Performance Best Practices

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16272&pg=3

Terry

http://www.defendscouting.com/

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[essa2000]

Dear tlbroadbent ;

I got the solution from this Article. It is very helpful.

Paging: Use ADO, getrows, or a Stored Procedure?

http://www.15seconds.com/Issue/010308.htm

Please tell me that what will I do if I have more 200000 records. They used Temp table in stored procedure. That will slow the system.
Please comments.

Thanks.