myservice.asmx.cs

ASP C#代码实例 适合初学人士学习使用

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.Configuration;

namespace WindowsService
{
	/// <summary>
	/// Summary description for MyService.
	/// </summary>
	public class MyService : System.Web.Services.WebService
	{
		public MyService()
		{
			//CODEGEN: This call is required by the ASP.NET Web Services Designer
			InitializeComponent();
		}

		#region Component Designer generated code
		
		//Required by the Web Services Designer 
		private IContainer components = null;
				
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if(disposing && components != null)
			{
				components.Dispose();
			}
			base.Dispose(disposing);		
		}
		
		#endregion

		[WebMethod]
		public DataSet GetStaffs()
		{
			string connString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];

			SqlConnection sqlConn = new SqlConnection(connString); 

			DataSet dstStaffs = new DataSet("Staffs");            

			SqlDataAdapter adapter = new SqlDataAdapter("Select * from Staff",sqlConn);       

			adapter.Fill(dstStaffs,"Staff");   
			sqlConn.Close();
			sqlConn.Dispose();
			return dstStaffs;    
		}
	}
}