最近在写大作业时,给数据库的问题弄懵了! 我想在一个button事件中执行两条语句! 查阅了一些资料。以及结合自身的项目。,发现可以这样实现!
这其实也应该属于批处理
方法一:
比较简单
string Text = @“update 1…;
update 2…”;
方法二:
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connectionString;
conn.Open();
SqlCommand cmd = conn.CreateCommand();
string ModifyString = "";
string ModifyString2 = "";
ModifyString = "UPDATE books SET LCONDITION='可借' where LNAME = '" + lname + "'";
ModifyString2 = "UPDATE sb SET RETURNED_TIME = '" + local_time + "'where SNO = '" + Form1.sn.Trim() + "'AND LNAME = '" + lname + "'";
cmd.CommandText = ModifyString;
cmd.ExecuteNonQuery();
cmd.CommandText = ModifyString2;
cmd.ExecuteNonQuery();
MessageBox.Show("提交成功!");
用两次ExecuteNonQuery();调用!