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

Question

Hi Frnds I know what is data set or data reader? Now i want to know that for the which situation we can use dataset or data reader?? this is intervw qus...

Joginder Banger · Answer

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

Ravi Patel · Answer

Hi Check this DataSet vs. DataReader http://www.codeproject.com/Articles/420217/DataSet-vs-DataReader Should you use ADO.NET DataReader or DataSet https://www.simple-talk.com/dotnet/.net-framework/should-you-use-ado.net-datareader-or-dataset/