How can we load multiple tables into Dataset

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]'

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);

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.