Devendra Kumar

Devendra Kumar

  • NA
  • 500
  • 163.4k

DataReader vs DataSet

Dec 20 2016 11:45 AM
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.
 
 

Answers (3)