Compare two DataTables and Delete the Matched Records and bi

i am creating online exam application now i want Compare two DataTables and Delete the Matched Records and bind the Remaining Data on GridView using c#
i have two tables
1.TestSeries
2.TestCompleted
in my TestSeries table i have the following records
1.Test Series 01
2.Test Series 02
3.Test Series 03
4.Test Series 04
5.Test Series 05
6.Test Series 06
7.Test Series 07
8.Test Series 08
9.Test Series 09
10.Test Series 10
and my TestCompleted table have the following Records
1.Test Series 01
2.Test Series 02
3.Test Series 03
my expected output is like this
1.Test Series 01
2.Test Series 02
3.Test Series 03
4.Test Series 04
5.Test Series 05
6.Test Series 06
7.Test Series 07
if anyone how to do this na suggest me

Hi Paul,

I quite confuse, Becouse of your expected result an question.

If you wnat unmatched data use below code:

using System;

using System.Linq;

using System.Collections.Generic;

public class Program

{

public static void Main()

{

// Student collection

IList TestSeries = new List() {

new Series() { SeriesID = 01, SeriesName = "Test Series"} ,

new Series() { SeriesID = 02, SeriesName = "Test Series"} ,

new Series() { SeriesID = 03, SeriesName = "Test Series"} ,

new Series() { SeriesID = 04, SeriesName = "Test Series"} ,

new Series() { SeriesID = 05, SeriesName = "Test Series"},

new Series() { SeriesID = 06, SeriesName = "Test Series"} ,

new Series() { SeriesID = 07, SeriesName = "Test Series"} ,

new Series() { SeriesID = 08, SeriesName = "Test Series"} ,

new Series() { SeriesID = 09, SeriesName = "Test Series"},

new Series() { SeriesID = 10, SeriesName = "Test Series"}

};

IList TestCompleted = new List() {

new Series() { SeriesID = 01, SeriesName = "Test Series"} ,

new Series() { SeriesID = 02, SeriesName = "Test Series"} ,

new Series() { SeriesID = 03, SeriesName = "Test Series"}

};

var joinedList = (from ord in TestSeries join detail in TestCompleted on ord.SeriesID equals detail.SeriesID select ord);

var UnionList=TestCompleted.Union(TestSeries);

var result=UnionList.Except(joinedList);

foreach(Series res in result)

{

System.Console.WriteLine(res.SeriesName);

System.Console.WriteLine(res.SeriesID);

}

public class Series{

public int SeriesID { get; set; }

public string SeriesName { get; set; }

}

If you want matched record you can use below snippet.

using System;
using System.Linq;
using System.Collections.Generic;
public class Program
{
public static void Main()
{
// Student collection
IList TestSeries = new List() {
new Series() { SeriesID = 01, SeriesName = "Test Series"} ,
new Series() { SeriesID = 02, SeriesName = "Test Series"} ,
new Series() { SeriesID = 03, SeriesName = "Test Series"} ,
new Series() { SeriesID = 04, SeriesName = "Test Series"} ,
new Series() { SeriesID = 05, SeriesName = "Test Series"},
new Series() { SeriesID = 06, SeriesName = "Test Series"} ,
new Series() { SeriesID = 07, SeriesName = "Test Series"} ,
new Series() { SeriesID = 08, SeriesName = "Test Series"} ,
new Series() { SeriesID = 09, SeriesName = "Test Series"},
new Series() { SeriesID = 10, SeriesName = "Test Series"}
};
IList TestCompleted = new List() {
new Series() { SeriesID = 01, SeriesName = "Test Series"} ,
new Series() { SeriesID = 02, SeriesName = "Test Series"} ,
new Series() { SeriesID = 03, SeriesName = "Test Series"}
};
IList studentRes = new List();
var joinedList = (from ord in TestSeries join detail in TestCompleted on ord.SeriesID equals detail.SeriesID select ord);
foreach(Series res in joinedList)
{
System.Console.WriteLine(res.SeriesName);
}
}
}
public class Series{
public int SeriesID { get; set; }
public string SeriesName { get; set; }
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
You can use simply distinct to get the value from datatable
DataTable distinctTable = dtEmp.DefaultView.ToTable(true, "ElementName");
Packiaraj Santhiyagu8y ago
Hi Paul,

I quite confuse, Becouse of your expected result an question.

If you wnat unmatched data use below code:

using System;
using System.Linq;
using System.Collections.Generic;

public class Program
{
public static void Main()
{
// Student collection
IList TestSeries = new List() {
new Series() { SeriesID = 01, SeriesName = "Test Series"} ,
new Series() { SeriesID = 02, SeriesName = "Test Series"} ,
new Series() { SeriesID = 03, SeriesName = "Test Series"} ,
new Series() { SeriesID = 04, SeriesName = "Test Series"} ,
new Series() { SeriesID = 05, SeriesName = "Test Series"},
new Series() { SeriesID = 06, SeriesName = "Test Series"} ,
new Series() { SeriesID = 07, SeriesName = "Test Series"} ,
new Series() { SeriesID = 08, SeriesName = "Test Series"} ,
new Series() { SeriesID = 09, SeriesName = "Test Series"},
new Series() { SeriesID = 10, SeriesName = "Test Series"}
};

IList TestCompleted = new List() {
new Series() { SeriesID = 01, SeriesName = "Test Series"} ,
new Series() { SeriesID = 02, SeriesName = "Test Series"} ,
new Series() { SeriesID = 03, SeriesName = "Test Series"}
};

var joinedList = (from ord in TestSeries join detail in TestCompleted on ord.SeriesID equals detail.SeriesID select ord);
var UnionList=TestCompleted.Union(TestSeries);

var result=UnionList.Except(joinedList);
foreach(Series res in result)
{
System.Console.WriteLine(res.SeriesName);
System.Console.WriteLine(res.SeriesID);
}
}
}

public class Series{

public int SeriesID { get; set; }
public string SeriesName { get; set; }

}
If you want matched record you can use below snippet.
using System;
using System.Linq;
using System.Collections.Generic;


public class Program
{
    public static void Main()
    {
        // Student collection
        IList TestSeries = new List() {
                new Series() { SeriesID = 01, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 02, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 03, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 04, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 05, SeriesName = "Test Series"},
                new Series() { SeriesID = 06, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 07, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 08, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 09, SeriesName = "Test Series"},
                new Series() { SeriesID = 10, SeriesName = "Test Series"}
            };

        IList TestCompleted = new List() {
                new Series() { SeriesID = 01, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 02, SeriesName = "Test Series"} ,
                new Series() { SeriesID = 03, SeriesName = "Test Series"}
            };
        IList studentRes = new List();

        var joinedList = (from ord in TestSeries join detail in TestCompleted on ord.SeriesID equals detail.SeriesID select ord);

        foreach(Series res in joinedList)
        {
            System.Console.WriteLine(res.SeriesName);
        }
    }
}

public class Series{

    public int SeriesID { get; set; }
    public string SeriesName { get; set; }


}