Compare two DataTables and Delete the Matched Records and bi

Question

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

Nanddeep Nachan · Answer

You can use simply distinct to get the value from datatable DataTable distinctTable = dtEmp.DefaultView.ToTable( true , "ElementName" );

Packiaraj Santhiyagu · Answer

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 ; } }