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 normalization & what are the types of normalization? Normalization is a set of rules that have been established to aid in the design of tables that are meant to be conn


I have a website with a photo gallery using PhotoHandler -photohandler.codeplex.com I require the code added/ modified to display the image file names under the preview or thumbnai

What are design patterns? The Design patterns are recurring solution to the recurring problems in the software architecture. There are 3 basic classification of patterns Behavi

What are the naming conventions required for XML elements tags? The following are the naming conventions that need to be followed for XML elements tags: Element names should

What is difference between abstract classes and interfaces? The difference b/w abstract and interfaces are s follows:- 1.     The Abstract classes can have concrete methods

Set up a FTP File Server and active FTP File Transfer using VB.NET The Job Description is as given: 1. Manually set up a FTP file server on a remote server. 2. Manually ad

What are Assemblies? Assembly is a single deployable unit that have information about the implementation of classes, structures and interfaces. It also keeps the information ab

How can we identify that the Page is PostBack? The Page object has the "IsPostBack" property which can be checked to know that the page is posted back.