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 |
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Difference between DataReader and DataAdapter / DataSet and DataAdapter?
What provider ADO.net use by default?
What are the different execute methods of Ado.Net?
What is the role of clr?
how Sequence to connect and retrieve data from database using dataset?
What is the difference between oledb sql server and oledbdotnet provider?
What is meant by entity framework?
How to generate XML from a dataset and vice versa?
What is a datagrid?
What is XML serialization
What providers do you use to connect to oracle database ?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)