categoriesservice.cs

来自「《ASP.NET 2.0 XML 高级编程（第3版）》 《ASP.NET 2.」· CS 代码 · 共 47 行

using System;
using System.Web.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class CategoriesService : System.Web.Services.WebService
{
	public CategoriesService()
	{
        }    
    
	

    [WebMethod]
    public DataSet GetCategoriesAsDataSet()
    {
        try
        {
            using (SqlConnection conn = new SqlConnection())
            {
                string connectionString = WebConfigurationManager.ConnectionStrings
                  ["adventureWorks"].ConnectionString;
                conn.ConnectionString = connectionString;
                SqlCommand command = new SqlCommand("Select * from " +
                  "Production.ProductCategory", conn);
                command.CommandType = CommandType.Text;
                SqlDataAdapter adapter = new SqlDataAdapter(command);
                DataSet categories = new DataSet("Categories");
                adapter.Fill(categories);
                return categories;
            }
        }
        catch (Exception ex)
        {
            EventLog.WriteEntry("Application", ex.Message);
            throw ex;
        }
    }

}