when we use data reader or when we use data set in asp.net?

Hi Anjalli Khan,

 

This is very basic question and lot's of link are available on Google.com Don't worry I will try solve your problem and with example.

 

Difference is difference between Data Reader and dataset.

 

DataReader:

DataReader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database. DataReader is used to iterate through resultset that came from server and it will read one record at a time because of that memory consumption will be less and it will fetch the data very fast when compared with dataset. Generally we will use ExecuteReader object to bind data to datareader. 

 

DataSet :

DataSet is a disconnected orient architecture that means there is no need of active connections during work with datasets and it is a collection of DataTables and relations between tables. It is used to hold multiple tables with data. You can select data form tables, create views based on table and ask child rows over relations. Also DataSet provides you with rich features like saving data as XML and loading XML data. 

 

Your Question is which time are used both.

Dataset : suppose you have bind three dropdown control. you have two option one connect database for each Dropdown control or get the all three tables data and hold in Dataset.

I think second option are good.

 

Dataset objdataSet= GetDataFromDatabase();

 

objdataSet.Tables[0]; //First tables

objdataSet.Tables[1]; //second Tables

objdataSet.Tables[2]; //Thrid Tables