dotnet下ADO 操作 SQLServer 事务处理

private static readonly string strCon = "server=.;database=test;uid=sa;pwd=123";

SqlConnection con = new SqlConnection(strCon);

public string aaa()

{

con.Open();

SqlTransaction sta = con.BeginTransaction(IsolationLevel.ReadCommitted, "aaa");

SqlCommand cmd = con.CreateCommand();

cmd.Connection = con;

cmd.Transaction = sta;

try

{

cmd.CommandText = "insert into t1 (tAction) values ('a3')";

cmd.ExecuteNonQuery();

cmd.CommandText = "insert into t1 (tAction) values ('a4')";

cmd.ExecuteNonQuery();

sta.Commit();

return "success";

}

catch (Exception e)

{

try

{

sta.Rollback();

}

catch (SqlException ex)

{

if (sta.Connection != null)

{

return "An exception of type " + ex.GetType().ToString();

}

return e.GetType().ToString();

}

finally

{

con.Close();

}