Answer Posted / rahul shukla
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.
Data Set
Data Set is always a bulky object that requires lot of
memory space compare to Data Reader. We can say the data set
as a small database coz it stores the schema and data in the
application memory area. DataSet fetches all data from the
data source 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 ? | 3 Yes | 1 No |
Post New Answer View All Answers
ArrayList declaration in .net
i have a gird with columns all are coming from database,this will bind in item templete in gridview as textboxex.and i have button below named Update.i want to update all the records in the grid,but if user change the value of one textbox,what is the easy way 2 do this
Code for Document Validation in XML.NET?
Code for Creating a Form Using PlaceHolder Controls?
Code for Communicating over Sockets?
Code for Presenting Parent/Child Data in a Data Grid Row?
What is the code of Password Recovery or Forget your password? Plz tell in c # language.
How to Bind Nested XML to a Repeater Control with Container.DataItem?
How we use ajax in asp.net through javaScript. Please givee me an example.
Code for Using Keyboard Events?
How to use Client-side Script to Focus Controls in ASP.NET?
Common UI for Multiple web applications. Suppose there are 35 websites using same third party controls.These 3rd party controls are made together that all 35 websites can use these controls.If we put all 3rd party controls and use its dll in 35 websites,only class files will be accessable. But I want to use CSS,images also in all 35 websites. how I can design the N-tier solution for this project.
how to create a search bar which access data from various websites and retrieves the data
How to get Dynamically Linked Comboboxes Set?
Coding for Synchronizing Cache Access in ASP.NET?