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

Tracking company''s activities through several projects, ASP.NET/MSSQL/ MVC...

ASP.NET/MSSQL/ MVC completing backend solution + integrating with frontend. Project Description: System is used for tracking company's activities through several projects by

Advantages of sql 2000 over sql 7.0, What are advantages of SQL 2000 over S...

What are advantages of SQL 2000 over SQl 7.0? 1)User-Defined Functions: The User-Defined Functions (UDFs) -- one or moreTransact-SQL statements may be used to encapsulate the

I need professional telerik winform, I need Professional TELERIK WinForm ...

I need Professional TELERIK WinForm Project Description: Professional TELERIK Professional assistance in TELERIK WinForm via remote control. Development WinForm in C #

What are tuples, What are tuples? Tuple is a fixed-size collection that...

What are tuples? Tuple is a fixed-size collection that can have elements of either similar or different data types. Same to arrays, a user must have to specify the size of a tu

Allow a webpage and restrict access to other domains, We previously use Sit...

We previously use Site content filtering inside Netkiosk But at present this blocks sites. or keywords We now also require a Whitelist that allows. 1) An entire domain www

Perform arithmetic operation on floating values in c#, Perform Arithmetic o...

Perform Arithmetic operations on Floating Values - C# Program Hello, I've been trying so many codes for this but those codes didn't work well. Please write the code for Perfor

Gantt & pert charts.., help me to prepare the above charts for my online v...

help me to prepare the above charts for my online vegetable selling project

I want text or image printing counter, I want Text/Image printing Counter ...

I want Text/Image printing Counter Project Description: Need your help in our C# programming project. We need to pass this project in two weeks starting from now to pass our

Battleship game, create battleship game

create battleship game

Difference between delete table and truncate table commands, What is the di...

What is the difference between DELETE TABLE and TRUNCATE TABLE commands? Following are differences between delete & truncate commands:- 1)The DELETE TABLE syntax logs the de

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages