How to close SqlConnection in SQLHelper.ExecuteReader method

 Hi vinu@asp,

 Refer the below code.

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
string query = "SELECT TOP 5 CustomerId, Name, Country FROM Customers";
SqlDataReader sdr = SqlHelper.ExecuteReader(con, CommandType.Text, query);
GridView2.DataSource = sdr;
GridView2.DataBind();
con.Close();