simon29
December 5th, 2002, 04:43 AM
Hi,
I want to know if its possible, with the same SqlCommand, first execute a ExecuteNonQuery(), and then change the SqlCommand.Text and execute an ExecuteReader().... because it doesn´t work.
When I try to do the same, but with two different SqlCommand objects, it doen´s work again. The ExecuteReader trhows an exeption.... what should I do? Do I have to close the connection and then open it again?
Many thanks in advance!
I want to know if its possible, with the same SqlCommand, first execute a ExecuteNonQuery(), and then change the SqlCommand.Text and execute an ExecuteReader().... because it doesn´t work.
When I try to do the same, but with two different SqlCommand objects, it doen´s work again. The ExecuteReader trhows an exeption.... what should I do? Do I have to close the connection and then open it again?
Many thanks in advance!