title: Pass same value on all parameters?
body: <p>Is it possible to pass value for all the parameter of <code>SqlCommand</code> without hardcoding?</p>
  
  <p>Instead of this:</p>
  
  <pre><code>mySqlCommand1.Parameters.AddWithValue("@Parameter1", "sameValue");
  mySqlCommand2.Parameters.AddWithValue("@Parameter2", "sameValue");
  mySqlCommand2.Parameters.AddWithValue("@Parameter2", "sameValue");
  ...
  </code></pre>
  
  <p>I want some like this:</p>
  
  <pre><code>foreach (SqlParameter parameter in mySqlCommand1.Parameters)
  {
      parameter.Value = someValue;  
  }
  </code></pre>
  
  <p>But I get an error:</p>
  
  <blockquote>
    <p>Procedure or function expects parameter which was not supplied</p>
  </blockquote>