datareader question

[Guest]

I should know the answer to this but i guess i have to ask: Is there a way to
reset a data reader to the begining? I figure it's a no, but want to be sure

 

[Guest]

Good afternoon,

You're right, data reader is forward only type reader, you can olny move to
next row or next result set.

 

[Guest]

was hoping for some kind of hack of a bug that could be exploited.
Thanks

--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

 

[Mark Rae]

I should know the answer to this but i guess i have to ask: Is there a way
to
reset a data reader to the begining? I figure it's a no, but want to be
sure

You're correct - if you need to do this, you're using the wrong ADO.NET
object...

 

[Guest]

i can't aford the performance issues with using an xml dataset.

 

[Guest]

You can use a DataTable. The TableAdapter actually uses DataReader "under the
hood" to populate the DataTable, then the reader is closed leaving you with a
very nice disconnected DataTable. The slight additional overhead should be
virtually unnoticeable.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net

 

[Mark Rae]

i can't aford the performance issues with using an xml dataset.

???

There are other ADO.NET objects besides XML DataSets...

Have you considerd a "standard" DataSet, or DataTable...?