Load multiple tables in a data set, DOT NET Programming

How can we load multiple tables in a DataSet ?

objCommand.CommandText = "Table1"

objDataAdapter.Fill(objDataSet, "Table1")

objCommand.CommandText = "Table2"

objDataAdapter.Fill(objDataSet, "Table2")

The sample code above shows how to load multiple "DataTable" objects in one

"DataSet" object. The Sample code shows two tables "Table1" and "Table2" in the object ObjDataSet.

lstdata.DataSource = objDataSet.Tables("Table1").DefaultView

Posted Date: 9/24/2012 2:52:17 AM | Location : United States







Related Discussions:- Load multiple tables in a data set, Assignment Help, Ask Question on Load multiple tables in a data set, Get Answer, Expert's Help, Load multiple tables in a data set Discussions

Write discussion on Load multiple tables in a data set
Your posts are moderated
Related Questions
What is a dynamic update? Dynamic update is a powerful feature of WF that describes the ability of WF to modify the implementation path of a running workflow. This feature is u

Question: (a) One problem encountered when designing web applications is that HTTP is a "stateless" protocol. Explain two general approaches to solve the statelessness problem

What is a candidate key? A table may have more than one combination of columns that could uniquely identify the rows in a table; every combination is a candidate key. During th

If one of your validations is complicated and does not fit in any validators, what you do? The best way is to go for CustomValidators. The sample code for a custom validator

What is a cloud? A cloud is a combination of hardware, storage, networks, services, and interfaces that helps in delivering computing as a service. It has generally three users

Develop a iPhone and Android mobile game Project Description: I am seeking a developer to create a mobile game for me. I need an endless runner game with simple controls. The

Question: (a) Prepare a diagram which explains where the different elements like Form, Window and Document, belong in the Document Object Model hierarchy and how properties are

What are Windows services? Windows services, previously called as NT services, are applications that are installed on the system as system services. In other words, Windows ser

Web application and XML data storage One person should create a library (Java package of classes) for managing the list of bibliography entries, and for saving and loading th

What are the features of ADO.Net ?  ADO.NET features: 1. Disconnected Data Architecture 2. Data cached in Datasets 3. Data transfer in XML format 4. Interaction wit