UC知道.NET 事务 锁定(锁住)(c#)
来源：百度知道 编辑：UC知道 时间：2024/06/22 08:59:29
可返回回滚错误,但实现不了锁定的功能.错在哪里呢?这是我锁定按钮的代码~
private void btnlock_Click(object sender, EventArgs e)
{
btnup.Enabled = true;
//ConnectionStringSetting cnSetting = ConfigurationManager.ConnectionStrings["server=192.168.1.104;database=getage;uid=sa;pwd=123"];
//cn.ConnectionString = cnSeting.ConnectionString;
//cn.Open();
//cn.ConnectionString = "server=192.168.1.104;database=getage;uid=sa;pwd=123";
//cn.Open();
cn = new SqlConnection("server=192.168.1.104;database=getage;uid=sa;pwd=123");//初始化连接
cn.Open();
SqlCommand cmd = cn.CreateCommand();
SqlTransaction sqlTransaction = cn.BeginTransaction(System.Data.IsolationLevel.Serializable); // 开启事务
cmd.Connection = cn;
cmd.Transaction = sqlTransaction; // 将事务应用于Command
private void btnlock_Click(object sender, EventArgs e)
{
btnup.Enabled = true;
//ConnectionStringSetting cnSetting = ConfigurationManager.ConnectionStrings["server=192.168.1.104;database=getage;uid=sa;pwd=123"];
//cn.ConnectionString = cnSeting.ConnectionString;
//cn.Open();
//cn.ConnectionString = "server=192.168.1.104;database=getage;uid=sa;pwd=123";
//cn.Open();
cn = new SqlConnection("server=192.168.1.104;database=getage;uid=sa;pwd=123");//初始化连接
cn.Open();
SqlCommand cmd = cn.CreateCommand();
SqlTransaction sqlTransaction = cn.BeginTransaction(System.Data.IsolationLevel.Serializable); // 开启事务
cmd.Connection = cn;
cmd.Transaction = sqlTransaction; // 将事务应用于Command
楼主,你应该分清什么叫锁机制,并不是回滚就锁住,只有操作那条数据的时候才会锁定,操作完成,释放排它锁.
别人当然可以修改了.UPDATE Stu这个是什么sql语句,不完整吧?????你可以给你的表增加一个"锁定"的字段 ,然后不允许用户通过sql语句去更新表,而是通过程序界面.你想在sql语句里限制更新,那你程序页跑步起来