I have the following requirements:
Read selected colu开发者_开发技巧mns(DetailsId, SentDate, Count) from excel, get data for the respective DetailsId(s) from Oracle database. Show the comparison data from the excel and database in a grid (MVC).
If the data matches do nothing, if there is a mismatch update some database columns with data in the excel.
Any suggestions how this can be done
Thanks
Convert your excel spreadsheet to CSV format, define an external table in Oracle using the CSV file as the source, then compare the external table values with the actual Oracle table using SQL within C# and display results as required. Update data as needed.
精彩评论