How do I reuse a SQLCommand for say multiple queries?
e.g
SqlCommand mycommand = new SqlCommand("SElect * from BKLAH", myConnection);
mycommand.ExecuteNonQuery();
Now I want to use mycommand again but use a different SQL query. How would I do this?
You can set CommandText property of your command, like this:
mycommand.CommandText = @"UPDATE BKLAH SET a = 5 WHERE id=@id";
I would use it in a USING section.
Command 1:
using (SqlCommand mycommand = new SqlCommand("SElect * from BKLAH", myConnection))
{
mycommand.ExecuteNonQuery();
}
Command 2:
using (SqlCommand mycommand = new SqlCommand("SElect * from BKLAH2", myConnection))
{
mycommand.ExecuteNonQuery();
}
