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
- 13100 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok
This can be done using following ways. Mainly its base on
multitreading environment.
1. Declare delegate (I am using Async delegate)
2. Start a new thread which will gets a data information in
collection or we can fill the dataset.
3. In main thread you can keep polling to the datafill
thread whether the operation is complete or not.
4. with IAsyncResult we can find whether the thread which we
started earlier has completed the assigned task or not.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are all the classes that are available in System.Data Namespace?
What do you mean by performing asynchronous operation using command object?
What is ado control?
What are the 3 major types of connection objects in ado.net?
How can we load multiple tables in a dataset?
What is dbcontext and dbset in entity framework?
How to create data relations?
How do you update database through dataset?
What is the difference between dataset and datatable?
What are the usages of the command object in ado.net?
What is the difference between executequery and executenonquery?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is ado.net and its architecture?
What is the difference between connected and disconnected environment?
What is ado.net connection?
