title: C# ASP.Net Parameters.AddWithValue rejecting null value for parameter
body: <p>I am populating tables using a stored procedure.  The table allows a 'null' for the middle initial of the name, but I'm getting the following error message:  </p>
  
  <p><strong>Procedure or function 'uspInsertPersonalAccountApplication' expects parameter '@MiddleInitial', which was not supplied.</strong></p>
  
  <p>Thanks in advance!</p>
  
  <pre><code>   public void ProcessForm(string[] InputData)
      {
          string ConnString = System.Configuration.ConfigurationManager.ConnectionStrings["AssociatedBankConnectionString"].ToString();
  
          SqlConnection conn = new SqlConnection(ConnString);
          SqlCommand cmd = new SqlCommand("uspInsertPersonalAccountApplication", conn);
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.AddWithValue("@AccountType", "Savings");
          cmd.Parameters.AddWithValue("@AccountSubType", "Savings");
          cmd.Parameters.AddWithValue("@ExistingCustomer","No");
          conn.Open();
          cmd.ExecuteNonQuery();
  
          conn.Close();
      }
  </code></pre>