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

Hash table, What is a Hash Table? You can access an array using the IND...

What is a Hash Table? You can access an array using the INDEX value of that array, but how many times you know the real value of the index. The Hashtable provides a way of acce

What is the datacontext class, What is the DataContext class and how is it ...

What is the DataContext class and how is it related to LINQ? After you add a LINQ to SQL Classes item to a project and open the O/R Designer, the empty design surface shows an

Difference between an ado.net dataset and an ado recordset, Explain the dif...

Explain the difference between an ADO.NET Dataset and an ADO Recordset. The two main basic differences between recordset and dataset are as shown below :- 1) With the datase

In what order do the events of an aspx page execute, In what order do the e...

In what order do the events of an ASPX page execute. As a developer is it important to understand these events?   If you try to access it in Page_Load that is way previous than

Require a visual basic app developer, I require a visual basic (VB) app dev...

I require a visual basic (VB) app developer to enhance an existing application. There are very few manual inputs in the application which I need to be imported via excel file. E

Need expert web developer, Web Developer Project Description: We are ...

Web Developer Project Description: We are in need of an expert web developer for long term connection; please apply with samples if you have the subsequent skills: ASP.NET

Demonstrating use of break, Demonstrating use of break, continue & goto - C...

Demonstrating use of break, continue & goto - C# Program How can i use break, continue & goto in my assignment, I am looking for a program in C#. It would be feel great if any

Develop a mobiledata collection system, Project Description: Section - M...

Project Description: Section - Mobile Data Collection System Using the Microsoft Mobile .Net Framework or .Net Compact Framework and ASP.NET web technology develop a mobile d

C# program, Write a program interactively two integers using the method con...

Write a program interactively two integers using the method console.readline and int.parse and display their sum

Implement prototype pattern in .net, How do you implement prototype pattern...

How do you implement prototype pattern in .NET? The Cloning is achieved by using the ICloneable of the System namespace. It has a "Clone" method that actually returns the refer

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