Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 13379 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
What is bubbled event can you please explain?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
Which is faster entity framework or ado.net?
What are the connected and disconnected modes in ado.net?
What are the important features of ado.net 2.0?
Define partial class?
What is data relation in ado.net?
What is basic use of data view?
What providers does Ado.net uses?
What is the difference between ado.net and entity framework?
What are ado.net objects?
What are the usages of the command object in ado.net?
What are all the different authentication techniques used to connect to MS SQL Server?
What is linq and entity framework?
What is ado connection?
