service.cs

《VC++2005编程实例》第五章的源代码

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.OleDb;
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 string HelloWorld()
    {
        return "Hello World";
    }
    [WebMethod]
    public DataSet GetQueryResult(String MySQL)
    {
        OleDbConnection MyConnection = new OleDbConnection(@"Provider= Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb");
        OleDbCommand MyCommand = new OleDbCommand(MySQL, MyConnection);
        MyConnection.Open();
        DataSet MySet = new DataSet();
        OleDbDataAdapter MyAdapter = new OleDbDataAdapter(MyCommand);
        MyAdapter.Fill(MySet);
        MyConnection.Close();
        return MySet;
    }
}