IF we have lot of records in Database. How we can handle them?
Answer Posted / pavan kumar p
You can handle Large data by practicing some design
patterns like, using stored procedures rather than
Statements, Use coloum names rather tahn * when fetching
the statements etc..
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the uses of Stored Procedure?
Does executenonquery return a value?
What is the use of adodc?
What are datareaders?
What is an orm, and why would you use one instead of plain old ado.net?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
How to check if a datareader is closed or opened? IsClosed()
What is ado.net tutorial?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
What is difference between sqldatareader and sqldataadapter?
What is ole word?
What are the ado.net connection pooling parameters?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
Explain the difference between sqlcommand object and command behavior object?
What are the data providers in ADO.NET framework?