DataTabe(DataRow)Ö®¼ä±È½ÏÇó½»¼¯¡¢²¢¼¯¡¢²î¼¯

// Ê×ÏÈÒªÌí¼ÓSystem.Data.DataSetExtensions;
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InvariantCulture;
FillDataSet(ds);

DataTable contactTable = ds.Tables[ " Contact " ];

// Create two tables.
IEnumerable < DataRow > query1 = from contact in contactTable.AsEnumerable()
where contact.Field < string > ( " Title " ) == " Ms. "
select contact;

IEnumerable < DataRow > query2 = from contact in contactTable.AsEnumerable()
where contact.Field < string > ( " FirstName " ) == " Sandra "
select contact;


DataTable contacts1 = query1.CopyToDataTable();
DataTable contacts2 = query2.CopyToDataTable();

// Find the intersection of the two tables. Çó½»¼¯Óà Intersect/Union(²¢¼¯)/Except(²î¼¯)
var contacts = contacts1.AsEnumerable().Intersect(contacts2.AsEnumerable(),
DataRowComparer.Default);

Console.WriteLine( " Intersection of contacts tables " );
foreach (DataRow row in contacts)
{
Console.WriteLine( " Id: {0} {1} {2} {3} " ,
row[ " ContactID " ], row[ " Title " ], row[ " FirstName " ], row[ " LastName " ]);
}

ÉÏÃæΪMSDNµÄ´úÂë，ÏÂÃæΪ×Ô¼ºµÄ´úÂë，Ïà¶Ô¼ò½àЩ：

DbHelperSQL.connectionString = strSiteConnection;
DataTable dtblSiteTable = DbHelperSQL.TQuery( " Select * From " + strTableName);
IEnumerable < DataRow > querySite = from contact in dtblSiteTable.AsEnumerable() select contact;

DbHelperSQL.connectionString = strMainConnection;
DataTable dtblMainTable = DbHelperSQL.TQuery( " Select * From " + strTableName);
IEnumerable < DataRow > queryMain = from contact in dtblMainTable.AsEnumerable() select contact;

var EnumerableExcept = querySite.CopyToDataTable().AsEnumerable().Except(queryMain.CopyToDataTable().AsEnumerable(), DataRowComparer.Default);

DataTable dtblExcept = EnumerableExcept.CopyToDataTable(); // dtblExcept ¼´Îª²îÒìµÄÊý¾Ý±í

תÔØÓÚ:https://www.cnblogs.com/zhangpengshou/archive/2010/06/30/1768384.html