authorsservice.asmx.cs

Microsoft?ASP.NET Programming with Microsoft Visual C#?.NET Version 2003 Step By Step

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

namespace Chapter_11
{
	/// <summary>
	/// Summary description for AuthorsService.
	/// </summary>
	[WebService(Namespace="http://www.aspnetsbs.com/webservices/")]
	public class AuthorsService : System.Web.Services.WebService
	{
		public AuthorsService()
		{
			//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(Description="Returns the Pubs Authors table.")]
		public DataSet GetAuthors()
		{
			DataSet dsAuthors = new DataSet();
			SqlConnection cn = new SqlConnection();
			SqlDataAdapter da;
			string strCn;

			strCn=@"server=(local)\vsDotNet;database=pubs;" +
				"Trusted_Connection=yes";
			cn.ConnectionString=strCn;
			da=new SqlDataAdapter(
				"SELECT * FROM Authors ORDER BY au_LName,au_FName",cn);
			da.Fill(dsAuthors,"Authors");
			return dsAuthors;
		}
	}
}