using System;

using System.Collections.Generic;

using System.Linq;

using System.Data;

using System.Xml;

public class Program

{

    public static void Main()

    {

        DataTable tableA = new DataTable();

            tableA.Columns.Add("ACol1",typeof(string));

            tableA.Columns.Add("ACol2", typeof(string));

            tableA.Columns.Add("ACol3", typeof(string));

​

            DataTable tableB = new DataTable();

            tableB.Columns.Add("BCol1", typeof(string));

            tableB.Columns.Add("BCol2", typeof(string));

            tableB.Columns.Add("BCol3", typeof(string));

​

            DataRow row1 = tableA.NewRow();

            row1["ACol1"] = "1";

            row1["ACol2"] = "tbA12";

            row1["ACol3"] = "tbA13";

            tableA.Rows.Add(row1);

​

            DataRow row2 = tableA.NewRow();

            row2["ACol1"] = "2";

            row2["ACol2"] = "tbA22";

            row2["ACol3"] = "tbA23";

            tableA.Rows.Add(row2);

​

            DataRow row3 = tableA.NewRow();

            row3["ACol1"] = "3";

            row3["ACol2"] = "tbA32";

            row3["ACol3"] = "tbA33";

            tableA.Rows.Add(row3);

​

            DataRow row4 = tableA.NewRow();

            row4["ACol1"] = "4";

            row4["ACol2"] = "tbA42";

            row4["ACol3"] = "tbA43";

            tableA.Rows.Add(row4);

​

            DataRow row5 = tableA.NewRow();

            row5["ACol1"] = "5";

            row5["ACol2"] = "tbA52";

            row5["ACol3"] = "tbA53";

            tableA.Rows.Add(row5);

​

            DataRow row6 = tableB.NewRow();

            row6["BCol1"] = "1";

            row6["BCol2"] = "XX";

            row6["BCol3"] = "tbB13";

            tableB.Rows.Add(row6);

​

            DataRow row7 = tableB.NewRow();

            row7["BCol1"] = "XX";

            row7["BCol2"] = "1";

            row7["BCol3"] = "tbB23";

            tableB.Rows.Add(row7);

​

            DataRow row8 = tableB.NewRow();

            row8["BCol1"] = "XX";

            row8["BCol2"] = "2";

            row8["BCol3"] = "tbB33";

            tableB.Rows.Add(row8);

​

            DataRow row9 = tableB.NewRow();

            row9["BCol1"] = "4";

            row9["BCol2"] = "XX";

            row9["BCol3"] = "tbB43";

            tableB.Rows.Add(row9);

​

            var result = from a in tableA.AsEnumerable()

             from b in tableB.AsEnumerable()

             where a.Field<string>("ACol1") == b.Field<string>("BCol1")

                || a.Field<string>("ACol1") == b.Field<string>("BCol2")

             select new

                    {

                        ACol1 = a["ACol1"],

                        ACol2 = a["ACol2"],

                        ACol3 = a["ACol3"],

                        BCol3 = b["BCol3"]

                    };

​

​

            Console.WriteLine("ACol1\tACol2\tACol3\tBCol3");

            Console.WriteLine("-----------------------------------");

            foreach (var item in result)

            {

                Console.WriteLine("{0}\t{1}\t{2}\t{3}", item.ACol1, item.ACol2, item.ACol3, item.BCol3);

            }

    }

}

​

​

​