C#实现数据库事务
C#如何实现数据库事务处理,下面为源代码
+展开
-C#
public static int ExecuteNoQueryWithTrans(string strSQL)
{
SqlConnection conn =null;
SqlCommand cmd = null;
SqlTransaction tran = null;
int i = 0;
try
{
conn = GetConnection();
conn.Open();
tran = conn.BeginTransaction();
cmd = new SqlCommand(strSQL,conn,tran);
i = cmd.ExecuteNonQuery();
tran.Commit();
}
catch(System.Data.SqlClient.SqlException e)
{
tran.Rollback();
}
finally
{
if(conn!=null)
conn.Dispose();
if(cmd!=null)
cmd.Dispose();
if(tran!=null)
tran.Dispose();
}
return i;
}
{
SqlConnection conn =null;
SqlCommand cmd = null;
SqlTransaction tran = null;
int i = 0;
try
{
conn = GetConnection();
conn.Open();
tran = conn.BeginTransaction();
cmd = new SqlCommand(strSQL,conn,tran);
i = cmd.ExecuteNonQuery();
tran.Commit();
}
catch(System.Data.SqlClient.SqlException e)
{
tran.Rollback();
}
finally
{
if(conn!=null)
conn.Dispose();
if(cmd!=null)
cmd.Dispose();
if(tran!=null)
tran.Dispose();
}
return i;
}
加支付宝好友偷能量挖...