Go4Expert - View Single Post - What is the difference between a DataTable and a DataReader in ASP?

bzforum

Quote:

Originally Posted by hireaspdeveloper
What is the difference between a DataTable and a DataReader?

DataReader fetches one record at a time..when ever you all theRead() function the next record if there is any gets fetched..now for this the connection to the database has to be open when the read function is called..

on the other Hand

DataTable fetches all the records when you call the Fill() function of the DataAdapter. It keeps the records in memory so that you can use it latter without been connected to the database..This is an Example of .NET Disconnected Architecture ..

DataReader is lighter than DataTable.

bzforum Go4Expert Member
30May2012,12:02
	Quote: Originally Posted by hireaspdeveloper What is the difference between a DataTable and a DataReader? DataReader fetches one record at a time..when ever you all theRead() function the next record if there is any gets fetched..now for this the connection to the database has to be open when the read function is called.. on the other Hand DataTable fetches all the records when you call the Fill() function of the DataAdapter. It keeps the records in memory so that you can use it latter without been connected to the database..This is an Example of .NET Disconnected Architecture .. DataReader is lighter than DataTable.