featuredservice.asmx

来自「asp.net技术内幕的书配源码」· ASMX 代码 · 共 23 行

<%@ WebService Language="C#" Class="FeaturedService" %>
using System;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;

[WebService( Namespace="http://yourdomain.com/webservices" )]
public class FeaturedService : WebService {
	[WebMethod(CacheDuration=60)]
	public DataSet GetFeatured() {
		DataSet dstDataSet;
		SqlConnection conNorthwind;
		SqlDataAdapter dadProducts;
	    
		conNorthwind = new SqlConnection( @"Server=localhost;Trusted_Connection=true;Database=Northwind" );
		dadProducts = new SqlDataAdapter( "Select * From Products", conNorthwind );
		dstDataSet = new DataSet();
		dadProducts.Fill( dstDataSet, "Products" );

		return dstDataSet;
	}
}