DaniWeb Forum Index > Software Development > C#

C# RSS

Join Two tables as outer join

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2008

Posts: 96

Reputation: Tank50 is an unknown quantity at this point

Solved Threads: 1

Tank50

Offline

Junior Poster in Training

Join Two tables as outer join

May 5th, 2009

HI

I am join two tables without any database,what iam doing is create two datatable from reading excel file and join ad "outer join",I got the coding from internet,and that artical shows how to join two table with "euqi join",So I want to know how to join two tables as outer join.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
DataRelation drel = new DataRelation("EquiJoin", dt1.Columns["Destination"], dt2.Columns["Destination"], true);
ds.Relations.Add(drel);
DataRelation drel = new DataRelation("EquiJoin", dt1.Columns["Destination"], dt2.Columns["Destination"], true);
ds.Relations.Add(drel);