Posted on: 7/10/2015 11:56:30 PM | Views : 736

Hi
I am very new remote SQL Server work and my previous experience is with Access & local databases. I am in a position where i need and over internet database and it has been suggested that i am best to use a Web Service. I have tried various attempts and i can create a simple Web Service but before i go too far, i would like to make sure i am using the correct methods.
Purpose
I have a Winforms application using VB.Net that will be used by a number of users in multiple offices in multiple locations. The application needs to collect / save / delete data to a central database that every user can access. If Jim in Walse office adds a new project, John in Scotland can see it and access it.
SQL Server
I have my tables with data. I am familiar with creating Queries and passing parameters or filters to them to return filtered data. In SQL Server-
Am i better to create a View with a filter o ...

Go to the complete details ...