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
What is execute reader in ado.net?
What is ado.net architecture?
Which parameter of ConnectionString is used to specify the name of the database?
How to aggregating data across related tables?
What are the different methods by which we can populate a dataset?
What is ado circle?
Explain the advantages and disadvantages of using datalist?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is the difference between executequery and executenonquery?
What we do with the object of ado.net dataset after using it?
What does executenonquery () method return?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What is data view and variable view?
What is connection in ado.net?
What are the advantages of using datalist?