title: can i reuse a C# SqlParameter
body: <p>i am doing a continuously select every 10seconds, so  i thought i would do some premature optimsing and save creating a cmd and paramater objects in everyloop</p>
  
  <p>if i do this in one method</p>
  
  <pre><code>public void FirstSelect() {
  
      // select data
      this.cmdSelectData = new SqlCommand(SQL_SELECT_DATA, conn);
  
      this.paramBranchId = new SqlParameter("@branch_id", 1);
      this.cmdSelectData.Parameters.Add(paramBranchId);
  
      // fetch data blah, blah, blah...
  }
  </code></pre>
  
  <p>and then this in another method</p>
  
  <pre><code>public void SecondSelect() {
  
      this.paramBranchId.Value = 2;
     // fetch data
  }
  </code></pre>
  
  <p>would that work as expected, one select using branch 1, one select using branch 2
  or do i need to </p>
  
  <pre><code>this.cmdSelectData.Parameters.Clear();
  ths.cmdSelectData.Parameters.Add(new SqlParameter( // for branch 2)
  </code></pre>
  
  <p>}</p>