datareader question

[=?Utf-8?B?V2ViQnVpbGRlcjQ1MQ==?=]

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
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[=?Utf-8?B?TWlsb3N6IFNrYWxlY2tpIFtNQ0FEXQ==?=]

Good afternoon,

You're right, data reader is forward only type reader, you can olny move to
next row or next result set.
--
Milosz
"WebBuilder451" wrote:

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
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[=?Utf-8?B?V2ViQnVpbGRlcjQ1MQ==?=]

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
"Milosz Skalecki [MCAD]" wrote:

Good afternoon,

You're right, data reader is forward only type reader, you can olny move to
next row or next result set.
--
Milosz
"WebBuilder451" wrote:

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
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[=?Utf-8?B?V2ViQnVpbGRlcjQ1MQ==?=]

i can't aford the performance issues with using an xml dataset.
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
"Mark Rae" wrote:

"WebBuilder451" <We***********@discussions.microsoft.comwrote in message
news:BF**********************************@microsof t.com...

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...

[Mark Rae]

"WebBuilder451" <We***********@discussions.microsoft.comwrote in message
news:BF**********************************@microsof t.com...

>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...

[Mark Rae]

"WebBuilder451" <We***********@discussions.microsoft.comwrote in message
news:C8**********************************@microsof t.com...

>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...?

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

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


"WebBuilder451" wrote:

i can't aford the performance issues with using an xml dataset.
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
"Mark Rae" wrote:

"WebBuilder451" <We***********@discussions.microsoft.comwrote in message
news:BF**********************************@microsof t.com...

>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...