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 / vijay
answer # 3 is really appreciate me thanks for giving
correct answer. i ve tested with sqldatasource with
gridview and change datasourcemode to datareader giving
error u must use dataset..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is linq and entity framework?
What are the disadvantages of using datalist?
What are the key features of ado.net?
What is the DataTableCollection?
Explain sqlconnection object?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is ole db and odbc?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is the advantage of ado.net?
What is openquery?
Explain the differences between oledb sql server, oledbdotnet provider?
How to add an aggregate column?
How do you update database through dataset?
What is the difference between data reader and data adapter?