What is the Difference between Dataset and Datareader?
Answer Posted / vasudha.g.n
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.
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
What is the top .net class that everything is derived from?
what is common type system?
So you know which dll is used for microsoft .net run time?
Write the role of new keyword?
How a base class method is hidden?
What is the use of assembly?
i am attending to US consulate i kept my projects on vb.net ,please help me what questions will be ask on vb.net in us consulate
Explain cls?
What is difference between import system.data.sqlclient,system.data.oledb?
Name some of the features of C# which are not present in VB.NET?
Name some of the keywords used in vb.net?
Sir, what code to store data from vb net sql server 2008 to 2005 and at the same time in order to validate the data entered is not the same, but there have been contacts in the module. Examples such as the log table that I created, the user name as the primary key.
my project run very wel in my sytem yhen i am deploying my project on client machine ,after deployment i run my project then it show " can no find server name " what i do .
What is the significance of delegates. Where should they be used? What are the situations where we require them?
List the types of authentication?