Data Reader is a forward only and read only data DataSet is used to mainta

Difference between datareader and dataset?

Question Posted / chaitanya.k

26 Answers
68172 Views
Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
E-Mail Answers

Answer Posted / chaitanya.k

Data Reader is a forward only and read only data
DataSet is used to maintain relationships between multiple
tables.

Data Reader can't persist the data
Data Set can persist the data

Is This Answer Correct ?

145 Yes

22 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to creating a SqlCommand Object?

1193

What is ole data type?

966

What is Data Provider?

1089

What are the pre-requisites for connection pooling?

1058

What is the meaning of object pooling?

1310

Define Execute Scalar?

1060

Can we do database operations without using any of the ado.net objects?

1039

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1051

How to perform sorting on a table in ADO.NET?

1076

What is the default provider in ado.net?

1021

What is ole in excel?

981

What is an ADO.Net?

1035

How can we load multiple tables in a dataset?

1234

Explain the two fundamental objects in ado.net?

1066

What is ado.net code?

969