SqlConnection cn = new SqlConnection("server=(local);database=bank;trusted_connection=true");
cn.Open();
SqlTransaction tran = cn.BeginTransaction(); SqlCommand cmd1 = cn.CreateCommand();
SqlCommand cmd2 = cn.CreateCommand(); cmd1.Transaction = tran;
cmd2.Transaction = tran; try
{
cmd1.CommandText = "insert into userInfo(userId,userName,userSex,userAgg,userAdrees)values('0904001','吴丁','男',19,'湖南岳阳')";
cmd1.ExecuteNonQuery();
cmd2.CommandText = "insert into userInfo(userId,userName,userSex,userAgg,userAdrees)values('0904002','陈冠希','男',19,'湖南岳阳')";
cmd2.ExecuteNonQuery();
MessageBox.Show("事物处理成功");
}
catch(Exception ex)
{
tran.Rollback();
MessageBox.Show("事物处理失败" + ex.Message);
} cn.Close(); 用vs2008执行成功,但是到数据库里面查询 select *from userInfo 里面没有插入的数据!
求解!!!!!!!!
cn.Open();
SqlTransaction tran = cn.BeginTransaction(); SqlCommand cmd1 = cn.CreateCommand();
SqlCommand cmd2 = cn.CreateCommand(); cmd1.Transaction = tran;
cmd2.Transaction = tran; try
{
cmd1.CommandText = "insert into userInfo(userId,userName,userSex,userAgg,userAdrees)values('0904001','吴丁','男',19,'湖南岳阳')";
cmd1.ExecuteNonQuery();
cmd2.CommandText = "insert into userInfo(userId,userName,userSex,userAgg,userAdrees)values('0904002','陈冠希','男',19,'湖南岳阳')";
cmd2.ExecuteNonQuery();
MessageBox.Show("事物处理成功");
}
catch(Exception ex)
{
tran.Rollback();
MessageBox.Show("事物处理失败" + ex.Message);
} cn.Close(); 用vs2008执行成功,但是到数据库里面查询 select *from userInfo 里面没有插入的数据!
求解!!!!!!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货