Load multiple tables in a data set, DOT NET Programming

Assignment Help:

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


Related Discussions:- Load multiple tables in a data set

Why does an organization need to manage the workloads, Why does an organiza...

Why does an organization need to manage the workloads? The workload can be explained as an independent service or a set of code that can be implemented. It can be everything f

What are runtime services, What are runtime services? Runtime services ...

What are runtime services? Runtime services having of predefined and user-defined classes that are available to the workflow runtime engine during implementation to customize t

Asp.net authentication process, Can you explain how the ASP.NET authenticat...

Can you explain how the ASP.NET authentication process works?   The ASP.NET does not run by itself, it runs inside the process of the IIS. So there are 2  authentication layer

Explain dataset accept changes, Explain Dataset Accept Changes and Data Ada...

Explain Dataset Accept Changes and Data Adapter Update methods?  Data Adapter Update method Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated

Show the structure of the global.asax file, Question: (a) Write extrac...

Question: (a) Write extract codes to show the structure of the Global.asax file. (b) Outline four classes that allow you to work with File Streams. (c) When working with

Encripter-decripter application, Encripter-Decripter application Project...

Encripter-Decripter application Project Description: I want an application which can encrypt - decrypt text, images, and music files as well as videos. Skills required are

Finding maximum & minimum numbers - c# program, Finding Maximum & Minimum N...

Finding Maximum & Minimum Numbers - C# Program I am facing some problems in the code for Finding Maximum & Minimum Numbers. Can anybody suggest me the proper code for it.

What do you understand by soap encoding, What do you understand by SOAP enc...

What do you understand by SOAP encoding? The Serialization of the types, such as integers and strings, inside a SOAP message is known as encoding. The SOAP objects use XML elem

Define assembly-types of assembly, Assembly: 1) Assembly is a unit of d...

Assembly: 1) Assembly is a unit of deployment such as EXE or a DLL. 2) An assembly consists one or more files (dlls, exe's, html files etc.),& represents a group of resources,

How do we provide parameters to the stored procedures?, The ADO.NET gives t...

The ADO.NET gives the SqlCommand object which gives the functionality of executing the stored procedures. CREATE PROCEDURE SelectByEmployee @FirstName nvarchar(200) AS Se

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd