using webservice to update database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chris - 04 Nov 2004 22:23 GMT

I am new to web services but want to know if it would be a viable solution
for a project we are considering. I have a site in the US that i want to use
a webservice to pull data out off SQL Server and have it update a different
SQL Server in our German office through a vb.net client that runs at their
location. I wrote a small sample app that pulls data into a vb.net form with
a datagrid - allows for changes and updates back to the server. Unfortunately
i have found no samples that describe pulling from one datasource and
updating another.

Chris

Reply to this Message

Martin Kulov - 05 Nov 2004 08:48 GMT

Hi Chris,

If I get the things right, you can use web services for both pooling and updating. I would recommend creating some kind of business classes that handle transformation from relational structure to OO classes. Use these classes in your web service to pool data from DB1. Then create second web service that update DB2. The point is that you can update DB2 from vb.net app by using these classes, and you can call web service 2 from web service 1 to perform updates to DB2 also.

HTH,
Martin Kulov
www.codeattest.com

Reply to this Message

using webservice to update database

Free Magazines