Dataset数据通过Web服务进行输出数据绑定

1、Web服务代码

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

/// <summary>
/// Summary description for CategoriesService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class CategoriesService : System.Web.Services.WebService {

    public CategoriesService () {

        //Uncomment the following line if using designed components
        //InitializeComponent();
    }

    [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;
        }

    }

}

2、代码结构