SqlBulkCopy Update Existing Rows using C# .Net

Last Reply on Aug 19, 2014 01:17 AM By Mudassar

Posted on Aug 18, 2014 06:27 AM

This is related to the below link


Instead of inserting the data from excel, I want to update the SQL table using Excel file.

For Ex: If I have SQL table like this

ID  Name  Salary

3   XYZ     40000

Is it possible to update the SQL table using Excel data.

Using Update query, Where ID =3 like this