View All num of num See all Photos Keane www.keane.com Unclaimed Profile Overview Reviews Salaries Interviews Jobs Photos Benefits 279 Reviews 1.8k Salaries 39 Interviews Follow Add Review or Salary Follow Add Review or Salary Interview Question Mid Level Developer Interview Chicago, IL Keane Discuss the difference between a dataset and a datareader. Tags: See more , See less 8 Answer Add Tags Answer Interview Answer 1 Answer ▲ 0 ▼ DataReaderDatareader is like a forward only recordset. It fetches onerow 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.DataSetDataSet 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. Anonymous on Jun 1, 2010 Interviews > Mid Level Developer > Keane Add Answers or Comments To comment on this, Sign In or Sign Up.