Difference between datareader and dataset?
Answer Posted / shivangi pandya(cojit- sy)siho
*dataset........
..it is read & write we can make changes.
..we can do insert,update,delete operatios.
..we can move previous in it.
..it is faster then datareader.
..it doesent hold any data.
..data can not be transfer to datasource.
..only one record save in a memory at a time.
..dataset is connection oriented.
*data reader........
..it is read & forward only.
..we cant do ant insert,update,delete operation.
..we can not move previous in i.t
..it is slower then dataset.
..it can holds the data table.
..data can be transfer to datasource.
..pulls the records from datasource & saves in IIS memory.
..it is disconnected oriented.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How can we check that some changes have been made to dataset since it was loaded?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
Which is faster sqldataadapter and sqldatareader?
What are ado.net objects?
What are the Data providers in ADO.Net?
How does ado.net work?
differences between ADO and ADO.NET
Give few examples of datareader that is used in different dataproviders.
What is serialization and de-serialization in .net? How can we serialize the dataset object?
How can I retrieve two tables of data at a time by using data reader?
What is meant by executenonquery?
What are the major challenges in accessing data from a database?
How would you connect to database using .NET?
What is ado code?
What are datareaders?