Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Diff. b/w DataReader and DataSet?

Answer Posted / tejas mer

DataReader is connected architecture and it's read-only, forward only type, so when you just want to display the data better to use it, it consumes less memory with compare to dataset as well.

DataSet is we can say in-memory representation of the data.
It's disconnected architecture.
Contains DataTables, which are further divided into Datarows and Datacolumns.
Also contains DataRelationships and Contraints...

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the differences between oledb sql server, oledbdotnet provider?

164


How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

221


What is data view and variable view?

138


What is the meaning of executenonquery?

159


What is DataRowCollection?

241






What is DataReader Object?

210


What are the different row versions available in table?

181


What is ambient transaction?

149


What is connected architecture in ado.net?

152


Name which operations can you not perform on an ado.net dataset?

179


Explain the different row versions available in table?

171


What are advantages of microsoft-provided data provider classes in ado.net?

181


What are all components of ADO.Net data provider?

225


What does ole stand for in excel?

141


What is command class in ado.net?

131