Diff. b/w DataReader and DataSet?
- 8 Answers
- 11428 Views
- Avon, Value Labs, I also Faced
- E-Mail Answers
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
What is ole in vb?
Describe the command object and its method.
Explain the advantages and disadvantages of using datalist?
What is the difference between sqldatareader and sqldataadapter?
What are the namespaces used in ADO.Net to connect to a database?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
What is the role of clr?
Explain what is datagrid with an example?
What is ado.net explain with diagram?
What is ole word?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
How to find the given query is optimised one or not?
What is difference between connected and disconnected architecture in ado.net?
What is ambient transaction?
What is connection string?
