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
Can you please explain the difference between c# and vb.net?
What is the difference between .dll extension and .exe extension files?
What is normal jit?
How to run a dos command in vb.net?
What are the features present in vb 2005?
Allowed program to auto-correct the database when loading a presentation.
How can I extract the formated word(bold,italic,underline,font,color etc) from the msword file.?
What are the shared variables?
Why do we use byref keyword in vb.net?
What is the significance of delegates. Where should they be used?
Name some different types of control?
what's ArrayList in .Net (VB.Net or C#).What's the advantageous using ArrayList.
What is strong typing and weak typing?
Which control is an example of an object in vb net?
Which dll is used for microsoft .net run time?