?? productsservice.asmx
字號(hào):
<%@ WebService Class="ProductsService" Language="C#" %>
using System;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
[WebService( Namespace="http://yourdomain.com/webservices" )]
public class ProductsService : WebService {
[WebMethod]
public DataSet GetProducts(string CategoryName) {
string strSelect;
SqlConnection conNorthwind;
SqlDataAdapter dadNorthwind;
DataSet dstProducts;
strSelect = "SELECT ProductName, UnitPrice, UnitsInStock, CategoryName " +
"FROM Products, Categories WHERE Products.CategoryID = " +
"Categories.CategoryID AND CategoryName = @CategoryName";
conNorthwind = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Northwind" );
dadNorthwind = new SqlDataAdapter( strSelect, conNorthwind );
dadNorthwind.SelectCommand.Parameters.Add( "@CategoryName", CategoryName );
dstProducts = new DataSet();
dadNorthwind.Fill( dstProducts, "Products" );
return dstProducts;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -