How can we load multiple tables in to Dataset?
Submitted by: AdministratorDataSet 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
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
Top ADO.NET Questions
| ☺ | Which one of the following objects is a high-level abstraction of the Connection and Command objects in ADO.NET? |
| ☺ | Difference between SqlCommand and SqlCommandBuilder? |
| ☺ | Can dataReader hold data from multiple tables? |
| ☺ | What provider ADO.net use by default? |
| ☺ | What is different between SqlCommand object and Command Behavior Object? |
Top Dot Net Technologies Categories
| ☺ | MSF Interview Questions. |
| ☺ | .Net Architecture Interview Questions. |
| ☺ | ASP.Net MVC Interview Questions. |
| ☺ | Entity Framework Interview Questions. |
| ☺ | C# (Sharp) Programming Language Interview Questions. |
