How to have two tables on a single dataset?

Question

Can you pls give me a code on how dataset can have more than two tables and how to access each of the table? tnx

send2manivannan · Answer

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