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
What is the full form of ado?
Define partial class?
What is meant by executenonquery?
What is ado control?
Does sqlclient and oledb class share the same functionality?
What is the DataTableCollection?
What is an ADO.Net?
Why do we serialize data?
Explain the overview of ado.net architecture?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
Explain the differences between oledb sql server, oledbdotnet provider?
Explain how do you connect to sql server database without using sqlclient?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
Define the data provider classes that is supported by ado.net?
Give an example that shows how to execute a stored procedure in ado.net?