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
- 12894 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
Which object is used to add relationship between two Datatables?
How would you connect to database using .NET?
What is the difference between executequery and executenonquery?
What is the role of clr?
What are the rules to implement connection pooling?
How to check if a datareader is closed or opened? IsClosed()
What are the namespaces used in ado.net for data access?
What is data adapter in ado.net with example?
What are the uses of Stored Procedure?
What are advantages of microsoft-provided data provider classes in ado.net?
Describe the command object and its method.
What is different between sqlcommand object and command behavior object?
What is the default provider in ado.net?
What is shadow copy?
What is difference between datatable and dataset?
