caregiverforums
New Member
I'd like to know how to update a database located on a web site using an VB.Net client.<BR><BR>For example, I've got a web site that accepts payments from customers. This database must be updated daily. I'd like to create a VB.Net "client" application that would read the "master" customer database stored on the local network and then update the database on the web site.<BR><BR>Should I just FTP a new database each night to the web site? Create a Web Service? Or can I connect to the database directly and do the update? What's the best method?If your using sql server or some other type of db that supports remote access then you could connect directly. But by far the best method would be a web service. Then if anything changes you can modify the webservice without having to update the application. Plus you can keep the security information private.