service.cs

Visual C#2005程序设计教程

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;



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

        //如果使用设计的组件，请取消注释以下行 
        //InitializeComponent(); 
    }

    [WebMethod]
    public DataSet GetDataSet()
    {
        // 连接语句
        string MyConnStr =
            "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(".") + "..\\db\\employee.mdb;";
        // SQL查询
        string strSel = "SELECT employee.编号, employee.姓名, employee.部门, pay.基本工资, pay.职务工资,pay.补贴, pay.奖金,pay.基本工资 + pay.职务工资 + pay.补贴 + pay.奖金 AS 应发工资, pay.扣税,pay.基本工资 + pay.职务工资 + pay.补贴 + pay.奖金 - pay.扣税 AS 实发工资 FROM (employee INNER JOIN pay ON employee.编号 = pay.编号)";
        // 建立一个DataSet实例
        DataSet ds = new DataSet();
        // 创建连接实例
        System.Data.OleDb.OleDbConnection MyConn = new
        System.Data.OleDb.OleDbConnection(MyConnStr);
        // 创建DataAdapter实例，注意参数是前面声明过的
        System.Data.OleDb.OleDbDataAdapter MyAdapter = new
        System.Data.OleDb.OleDbDataAdapter(strSel, MyConn);
        // 填充DataSet
        MyAdapter.Fill(ds, strSel);
        return ds;
    }

    
}