Create a stored procedure with parameter page size and current page index.G

If a table contains 20000 records . In a page at each time
100 records to be displayed. What are the steps u will take
to improve performance? will you use dataset or datareader?

Question Posted / kumar vaibhav

7 Answers
13193 Views
I also Faced
E-Mail Answers

Answer Posted / kumar vaibhav

Create a stored procedure with parameter page size and current page index.Get the lower bound and upper bound of the page by using following formula

Lower bound=Pagesize*PageIndex+1
Upper Bound=lowerbound+pagesize

call this Stored Procedure on every paging event of gridview.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of adodc?

993

What is aggregating data ?

963

What is the difference between OLEDB Provider and SqlClient?

988

How to pass multiple tables in datasets simultaneously?

1062

What is an ado connection?

976

Why do we need ado.net?

971

What is an ADO.Net?

995

What is variable view?

878

What are the Features of a dataset

1311

What does adodb stand for?

1055

What is acid in ado.net?

1039

Which is faster sqldataadapter and sqldatareader?

931

Explain the difference between data reader and data set?

930

Explain how to create dynamic gridview?

983

What are the benefits of using of ADO.NET in .NET 4.0?

1076