title: Reusing SqlCommand?
body: <p>I am not really sure if this is possible or not.</p>
  
  <p>I am currently working on a college project and I have a function that uses stored procedures. I would like to know if it is possible to take the same <code>SqlCommand</code> instance and apply updated parameters to call into the stored procedure again within the same function.</p>
  
  <p>Lets say i have something like this in my code:</p>
  
  <pre><code>myConStr = ConfigurationManager.ConnectionStrings["MyConnString"].ConnectionString;
  myConn = new SqlConnection(myConStr);
  myCommand = new System.Data.SqlClient.SqlCommand("team5UserCurrentBooks3", myConn); 
  myCommand.CommandType = CommandType.StoredProcedure;
  myCommand.Parameters.AddWithValue("@book_id", bookID);
  myCommand.Parameters.AddWithValue("@user_id", userID);
  
  try
  {
      myConn.Open();
      myCommand.ExecuteNonQuery();
  </code></pre>
  
  <p>Is it possible to update <code>MyCommand</code>'s parameters and call the stored procedure again? </p>