databasewebservice.asmx

来自「第一章 初识ASP.NET第二章 第一个ASP.NET程序第三章 ASP.NET」· ASMX 代码 · 共 21 行

<% @ WebService Language="C#" Class="aspcn" %>
using System;
using System.Data;
using System.Data.OleDb;
using System.Web.Services;
public class aspcn : WebService
{
	public string UserName;
	[WebMethod]
	public DataSet GetDataSet()
	{
		string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\db1.mdb;";
		string strSelect = "select * from UserList";
		OleDbConnection MyConn = new OleDbConnection(MyConnString);
		OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSelect,MyConn);
		DataSet MyDataSet = new DataSet();
		MyAdapter.Fill(MyDataSet,"UserList");
		return MyDataSet;
	}
}