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 table1","conn"); dataset ds= new dataset(); da.fill(ds,"table1");// here table1 is the virtual table name for the result set 1 da=new sqladaptor("select * from table2","conn"); da.fill(ds,"table2");//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.

How can we load multiple tables into Dataset

Answers (4)