How to have two tables on a single dataset?

Simple, Ur SQL Statement is Like this, "Select * From Table1;Select * From Table2;Select * From Table3"; After Executing this, Your DataSet have 3 Tables, If you want access these tables, use, ds.Tables[0].Rows[0][0] //Returns table1 - First Row - First Col value ds.Tables[1].Rows[0][0] //Returns table2 - First Row - First Col value ds.Tables[2].Rows[0][0] //Returns table3 - First Row - First Col value -Mani