Email: Password:       Forgot Password 
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
Difference between data reader & data set...?

Posted On: 07/12/2012 07:43:35
DataReader is connected object and one can process the rows that are returned by query, one at a time. It discards every row after you have gone through it and so it is extremely fast.It contains only read-only data, so no updates are allowed using DataReader objects.

In DataReader you can not get the no. of records directly from RecordSet.This is similar to VB 6, ForwardOnly RecordSet.

Meanwhile DataSet is disconnected object type.It uses XML to store data 

Data reader is much faster then dataset if only selection query is their
Posted On: 07/12/2012 07:44:15
data reader is used for retrieve data from data source but data set is memmory based on representaion of catched set of recored and it is dissconnected environment.
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us