datasample.asmx

来自「这是《ASP.NET编程实作教程》一书中的源文件 如果有此书的朋友不防下载过来参」· ASMX 代码 · 共 28 行

<%@ WebService Language="C#" Class="DataSample" %>

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

public class DataSample {

   [WebMethod]
    //GetEmployees方法，返回包含所有雇员信息的DataSet对象
   public DataSet GetEmployees() {

        //建立数据连接
        SqlConnection myConnection = new SqlConnection("server=(local);database=Northwind;Trusted_Connection=yes");
        //创建SqlDataAdapter对象来执行SQL语句
        SqlDataAdapter myCommand = new SqlDataAdapter ("select EmployeeID,LastName,FirstName,Title,BirthDate,HireDate,Address,City  from Employees",myConnection);

        //创建DataSet对象
        DataSet ds = new DataSet();
        //执行SQL语句，并将结果填充到DataSet中
        myCommand.Fill(ds, "Employees");
        //返回DataSet对象
        return ds;
   }
}