title: Procedure or function has too many arguments specified
body: <p>There are so many questions on SO on this exception. But none of them are useful to me.</p>
  
  <p>Here is my Stored Procedure  :</p>
  
  <pre><code>CREATE PROCEDURE HolidayStandardMappingInsert 
      @HolidayID bigint,
      @StandatdID smallint
  AS
  BEGIN
      INSERT INTO HolidayStandardMapping VALUES(@HolidayID,@StandatdID)
  END
  GO
  </code></pre>
  
  <p>And here is my Code:</p>
  
  <pre><code>int StdId = 0;
                  SqlCommand cmdS = new SqlCommand("HolidayStandardMappingInsert", conn);
                  cmdS.CommandType = CommandType.StoredProcedure;
  
  
                  for (int i = 0; i &lt; cblStandard.Items.Count; i++)
                  {
                      if (cblStandard.Items[i].Selected == true)
                      {
                          if (StdId == 0)
                              StdId = Convert.ToInt32(cblStandard.Items[i].Value);
                          else
                              StdId = Convert.ToInt32(cblStandard.Items[i].Value);
                          cmdS.Parameters.AddWithValue("@HolidayID", NewRecordID);
                          cmdS.Parameters.AddWithValue("@StandatdID", StdId);
                          if (conn.State == ConnectionState.Open)
                          {
                              conn.Close();
                          }
                          conn.Open();
                          int res = cmdS.ExecuteNonQuery();
                          if (res &gt; 0)
                          {
  
                          }
                      }
                  }
  </code></pre>
  
  <p>Tell me what is missing?</p>