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
13109 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 ado.net object model?

967

What is ado.net in vb net?

908

What DataReader class do in ADO.NET ?

1074

What are the ado.net components?

1008

What is difference between executequery and executeupdate?

974

Do you use stored procedure in ado.net?

1010

What are the pre-requisites for connection pooling?

990

What are the usages of the command object in ado.net?

1012

What is data access pattern?

920

What are the different execute methods of Ado.Net?

1009

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

1012

What is ado recordset?

967

What are the types of databinding?

968

Explain the role of data provider in ado.net?

974

What is the use of data grid?

945