Drag and Drop One GridView Control an then.
follow this.
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=practice;integrated security=true;");
SqlCommand sqlcomm = new SqlCommand("select * from TableName", sqlconn);
sqlconn.Open();
SqlDataReader dr = sqlcomm.ExecuteReader();
if (dr.HasRows)
{
GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close();
sqlconn.Close();
}
}