protected void fillGrid()
{
SqlCommand cmd=new SqlCommand(“Select *from tblEmp”,con);
using(con)
{
con.Open();
SqlDataReader dr=cmd.ExecuteReader();
if(dr.HasRows)
{
GridView1.DataSource=dr;
GridView1.DataBind();
}
con.Close();
dr.Close();
}
}
Chandradev's Blog 