How to persist datareader

[AndrusM]

My C# WinForms 1.1 application uses same datareader query a lot of times and it is allowed that it can use cached result from previous datareader creation. How to cache result obtained by datareader in memory so that in next time cached query result is returned instead of making trip to server? Or is it better to use DataTable and cache DataTable in memory?

Andrus

[Guffa]

A DataReader only reads the data from the database, it doesn't contain the data. So if you want to persist the data, a DataSet or a DataTable would be what you would use.

--- Year happy = new Year(2007);

[karam chandrabose]

Datareader is always connected, better go for datatable to persist stuff!

[sno 1]

be more explicit, and tell my if you need still this answer yet regards