How can we load multiple tables in to Dataset?

Submitted by: Administrator
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");
Submitted by: Administrator

Read Online ADO.NET Job Interview Questions And Answers