using (SqlCommand cmd = new SqlCommand(strSql, this.conn))
{
//给SqlCommand加事务
if (inTransaction)
cmd.Transaction = trans; //执行SQL语句
try
{
cmd.Connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException e)
{
cmd.Connection.Close();
throw e;
} }
{
//给SqlCommand加事务
if (inTransaction)
cmd.Transaction = trans; //执行SQL语句
try
{
cmd.Connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException e)
{
cmd.Connection.Close();
throw e;
} }
{
//给SqlCommand加事务
if (inTransaction)
cmd.Transaction = trans; //执行SQL语句
try
{
cmd.Connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException e)
{
throw e;
}
finally
{
cmd.Connection.Close();
} }
所以没必要再自己写个 finally 实现回收!
我实验过了,他就是不释SQL连接
所以没必要再自己写个 finally 实现回收!4楼说的没错
没看清楚代码吧?他using 里的是SqlCommand cmd = new SqlCommand(strSql, this.conn)能关conn吗?