Use the Generate Web Methods window to
generate ADO .NET code for Web methods for SQL commands and
procedures, and add the files to an ASP.NET Web Service Web site.
The code is generated in the language of
the project that the code is added to.
The generated
methods are marked as Web methods. You can
build your project and deploy the Web methods
as a Web service.
To open the Generate Web Methods window:
In the Server Explorer, right-click a table, view,
procedure, or function (DB2, IDS) under your data connection,
and then select Generate Web Methods on the shortcut menu.
Select a Web service Web site
Select an ASP.NET Web Service Web site project from the list of available
projects in the currently open solution.
Web service name
Accept or change the predefined name of the Web service
to deploy the Web methods as.
Include SELECT
Select the check box to include the SELECT command as a Web
method. If you select the check box, accept or change the
predefined SELECT statement.
Include INSERT
Select the check box to include an INSERT command as a Web
method. If you select the check box, accept or change the
predefined INSERT statement, if one is displayed, or type
a new INSERT statement.
Include UPDATE
Select the check box to include an UPDATE command as a Web
method. If you select the check box, accept or change the
predefined UPDATE statement, if one is displayed, or type
a new UPDATE statement.
Include DELETE
Select the check box to include a DELETE command as a Web
method. If you select the check box, accept or change the
predefined DELETE statement, if one is displayed, or type
a new DELETE statement.
Enable scripting
Select the check box to add the ScriptService
code attribute to each method that is generated during Web
service code generation.