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

Assignment Help:

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.


Related Discussions:- Add relation''s between table in a data set

Namespace-difference between namespace & assembly, NameSpace Namespace co...

NameSpace Namespace consists of 2  main basic functionality :- NameSpace Logically types group , ex. System.Web.UI logically groups our UI related features. In Object O

Difference between thread and process, What is the difference between threa...

What is the difference between thread and process? The thread is a path of execution which can run on CPU; a process is a collection of threads that share the same virtual memo

Mention different types of data providers available in .net, Mention differ...

Mention different types of data providers available in .NET Framework. .NET Framework Data Provider for SQL Server - Give access to Microsoft SQL Server 7.0 or later version. I

What are the advantages of distributed processing, What are the advantages ...

What are the advantages of Distributed Processing? Benefits of distributed programming are:- a. Security/Encapsulation b. Faster Problem solving c. Distributed databas

Different accessibility levels in .net, What are the different accessibilit...

What are the different accessibility levels in .NET? The five levels of access modifiers are as follows:- Private: The members of the class only have the access.

Need to get a windows desktop application developed, Need to get a windows ...

Need to get a windows desktop application developed Project Description: I am looking to obtain a desktop application developed. The desktop application will have the subsequ

I want workflow designer, I want Workflow Designer (HTML5) Project Descr...

I want Workflow Designer (HTML5) Project Description: I am seeking an HTML5 designer for a custom workflow tool. It should have drop and drag functionality. Saving it as XML

Different types of replication supported by sql server, What are the differ...

What are the different types of replication supported by SQL SERVER? There are 3  types of replication supported by SQL SERVER which are shown below:- 1) Snapshot Replicati

What is difference between system.string, What is difference between System...

What is difference between System.String and System.StringBuilder classes? String and StringBuilder classes are used to store string values but the dissimilarity in them is tha

What is language integrated query, What is Language Integrated Query (LINQ)...

What is Language Integrated Query (LINQ)? LINQ is a programming model that is the composition of general-purpose standard query operators that permit you to work with data, reg

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