Author: Vinay Muthyapu

While dealing with data table operations, sometimes we might want to compare two data tables and get matched data (From a In SourceDT.AsEnumerable Join b In Destination_Table.AsEnumerable On a(“Column_Name”).ToString Equals b(“Column_Name”).tostring Select  a).CopyToDataTable.Select().CopyToDataTable().DefaultView.toTable(False,”Name”) Replace “SourceDT” and “DestinationDT” with your required data tables and “Column_Name” with your required column name that you want to match with … Continue reading How To Compare Two Excel Files Of The Same Format And Get Matched Data?