Populate DataReader

[Guest]

Hi,

How can I populate a DataReader without connection or command? or Hpw
can I store a lot of data in a better way?
I don't have all the data at once.

Thank you,
Roby Eisenbraun Martins

 

[Guest]

Ummm... perhaps you mean a DataTable? Or a DataSet?

 

[Guest]

Yeah, in ADO.NET DataReaders are meant for connected access to data whereas
DataSets and DataTables are meant for disconnected access. A DataReader is
essentially a forward only cursor which points to a single row in a table,
thus it has to be connected to that table. If you are dealing with
disconnected data, store it in DataTables within a DataSet.