string sendSQL = "UPDATE calendar SET" +
"标题= '" + textBox1.Text + "'," +
"状态= '" + textBox2.Text + "'," +
"更新时间= '" + System.DateTime.Now.ToString("D") + "'," +
"安排= '" + richTextBox1.Text + "'," +
"WHERE 编号= '" + comboBox1.Text + "'"; ;
SqlCommand sqlcmd = new SqlCommand(sendSQL,Myconn);
MessageBox.Show("数据更新成功!", "信息");我是这样的,提示更新成功,但是并没有成功提交数据
"标题= '" + textBox1.Text + "'," +
"状态= '" + textBox2.Text + "'," +
"更新时间= '" + System.DateTime.Now.ToString("D") + "'," +
"安排= '" + richTextBox1.Text + "'," +
"WHERE 编号= '" + comboBox1.Text + "'"; ;
SqlCommand sqlcmd = new SqlCommand(sendSQL,Myconn);
MessageBox.Show("数据更新成功!", "信息");我是这样的,提示更新成功,但是并没有成功提交数据
与DataSet帮定没有
没有的话,
就一行行的取吧,还要转换数据类型
日你姐姐的
你都没有执行
更新个穿穿
用其中的UpdateCommand这个属性,将你的sendSQL给这个属性
最后用DataAdapter.Accept();让数据库接受你的更改
SqlCommand sqlCmd=new SqlCommand("更新语句",sqlCn);
sqlCn.Open();
sqlCmd.ExecuteNonQuery();
sqlCn.Close();
"标题= '" + textBox1.Text + "'," +
"状态= '" + textBox2.Text + "'," +
"更新时间= '" + System.DateTime.Now.ToString("D") + "'," +
"安排= '" + richTextBox1.Text + "'," +
"WHERE 编号= '" + comboBox1.Text + "'"; ;
SqlCommand sqlcmd = new SqlCommand(sendSQL,Myconn);
sqlcmd.ExecuteNonQuery();
MessageBox.Show("数据更新成功!", "信息");