hi!!!
on button click event
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from tablename", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
con.Close();
}