Using linq over datatable
This sample uses Except to create a sequence that contains the values from numbersAthat are not also in numbersB.
public void DataSetLinq52() {
var numbersA = testDS.Tables["NumbersA"].AsEnumerable();
var numbersB = testDS.Tables["NumbersB"].AsEnumerable();
var aOnlyNumbers = numbersA.Except(numbersB, DataRowComparer.Default);
Console.WriteLine("Numbers in first array but not second array:");
foreach (var n in aOnlyNumbers) {
Console.WriteLine(n["number"]);
}
}
Best Regard's
Tiju Thankachan
Bhanubysani, if this helps please login to Mark As Answer. | Alert Moderator