Questions regarding XML/HTTPS/ADO.NET/Windows Form

kocuba

New member
Joined
May 25, 2011
Messages
3
Programming Experience
10+
WE currently have a VB6 app that uses SQL Express 2005/2012 as the backend on remote laptops(currently 1000+ machines). The app currently uses a VPN connection to connect to a SQL Server box at corporate to "replicate" data up and down thru SPs and ADO. We are starting the process of upgrading to .Net for this application and we are looking at options

Option1) Leave it the same. Make the users connect to the VPN and again use SPs and ADO.Net to "replicate" the data.

Option 2) Take the VPN out of the equation. and use HTTPS with a web service to send the data down via XML to the remote machines. My confusion is how would I use this process to send data up thru the web service.

Not necessarily looking for code, but larger overview of if Option 2 is possible and the best place for reading or examples.

TIA
Dave
 
You can basically think of a web service as a library that your project references but, instead of being on the same machine, it's on a remote server. Once you add a service reference to your project, a proxy is created and you can basically use it like you would any other library. To get data from a library method you would call a function and get the return value. To send data to a library method you would call a method and pass one or more arguments. The same goes for a web service.
 
Back
Top