GridView绑定SqlDataReader自动关闭连接

代码

using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(PetShop.DBUtility.SqlHelper.ConnectionStringLocalTransaction))
{
using (System.Data.SqlClient.SqlDataReader dr = PetShop.DBUtility.SqlHelper.ExecuteReader(conn
, System.Data.CommandType.Text
, " Select * from Orders "
, null ))
{
GridView1.DataSource = dr;
GridView1.DataBind();
}
}

 

代码

public static SqlDataReader ExecuteReader(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
// we use a try/catch here because if the method throws an exception we want to
// close the connection throw code, because no datareader will exist, hence the
// commandBehaviour.CloseConnection will not work
try
{
PrepareCommand(cmd, connection, null , cmdType, cmdText, commandParameters);
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return rdr;
}
catch
{
connection.Close();
throw ;
}

}

 

转载于:https://www.cnblogs.com/qhnokia/archive/2010/02/22/1670932.html