update table using linq
-
Hi, Am reading an excel file containing columns and storing it into the database. The excel sheet contains a column called STATUS which includes (NOT STARTED , IN-PROGRESS , COMPLETE) several rows have different statuses. Everytime the excel sheet is read the values are stored into the table in the db. Now in the latest excel sheet some of the rows have a changed status i.e a row which had STATUS as "NOT-STARTED" in the previous excel sheet, will now have status as "IN-PROGRESS". How do I compare this with the actual data in the database table and update that particular row with the new STATUS using LINQ. Help appreciated,,,
-
Hi, Am reading an excel file containing columns and storing it into the database. The excel sheet contains a column called STATUS which includes (NOT STARTED , IN-PROGRESS , COMPLETE) several rows have different statuses. Everytime the excel sheet is read the values are stored into the table in the db. Now in the latest excel sheet some of the rows have a changed status i.e a row which had STATUS as "NOT-STARTED" in the previous excel sheet, will now have status as "IN-PROGRESS". How do I compare this with the actual data in the database table and update that particular row with the new STATUS using LINQ. Help appreciated,,,
I cant get you. Means you cant get the data from the database and check with the existing value ?? :confused::confused:
Abhishek Sur
My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB
**Don't forget to click "Good Answer" if you like to.