SqlConnection conn = new SqlConnection(DB_CONN_STRING.ConnectionString);
string strCmdText = "UPDATE Item SET Supplier = @supplier where ListPrice = @ID";
SqlCommand cmd = new SqlCommand(strCmdText, conn);
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Decimal);
SqlParameter pSUPP = new SqlParameter("@supplier", SqlDbType.VarChar);
pID.Value = new decimal(16.5);
pSUPP.Value = 2;
cmd.Parameters.Add(pID);
cmd.Parameters.Add(pSUPP);
cmd.ExecuteNonQuery();为什么最后一句爆了阿,正确的应该是怎样的亚
string strCmdText = "UPDATE Item SET Supplier = @supplier where ListPrice = @ID";
SqlCommand cmd = new SqlCommand(strCmdText, conn);
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Decimal);
SqlParameter pSUPP = new SqlParameter("@supplier", SqlDbType.VarChar);
pID.Value = new decimal(16.5);
pSUPP.Value = 2;
cmd.Parameters.Add(pID);
cmd.Parameters.Add(pSUPP);
cmd.ExecuteNonQuery();为什么最后一句爆了阿,正确的应该是怎样的亚
string strCmdText = "UPDATE Item SET Supplier = @supplier where ListPrice = @ID";
SqlCommand cmd = new SqlCommand(strCmdText, conn);
cmd.Parameters.Add("@supplier",pSUPP);
cmd.Parameters.Add("@ID",pID);
cmd.ExecuteNonQuery();
XXX
XXX
conn.close();