DataReader vs DataSet

Question

Hi I had made a windows application with sql server. I have too many rows in my database and filling all the data on my gridview.   I want to know which class best suited to fetch the data, will SqlDataReader provide best performance over dataset.   If I use SqlDataReader, it will be fetched row by row whereas dataset fetch data all at once. Which one to use?   Please guide.

Nitin Sontakke · Accepted Answer

Look no further, go ahead and use SqlDataReader.

Khaja Moizuddin · Answer

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 will fetch the data very fast when compared with dataset. Generally we will use ExecuteReader object to bind data to datareader.
Refer
http://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1

Devendra Kumar · Answer

Thank u nitin sir