Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/1/30 1:57:17
用CommandBehavior自动关闭与之相关联的conn_[Asp.Net教程]

用CommandBehavior自动关闭与之相关联的conn_[Asp.Net教程]

cmd.ExecuteReader的参数CommandBehavior.CloseConnection会自动帮你关闭与之相关联的conn

public static SqlDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{

SqlCommand cmd = new SqlCommand();

SqlConnection conn = new SqlConnection(connectionString);

try
{

PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);

// 给cmd.ExecuteReader加上参数CommandBehavior.CloseConnection会在cmd.ExecuteReader执行完后自动关闭与之相关联的conn
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

cmd.Parameters.Clear();

return rdr;

}

catch
{

conn.Close();

throw;

}

}
http://www.cnblogs.com/abeen/archive/2006/12/19/597039.HTML



赞

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)




QQ:154298438
QQ:417480759