Example 1: Running a Web Method Bound to a Stored Procedure from C#
Using Visual Studio 2008, create a new web application or website and name it
SQLWebServicesClient. Next, add a web reference to the SQL Server web service created in Listing 48.3. To do this, you right-click the project name in the Server Explorer window and select Add Web Reference. In the dialog that appears, you type the following in the URL text box, replacing
ServerDomainName with the server name of your SQL Server instance:
Next, you click the green Go arrow button. You may be required to Windows-authenticate to the machine hosting the SQL web service. Be sure to use an account that has a matching SQL Server login. After you do ...