Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
Hi everyone
I have a website and I want to manage its database through a windows application.
there are some information in a database has located in my computer and these information always change.
Now I'm going to put these changes into database of website.
and I don't know how can I find changes and when I have to insert and when I have to update each rows.
 
could you please introduce me a simple way to solve that?
 
[Edit: Moved OP's Solution to here]
ok I will describe more.
 
I have a website that I sell some products there. there is a database including information of products. I also have a database in my computer that indicate how many products there are in storage.
Now I need to make an application that copy and replace information from the database that located in my computer to the database that located in internet.
for example, today I will add a product or I will change a product in the database in my computer and I want to set these changes into the database located in internet.
 
as I said before, there were two different databases including products information and I am going to keep them always the same.
 
how can I do that?
Posted 14-Feb-13 15:38pm
Edited 15-Feb-13 4:44am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Question not very clear to me. I guess you need to store row version. If so you want to create a separate table, it is so called history table. When main table insert/update/delete operation will need, before that you just copy last row from main table to history table with appropriation identification/version no etc various strategy you can follow. So when previous any row needed then you can go to history table and pick appropriate row version.
 
[Edit: Moved OP's Solution to here]
Well, Then you need to develop a webservice/wcfservice. It will add/update product database from the internet. From your local environment(windows/web)when you add/update product that time you also call that newly develop webserivce for sync internet database with your local database. If you are new to webserivice world then you first need to understand it properly then you can implement that.
  Permalink  
v2

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

  Print Answers RSS
0 OriginalGriff 205
1 Sergey Alexandrovich Kryukov 200
2 Rob Philpott 100
3 Prakriti Goyal 97
4 jlopez788 94
0 OriginalGriff 6,837
1 Sergey Alexandrovich Kryukov 5,589
2 Maciej Los 3,479
3 Peter Leow 3,323
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 15 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100