private void button1_Click(object sender, EventArgs e)
{
string constr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\student\student\stu.mdf;Integrated Security=True";
SqlConnection con = new SqlConnection(constr);
con.Open();
[/code]string sqlstr = "update Reward set RewardId= '" + textBox1.Text.ToString() + "', RewardName= '" + textBox2.Text.ToString() + "'from Reward where studentNo='" + textBox3.Text.ToString() + "'";
SqlCommand cmd = new SqlCommand();[/color]
cmd.Connection = con;
cmd.CommandText = sqlstr;
int r = cmd.ExecuteNonQuery();
con.Close();
if (r == 0)
{
MessageBox.Show("更改失敗！");
}
else
{
MessageBox.Show("更改成功！");
}
}
uj5u.com熱心網友回復：
去掉 from Rewarduj5u.com熱心網友回復：
還是有問題
uj5u.com熱心網友回復：
studentNo 是int還是varchar?uj5u.com熱心網友回復：
是int型變數uj5u.com熱心網友回復：
是int型變數
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/234740.html
標籤：C#
下一篇：WPF列印用哪種好點