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?
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 are all the commands used with Data Adapter?
What are all the different authentication techniques used to connect to MS SQL Server?
What is connected architecture in ado.net?
Explain the difference between an ado.net dataset and an ado recordset?
How to find the given query is optimised one or not?
What are the different methods available under the sqlcommand class to access the data?
Give few examples of datareader that is used in different dataproviders.
What is dataset and datatable in ado.net?
What is ado in agriculture?
What is ado.net code?
Explain the difference between data reader and data adapter?
Which database is the ado.net sql connection object designed for?
Explain executenonquery?
How can we load multiple tables in a dataset?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?