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

Give benefits of asp.net web controls, Question: (a) Give four benefit...

Question: (a) Give four benefits of ASP.NET Web Controls. (b) List and explain any five properties of the ValidationSummary control. (c) Multiple Web Form controls ca

In which statement the linq query is executed, In which statement the LINQ ...

In which statement the LINQ query is executed? A LINQ query is executed in the For every statement in Visual Basic and in the for each statement in C#.

Want to generate random numbers, want to generate random numbers between 1...

want to generate random numbers between 1-15 and no one should repeat until all numbers have come once....

Connection pooling, Explain the fundamental of connection pooling. When...

Explain the fundamental of connection pooling. Whenever a connection is opened first time a connection pool is created and is based on the exact match of the connection string

CSS, Howto create a simple stylesheet for a web application

Howto create a simple stylesheet for a web application

What is the use of the connection object, What is the use of the Connection...

What is the use of the Connection object? The Connection object is used to connect your application to a specific data source by giving the needed authentication information in

Difference in stored procedure and user defined function, What is the diffe...

What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? Some of major differences between a stored procedure and user defined are as follows:-

Jquery and mvc 4.5 training session, I am looking individuals who have indu...

I am looking individuals who have industry experience working on Microsoft Technology and Jquery ( MVC 4.5 ), who will take live online session and give training through Team Viewe

What is sql cache dependency?, The SQL cache dependencies is a new characte...

The SQL cache dependencies is a new characteristic in ASP.NET 2.0 which can automatically invalidate a cached data object (like a Dataset) when the related data is modified in the

Demonstrating boxing and unboxing - c# program, Demonstrating Boxing and Un...

Demonstrating Boxing and Unboxing - C# Program Hi, Can any of you, tell me how to use boxing and Unboxing in c#?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages