c# 事务回滚

来源:互联网 发布:淘宝客服聊天记录恢复 编辑:程序博客网 时间:2024/04/28 04:49

string  str="server=.;initial catalog=mytest;integrated security=true;" 

using( SqlConnection conn = new SqlConnection(str))

{
 using(SqlCommand command = conn.CreateCommand())

{

conn.Open();
SqlTransaction transaction =conn.BeginTransaction();
command.Transaction = transaction;
try
{
               command.CommandText = "insert into company values('AA','AAAA','true','null')";
                command.ExecuteNonQuery();
                 transaction.Commit();
}
catch
{

                transaction.Rollback();

}

}

}

         

原创粉丝点击