We can do this by using DataAdapter's fill Method.Syntax for This is

DataSet ds new DataSet();

SqlDataAdapter dap new SqlDataAdapter(<query1> <connection>);

dap.Fill(ds <TableName> );

SqlDataAdapter dap1 new SqlDataAdapter(<query2> <connection>);

dap1.Fill(ds <TableName1> );

Write the select queries required in fill statement.

e.g.

Adp.Fill( Select * from Table1;Select * from Table2;Select * from Table3 DS)

This statement wil generate Dataset with 3 datatables.

Hi

Actually ....u have to write multiple select statements while creating a dataadapter not in fill() method.

ex: SqlDataadapter da new SqlDataadapter( select statement1; select statement2; ..... connection);

To create multiple datatables in a dataset u have to write multiple select statements........

each select statement creats a datatable in dataset...u can write ; (semicolon) seperated select statements in a command text or u can write as stored procedure ....

By Using SqlAdataAdapter Fill Method

DataSet ds new DataSet();

SqlDataAdapter dap new SqlDataAdapter(Select
* from <tablename> <connection1>);

dap.Fill(ds "TableOne");

SqlDataAdapter dap1 new SqlDataAdapter(Select
* from <tablename> <connection1>);

dap1.Fill(ds "tableTwo");