SqlTransaction t = this.sqlConn.BeginTransaction();
SqlCommand cmd = new SqlCommand();
int result = 0; cmd.Transaction = t;
cmd.Connection = this.sqlConn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "Insert_Ear_ReleaseDetial"; cmd.Parameters.Add("@ReleaseID", SqlDbType.BigInt, 8, "ReleaseID");//该参数在此已增加
cmd.Parameters.Add("@PackageID", SqlDbType.Int, 4, "PackageID");
cmd.Parameters.Add("@PackageNumber", SqlDbType.NVarChar, 25, "PackageNumber");
cmd.Parameters.Add("@BoxID", SqlDbType.Int, 4, "BoxID");
cmd.Parameters.Add("@ApplyID", SqlDbType.Int, 4, "ApplyID");
cmd.Parameters.Add("@RegionCode", SqlDbType.Int, 4, "RegionCode");
cmd.Parameters.Add("@AnimalType", SqlDbType.Int, 4, "AnimalType"); this.sqlAdapter.InsertCommand = cmd;
result = this.sqlAdapter.Update(tableInfo); //出现错误,System.Data.SqlClient.SqlException: 过程或函数 'Insert_Ear_ReleaseDetial' 需要参数 '@ReleaseID',但未提供该参数。
但我在代码中已明确包含了这个参数的,怎么会出现这个错误呢?
SqlCommand cmd = new SqlCommand();
int result = 0; cmd.Transaction = t;
cmd.Connection = this.sqlConn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "Insert_Ear_ReleaseDetial"; cmd.Parameters.Add("@ReleaseID", SqlDbType.BigInt, 8, "ReleaseID");//该参数在此已增加
cmd.Parameters.Add("@PackageID", SqlDbType.Int, 4, "PackageID");
cmd.Parameters.Add("@PackageNumber", SqlDbType.NVarChar, 25, "PackageNumber");
cmd.Parameters.Add("@BoxID", SqlDbType.Int, 4, "BoxID");
cmd.Parameters.Add("@ApplyID", SqlDbType.Int, 4, "ApplyID");
cmd.Parameters.Add("@RegionCode", SqlDbType.Int, 4, "RegionCode");
cmd.Parameters.Add("@AnimalType", SqlDbType.Int, 4, "AnimalType"); this.sqlAdapter.InsertCommand = cmd;
result = this.sqlAdapter.Update(tableInfo); //出现错误,System.Data.SqlClient.SqlException: 过程或函数 'Insert_Ear_ReleaseDetial' 需要参数 '@ReleaseID',但未提供该参数。
但我在代码中已明确包含了这个参数的,怎么会出现这个错误呢?
Insert Into Ear_ReleaseDetial(ReleaseID,PackageID,PackageNumber,BoxID,ApplyID,RegionCode,AnimalType) Values(@ReleaseID,@PackageID,@PackageNumber,@BoxID,@ApplyID,@RegionCode,@AnimalType)