Add relation''s between table in a data set, DOT NET Programming

How can we add relation's between table in a DataSet?

Dim objRelation As DataRelation

 objRelation=New DataRelation("CustomerAddresses",objDataSet.Tables("Customer").Columns("Custid") ,objDataSet.Tables("Addresses").Columns("Custid_fk"))

objDataSet.Relations.Add(objRelation)

The Relations can be added between "DataTable" objects by using the "DataRelation" object. The  sample code Above is trying to build a relationship between "Customer" and "Addresses" "Datatable" by using the "CustomerAddresses" "DataRelation" object.

Posted Date: 9/24/2012 5:12:39 AM | Location : United States







Related Discussions:- Add relation''s between table in a data set, Assignment Help, Ask Question on Add relation''s between table in a data set, Get Answer, Expert's Help, Add relation''s between table in a data set Discussions

Write discussion on Add relation''s between table in a data set
Your posts are moderated
Related Questions
What do you mean by data encapsulation? Data encapsulation is a method of binding data and code in single unit known as object and hiding all the implementation details of a cl

What is a candidate key? A table may have more than one combination of columns that could uniquely identify the rows in a table; every combination is a candidate key. During th

VB.NET Questions Project Description: Need help to solve questions of VB.NET Skills required: .NET, Software Development, C# Programming, Visual Basic, Windows Deskt

What are major events in GLOBAL.ASAX file? The Global.asax file, which is derived from the HttpApplication class, maintains a pool of the HttpApplication objects, & assigns the

I need Isometric Exploration Tablet Game I am endeavoring to build an 2D tile-based isometric game, primarily for Android and iOS tablet devices. It will be built in Unity 3d v4


C# API to grab option price from CBOE web site Project Description: On the web page below, user will download option prices of Stock or Index. For example, if you put "VXX" i

Write a XML with database with book details (BOOK ID, Title, Author, subject, published Year, language, vendor, price)

Program of Nested Loop - C# Program I am a learner of C# language and i am struggling with the Loops in c#. Can you have any code examples for this.

Consuming a web service with SOAP on c# .NET Project Description: I need to consume a web service with SOAP. I have xml file and some description. I need it to be done