我正在使用存储过程填充表.该表允许名称的中间首字母’null’,但我收到以下错误消息:
过程或函数’uspInsertPersonalAccountApplication’需要参数’@MiddleInitial’,它未提供.
提前致谢!
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(); }