I have two table Employee and Department and i want to show both tables all data in a Gridview.
my Query is:
SqlConnection con = new SqlConnection(ConnectionString);
String query = "select * from Employee, Department";
SqlCommand cmd = new SqlCommand(query,con);
dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
but it show only first table record in Gridview .