Introduction:
In this article, i am going to explain how to bind a multiple datatables into single datagrid.

Main:

We can easily merge more than one dataset using ds.merge option,

Common Syntax,

DataSet ds = new DataSet(); DataTable dt=new DataTable(); ds.merge(dt);

Sample Code:

OracleConnection conn = new OracleConnection(); conn = "Data Source=sample;User ID="sample";Password="sample123""; OracleDataAdapter da = new OracleDataAdapter("select * from emp where rownum<10", conn); DataSet ds = new DataSet(); da.Fill(ds); OracleDataAdapter da1 = new OracleDataAdapter("select * from emp where rownum>10 and rownum<20", conn); DataSet ds1 = new DataSet(); da.Fill(ds1); ds.merge(ds1); DataGrid local_grid = new DataGrid(); local_grid.DataSource = ds; local_grid.DataBind();

Conclusion:
Hope this helps,
Happy Coding.