How can we load multiple tables in a dataset?



How can we load multiple tables in a dataset?..

Answer / Nirmal Singh Sagar

You can load multiple tables in a DataSet by using multiple DataAdapter objects, each one configured to fill a specific table within the DataSet. After setting up the SQL commands for each table (SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand), you can fill the tables with Fill() method.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1 Answers   CGI,


Difference between DataReader and DataAdapter / DataSet and DataAdapter?

3 Answers   TCS,


What provider ADO.net use by default?

10 Answers   Accenture, TCS,


What are the different execute methods of Ado.Net?

1 Answers  


What is the role of clr?

1 Answers  


how Sequence to connect and retrieve data from database using dataset?

1 Answers  


What is the difference between oledb sql server and oledbdotnet provider?

1 Answers  


What is meant by entity framework?

1 Answers  


How to generate XML from a dataset and vice versa?

2 Answers  


What is a datagrid?

4 Answers  


What is XML serialization

1 Answers   Digital GlobalSoft,


What providers do you use to connect to oracle database ?

4 Answers   Digital GlobalSoft,


Categories