dbservice.asmx.cs

聊天 聊天 聊天 聊天 聊天 聊天

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Data.OleDb;


namespace CSharpdbService
{
	/// <summary>
	/// Summary description for dbService.
	/// </summary>
	public class dbService : System.Web.Services.WebService
	{
		public dbService()
		{
			//CODEGEN: This call is required by the ASP.NET Web Services Designer
			InitializeComponent();
			connStr = "Provider=SQLOLEDB; Data Source=(local); ";
			connStr = connStr+" Initial Catalog=PUBS;User ID=sa;Password=";
		}
		private String connStr;
		
		

		#region Component Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
		}
		#endregion

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
		}
		[WebMethod]
		public DataSet Populate(string SQL)
		{
			
			//for queries that return data
			//and for binding controls
			OleDbConnection myConnection = new OleDbConnection(connStr);
			OleDbDataAdapter myCommand = new OleDbDataAdapter(SQL, myConnection);
			DataSet ds = new DataSet();
			myCommand.Fill(ds, "vTable");
			return ds;
		}
		[WebMethod]
		public String RunSQL( string vsql)
		{
			try
			{
				OleDbConnection myConnection = new OleDbConnection(connStr);
				OleDbCommand mycommand = new OleDbCommand(vsql,	myConnection);
				myConnection.Open();
				mycommand.ExecuteNonQuery();
				myConnection.Close();
				return("OK");
			}
			catch(Exception e)
			{
				string ret =	"Exception: " + e.ToString() ;
				return ret;
			}

			

		}
				
	}
}