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
Auto stock market robot Project Description: A total solution for the Robot trading on Nse , currency, Mcx, ncdex,using formulas or using buy sell signals . The solution s

What are the modes of storing ASP.NET session? 1) InProc: - In InProc mode Session state is stored in the memory space of the Aspnet_wp.exe process. That is the default setti

What are design patterns? The Design patterns are recurring solution to the recurring problems in the software architecture. There are 3 basic classification of patterns Behavi

Write a C# program (C# console application) that plays a word game with the user. The program should ask the user to enter the following: • His or her name • His or her age

What is Dataset object ? The DataSet gives the basis for the disconnected storage and manipulation of the relational data. We fill it from the  data store, work with it while d

Introduction This assignment aims to give you a "real world experience" that occurs far too often in the workplace. You have been hired to complete as much as possible a project

HOW TO DESIEN THE CALENDER IN ASP . NET

What is the difference between proc. sent BY VAL and By Ref? By val: changes will not be reflected back to the variable. By ref: changes will be reflected back to that varia

What are Value types and Reference types The Value types directly contain their data which are either allocated on the stack or allocated in-  Line in a  structure. The Refe

Project Description: Hi I am seeking for an MVC developer who is good at Online Store, CMS and Ecommerce. Skills required: .NET, HTML, eCommerce, Shopping Carts, Website D