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;
            }

        }