Combine Two Query in One otherwise use SqlAdapter with Dataset.
SqlConnection con = new SqlConnection(ConnectionString);
String query = "select * from Employee1 , Employee2";
SqlCommand cmd = new SqlCommand(query,con);
SqlDataReader dr;
con.Open();
dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
con.Close();