Difference between datareader and dataset?
Answer Posted / ganesh
datareader(connection oriented) is a read only and forward
only record set which will have the data retrieved based on
the select statement.we can't do DML operations through
datareader.
whereas dataset(disconnected) model which we can do all the
DML operations.
Is This Answer Correct ? | 111 Yes | 20 No |
Post New Answer View All Answers
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
Explain ado.net features?
What two types of data providers does ADO.NET supply? What determines which one you should use?
How to pass multiple tables in datasets simultaneously?
What is commandbuilder in ado.net?
What is the use of sqldatareader class?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
Define connection string?
What is data access pattern?
What is the advantage of ado.net?
Explain the two fundamental objects in ado.net?
What is a string variable?
How do you find the count of records in a dataset?
What are the classes in System.Data.Common Namespace?
What are the advantages of oledb compared with other classes?