Inserting Records from another table

[Bijoy Naick]

I need to be able issue a query, then insert each record in the reader
into another table.

But, when I issue the myCommand.ExecuteNonQuery call, I get an error
telling me that a reader is already open and must be closed..

How do i go about doing this?

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Steve C. Orr [MVP, MCSD]]

For two DataReaders to be open at the same time on your page you need two
different connections.
As an alternative you could read your first data into a DataSet instead of a
DataReader.