Web Service to update SQL Server table
Posted on 2009-03-29
I've got a web service written in VB.NET that I use to send datasets to an application and receive data back as a dataset after the user has modified the data within the application. The biggest drawback to this method is that it could be a large dataset and sometimes the people work over a slow connection. I've been looking for a way to send back and update an SQL table everytime they modify a record. The code on the application isn't a problem, but I haven't found a good example of a web service that will update the SQL Server. I only need to update two fields (a date the record was updated and who it was update by).