Click here to Skip to main content
15,940,173 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I created a webservice that is fetching data from Ms-Access and saved data into sql server 2005.
Now Problem is how to fetch those records which are either updated or new inserting


1 solution

I think there should be pk values with your data while fetching from Ms Access via webservice.

The way I did(for similar scenario) is like here:

1. First collect all the pk values from data (comes via webservice) and Execute the "Delete query" to delete existing data with matching pks.

2. Insert all the data which comes via webservice as there will not be any duplicate data in that now.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900