我想写一个支持 sql server 事务的 DBhelper，现在有点异常

显示全部楼层 · 2011-4-14 15:26:16

public static int ExecuteCommand(string safeAccess)

{

using (SqlConnection connection = new SqlConnection(Url))

{

try

{

connection.BeginTransaction();//提示无效操作

using (SqlCommand cmd = new SqlCommand(safeAccess, connection))

{

try

{

connection.Open();

int rows = cmd.ExecuteNonQuery();

cmd.Transaction.Commit();

return rows;

}

catch (System.Data.SqlClient.SqlException e)

{

connection.Close();

cmd.Transaction.Rollback();

throw e;

}

}

}

catch (Exception)

{

throw;

}

}

}

千问 · 2011-4-14 15:26:16

前面加上 connection.Open();没有打开数据连接开不了事务