Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 68202 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / ravinderreddy kothakapu
Dataset:
1)Dataset is a inmemory database for client application
process and it will contain more number of tables.
2)Dataset supports manipulations.
3)Dataset is a independent component in ADO.NET.
4)Dataset is a purly disconnected architecture with XML file
integration.XML file integration supports cross platform
independence.
5)Dataset supports bidirectional navigation.
6)Dataset defined multiple tables where contraints can be
applied.
7)Dataset can be persist the data.
Syntax: DataSet ds=new DataSet();
Data Reader:
1)Data Reader is a read only and forward only implimentation
2)Read only means it cannot support
manipulations(insert,delete, update)
3)Forward only means it support record pointer navigation in
forward direction means it is used for only once read
4) we can access only one table
5)Data reader cannot persist the data
6)It is a connected Architecture.
7)Most advantage is Data Reader is faster then Data Adapter.
Syntax:OleDb DataReader dr;
dr=cmd.ExcuteRader()
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are dataproviders?
What are the benefits of using ado.net?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
How do you update a dataset in ado.net?
Which is the feature of ado.net?
Describe the disconnected architecture of ADO.NET’s data access model.
What are the important features of ado.net 2.0?
What is the difference between sqldatareader and sqldataadapter?
What is the use of connection object in ado.net?
What is Dataset Object?
What are the ado.net objects?
What is datatable in ado.net?
What are the steps you will take to improve performance?
What are the advantages of using datalist?
What does ado stand for?
