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
- 13209 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
Define different execute methods of ADO.NET command object ?
How to check if the Dataset has records ?
Explain the overview of ado.net architecture?
What is openquery?
What is openrowset?
How does entity framework work?
What are the steps you will take to improve performance? Will you use dataset or datareader?
Which namespaces are used for data access?
What is the default Timeout for SqlCommand.CommandTimeout property?
Explain the namespaces in which .net has the data functionality class.
Why do we use sqldataadapter?
What are the usages of the command object in ado.net?
What are the benefits of using of ADO.NET in .NET 4.0?
What does sqldatareader return?
What is linq and entity framework?
