How can we load multiple tables into Dataset

Question

Hi all How can we load multiple tables into Dataset?

raghu v · Answer

hi the previous answers are clear to explain u doubt and if u are still in confusion i hope u know how to fill the data set using dataadaptor then u can follow the following way to store multi results in a data set sqldatadataptor da = new sqldataadaptor(select * from table1conn); dataset ds= new dataset(); da.fill(dstable1);// here table1 is the virtual table name for the result set 1 da=new sqladaptor(select * from table2conn); da.fill(dstable2);//here table2 is virtual table name for the result set 2 now u can get the data from which ever table set u desired gridview grdview1 =new gridview(); gridview1.datasource=ds.tables[table1];//if u want to use table1 gridview1.datasource = ds.tables[table2];//if u want to use table 2 Note:if u just bind fill the data in to dataset with out virtual names then u can access ur table from data set using index like grdview1.datasource=ds.tables[0];/ds.tables[1]'

Sam Hobbs · Answer

If the previous replies help then please mark one as the one that helped. If hwever they do not help then please clarify what you need.

Pradeep Chandraker · Answer

Create dataset object and add tables you want. DataSet ds = new DataSet(); DataTable dt1 = new DataTable(); ds.Tables.Add(dt1); DataTable dt2 = new DataTable(); ds.Tables.Add(dt2);

Muralidharan Deenathayalan · Answer

From the SQL Stored procedure select * from table1 select * from table2 etc. This will create two tables inside the database. You can manually also create datatable and add it into the dataset.