Filling the grid View with more than 1 table?

Question

I have the following code

SqlConnection con = new SqlConnection();
con.ConnectionString=@"Data Source=RITESH-PC\SQLEXPRESS;database=master;Integrated Security=true";
 con.Open();
 SqlDataAdapter adp = new SqlDataAdapter("Select * from Employee2",con);
 SqlDataAdapter adp1 = new SqlDataAdapter("Select * from employee1", con);
 DataSet dst=new DataSet();
 DataTable dt= new DataTable();
 DataTable dt1 = new DataTable();

Now please tell me how to show both the tables in 1 Gridview..

Use Union and bind correct column – Ramesh Rajendran Dec 25 '13 at 07:14 — Ramesh Rajendran, Dec 25 '13 at 07:14

score 0 · Answer 1 · answered Dec 25 '13 at 07:11

Try this simple code ..

DataSet dataSet = new DataSet();

using (SqlConnection connection =
           new SqlConnection(connectionString))
{
    connection.Open();
    SqlDataAdapter adapter =
        new SqlDataAdapter ("select t1.* ,t2.* from table1 t1,table2 t2 ", connection);


    adapter.Fill(dataSet);
    MyGridview1.DataSource=dataSet;
    MyGridview1.DataBind();

}

score 0 · Answer 2 · answered Dec 25 '13 at 08:40

U can also make use of Merge function to combine 2 DataTable like this:

SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=RITESH-PC\SQLEXPRESS;database=master;Integrated     Security=true";
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("Select * from Employee2", con);
SqlDataAdapter adp1 = new SqlDataAdapter("Select * from employee1", con);
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();

adp.Fill(dt);
adp1.Fill(dt1);

//After merge u will get merge result in dt.
dt.Merge(dt1);

While merging DataTable make sure schema must match.

Filling the grid View with more than 1 table?

2 Answers2