sqlcommand cmd=new sqlcommand();
SqlTransaction myTrans = con.BeginTransaction();
cmd.Transaction = myTrans;
sql语句....
myTrans.Commit();用try...catch
在catch中执行myTrans.RollBack
SqlTransaction myTrans = con.BeginTransaction();
cmd.Transaction = myTrans;
sql语句....
myTrans.Commit();用try...catch
在catch中执行myTrans.RollBack
insert into b (b) vlalues ("b")写入到上面的里面.写好后.分全给你
conn.Open();
SqlCommand cmd = conn.CreateCommand();
SqlTransaction tran = conn.BeginTransaction();
cmd.Transaction = tran;
try
{
cmd.CommandText = "insert into a (a) vlalues ("a")";
cmd.ExecuteNonQuery();
...
cmd.CommandText = "insert into b (b) vlalues ("b")";
cmd.ExecuteNonQuery();
...
}
catch (SqlException)
{
tran.Rollback();
return;
}
finally
{
conn.Close();
}tran.Commit();