Command object

Hi,

I have a command objec which I use to return a datareader object. Then I want to use the same command object to update a table in my database.

However, when I try to change the commandtext property I receive the following error:

The OleDbCommand is currently busy Open, Fetching.

Any ideas why??

thanks,

Because DataReader is a forward only reading of the database and keeps the connection busy waiting for .Read.

you need to close the DataReader.

doh.