Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between Dataset and Datareader?
- 7 Answers
- 30885 Views
- I also Faced
- E-Mail Answers
Answer Posted / khawar rizvi
DataReader
Datareader is like a forward only recordset. It fetches one
row at a time so very less Network Cost compare to DataSet
(Fetches all the rows at a time). DataReader is readonly so
we cannot do any transaction on them. DataReader will be
the best choice where we need to show the data to the user
which requires no transaction ie reports. Due to DataReader
is forward only we cannot fetch the data randomly. .NET
Dataproviders optimizes the datareaders to handle the huge
amount of data.
DataSet
DataSet is always a bulky object that requires lot of
memory space compare to DataReader. We can say the dataset
as a small database coz it stores the schema and data in
the application memory area. DataSet fetches all data from
the datasource at a time to its memory area. So we can
traverse through the object to get required data like
qureying database.
The dataset maintains the relationships among the
datatables inside
it. We can manipulate the realational data as XML using
dataset.We can do transactions (insert/update/delete) on
them and finally the modifications can be updated to the
actual database. This provides impressive flexibility to
the application but with the cost of memory space. DataSet
maintains the original data and the modified data
seperately which requires more memory space. If the amount
of data in the dataset is huge
then it will reduce the applications performance
dramatically.
The following points will improve the performane of a
dataset...
1. Don't use the commandbuilder to generate the sql
statements.
Though it reduces the development time the query generated
by the command builder will not be always as required. For
example
To update the details of an author table the command
| Is This Answer Correct ? | 45 Yes | 10 No |
Post New Answer View All Answers
Explain about the performance of visual basic?
What is the significance of delegates. Where should they be used?
Explain the difference between .dll extension and .exe extension files?
What is datatype conversion?
hello thank you for replying to my question regarding adding barcode fonts in vb.net project. I have downloaded a free font and added in my vb.net project but now i dont know how to use that i need to generate barcodes can any body help me how to use those fonts these are font3of9 .i need a small code to use these fonts to generate barcode thank u!
Name a feature which is common to all .net languages?
What is normal jit?
Write a program to find all text files in a logical drive and return the count of the number of files?
Explain clr?
What does assert() method do In VB.NET
How do you define a read only property in a class module?
how to deploy vb.net with key and evaluation time? any one can help me?
Tell me which namespace are used for accessing the data?
Explain the use of option explicit?
Explain and brief about rapid application development tool?
