using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Data.OleDb; using System.Collections; using System.Data; [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class Service : System.Web.Services.WebService { public Service () { //如果使用設計的組件,請取消注釋以下行 //InitializeComponent(); } [WebMethod]//直接顯示在datagrid中 public string sqlscan(string sql) { OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source="; connection.ConnectionString += Server.MapPath("user.mdb"); System.Data.OleDb.OleDbDataAdapter liuyan = new OleDbDataAdapter(sql, connection); DataSet dataset1 = new DataSet("test"); liuyan.Fill(dataset1); return dataset1.GetXml(); } [WebMethod]//這個才是串連資料庫並顯示在label中 public string sqlcheck(string sql) { OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source="; connection.ConnectionString += Server.MapPath("user.mdb"); System.Data.OleDb.OleDbDataAdapter tempAdapter = new OleDbDataAdapter(sql, connection); DataSet dataset = new DataSet("temp"); tempAdapter.Fill(dataset); return dataset.GetXml(); } }