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
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What are all the commands used with Data Adapter?
What is ole word?
How to bind the controls(best practice) comboboxes to the data in the dataset?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is dbcontext and dbset in entity framework?
Does sqlclient and oledb class share the same functionality?
What is difference between dataset and datatable?
Is it possible to edit data in Repeater control?
What is the namespaces being used to access oracle database?
What is the use of Dataview?
What are the different ado.net namespaces are available in .net?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What is the difference between an ADO.NET Dataset and an ADO Recordset?
Which ado.net object is very fast in getting data from the database?