MyConnect = new SqlConnection("server=xxxx;database=中文北風;uid=sa;pwd=xxxx");
string Updatecmd = "update 產品 set 產品編號=@Item_num,,品名=@Name,價錢=@Price where 產品編號=@Item_num";
MyConnect.Open();
SqlCommand MyCommand = new SqlCommand(Updatecmd, MyConnect);
MyCommand.Parameters.Add("@Item_num", SqlDbType.Int).Value = Convert.ToInt32(TextBox1.Text);
MyCommand.Parameters.Add("@Name", SqlDbType.VarChar).Value = TextBox2.Text;
MyCommand.Parameters.Add("@Price", SqlDbType.SmallMoney).Value = Convert.ToInt32(TextBox3.Text);
MyCommand.ExecuteNonQuery();
MyConnect.Close();
更新1:
執行update動作