How to compare data in text file and data in database C#

try the below link

https://www.codeproject.com/Articles/3697/V-Diff-A-File-Comparer-with-visual-output

+1

What if in case of excel file, instead of database.We are taking input from the excel file and comparing two columns data with text file.if both matches we will update the result as pass else fail in the same excel sheet result column.Can you help me with the script

+1

Nilesh Shah7y ago

the best way to do this performance wise is not in C# but in database side, using a Stored Procedure

Create a Stored Procedure (SP) which takes nvarchar(MAX) input parameter and pass the text file data seperated by some special characters for rows and columns

in the SP, use CURSOR to loop thru the input data and do operation like checking and updating database table for each loop

+2