inner join with DataTables

Question

I have two DataTables. I want to do inner join them into a new Data Table. There is no database access.

First columns of the Data Tables are key field.

 string ParentKeyColumn = dt1.Columns[0].ColumnName;
 string ChildKeyColumn = dt2.Columns[0].ColumnName;

Also I m using Devexpress components.

How can I do this?

James Hill · Accepted Answer · 2011-11-11 15:48:49Z

2

Take a look at this blog post on social.msdn.

Key details:

Define a primary key:

dt2.PrimaryKey = new DataColumn[] { dt2.Columns["Deptno"] };

Define a data relation and add it to your dataset:

DataRelation drel = new DataRelation("EquiJoin", dt2.Columns["Deptno"], dt1.Columns["Deptno"]);

ds.Relations.Add(drel);

answered Nov 11, 2011 at 15:48

James Hill

62.1k22 gold badges150 silver badges166 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mehmet Over a year ago

Thanks James. But I dont have unique columns. Im getting error at this line;dt2.PrimaryKey = new DataColumn[] { dt2.Columns["Deptno"] }; : These columns don't currently have unique values.

Community · Accepted Answer · 2017-05-23 11:55:50Z

0

I would create the DataTable you require programatically and then load the data using LINQ as per the first of the following answers.

Using LINQ

Using Merge

From MSDN Forums

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Nov 11, 2011 at 15:49

Lloyd

2,9422 gold badges23 silver badges18 bronze badges

Collectives™ on Stack Overflow

inner join with DataTables

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related