What is the Difference between Dataset and Datareader?
Answer Posted / anitha
Dataset is cache of records retrieve from data source.
Datareader is used to retrieve data from datasource.
1.Using Datareader we can read the data readnly,forwordonly
basis.
2.Only one record in a memmory at a tme
3.Faster
4.Doesnot hold any data
5.Data can not be transfer to datasource
Wher as in Dataset
1. we can read and write and allow us to navigate through
the records forword and backwords.
2.Pulls the records from the datasource and saves in IIS
memmory.
3.Slower
4.Holds datatables and has the information about
relationship between those tbes.
5.Data can be transfer to datasource
| Is This Answer Correct ? | 34 Yes | 5 No |
Post New Answer View All Answers
Explain how does the xmlserializer work?
Is vb.net dead?
Tell me how many .net languages can a single .net dll contain?
What is the difference between import system.data.sqlclient and system.data.oledb?
What is the exact defination of object?
What are the shared variables?
Define serialization in .net?
What is the difference between value and reference types?
How to store decimal data in .net?
What are the differences between server-side and client-side code?
What is code security?
What is DLL HELL in VB.NET
What is datatype conversion?
Explain cls?
Described strong typing