C# re-using SQLCommand

Question

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?

Accepted Answer

You can set `CommandText` property of your command, like this:

```
mycommand.CommandText = @"UPDATE BKLAH SET a = 5 WHERE id=@id";
```

C# re-using SQLCommand

Solution

Problem