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();

}

}

 

 

 

免责声明：本文为网络用户发布，其观点仅代表作者个人观点，与本站无关，本站仅提供信息存储服务。文中陈述内容未经本站证实，其真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。