Fill a DataSet from a data source and update another data source
-
My task is to fill a DataSet from a data source and update another data source in C#. For example I have two databases in SQL Server (i.e. db1 and db2). I have table named ProdMkt_Contrib_Link in db1 with following columns: ProdMkt_Contrib_Link -------------------- ProdMktContributorID (PK) ProductMarketID Priority Inactive Contrib_Type_Override ProdMkt_Contrib_Link_ID The above columns data should be mapped/sync to the table named ProdMktContribLink in db2: ProdMktContribLink ------------------ ProdMktContributorID (PK) ProductMarketID Priority InactiveFG ContribTypeOverRide AcumenProdMktContribLinkID Note: The table name and few column name are different Suppose few records are added and few are updated in the db1.ProdMkt_Contrib_Link table. I have filled the typed DataSet (DS1) with db1.ProdMkt_Contrib_Link (this contains only added and updated records) ans also filled the another DataSet (DS2) with db2.ProdMktContribLink (this contains all records). Now I want that DS1 should be sync with the DS2. That is, the added records should be added to the DS2 table rows and also updated records should be updated to the DS2 table rows. How can I achieve this in c#. Please suggest any good design or sample code. Thanks, Kamran