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?
Submitted by: Administratorwe have to use a dataset because on using datareader forward only paging can be achieved.
Suppose if you are at 1000 page and you want to go back to 999th page, if you use datareader it cannot be achieved, since it does not support backward navigation.
Dataset supports forward and backward navigation
Submitted by: Administrator
Suppose if you are at 1000 page and you want to go back to 999th page, if you use datareader it cannot be achieved, since it does not support backward navigation.
Dataset supports forward and backward navigation
Submitted by: Administrator
Read Online ADO.NET Job Interview Questions And Answers
Top ADO.NET Questions
☺ | Which one of the following objects is a high-level abstraction of the Connection and Command objects in ADO.NET? |
☺ | Difference between SqlCommand and SqlCommandBuilder? |
☺ | Can dataReader hold data from multiple tables? |
☺ | What provider ADO.net use by default? |
☺ | What is different between SqlCommand object and Command Behavior Object? |
Top Dot Net Technologies Categories
☺ | MSF Interview Questions. |
☺ | .Net Architecture Interview Questions. |
☺ | ASP.Net MVC Interview Questions. |
☺ | Entity Framework Interview Questions. |
☺ | C# (Sharp) Programming Language Interview Questions. |