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;

namespace Play.CH1

{

    public class Service1 : System.Web.Services.WebService

    {

        public Service1()

        {

            InitializeComponent();

        }

        private System.Data.SqlClient.SqlConnection sqlConnection1;

        private IContainer components = null;

        private void InitializeComponent()

        {

            this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();

            this.sqlConnection1.ConnectionString = "workstation id=\"192.168.1.9\";packet size=4096;user id=sa;data source=\"192.168.1.9\";pe" +

            "rsist security info=True;initial catalog=pubs;password=";

            this.sqlConnection1.InfoMessage += new System.Data.SqlClient.SqlInfoMessageEventHandler(this.sqlConnection1_InfoMessage);

        }

        protected override void Dispose(bool disposing)

        {

            if (disposing && components != null)

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)

        {

        }

        [WebMethod]

        public string doSearch(string keyword)

        {

            SqlDataAdapter da = new SqlDataAdapter("select top 20 title_id,title from titles where title like @title", sqlConnection1);

            da.SelectCommand.Parameters.Add(new SqlParameter("@title", "%" + keyword + "%"));

            DataSet ds = new DataSet();

            da.Fill(ds);

            return ds.GetXml();

        }

    }

}

//------------------------------------------------------------------------------

// <autogenerated>

//     This code was generated by a tool.

//     Runtime Version: 1.1.4322.573

//

//     Changes to this file may cause incorrect behavior and will be lost if

//     the code is regenerated.

// </autogenerated>

//------------------------------------------------------------------------------

//

// 這個原始程式碼是由wsdl，Version=1.1.4322.573 自動產生。

//

using System.Diagnostics;

using System.Xml.Serialization;

using System;

using System.Web.Services.Protocols;

using System.ComponentModel;

using System.Web.Services;

/**/

/// <remarks/>

[System.Diagnostics.DebuggerStepThroughAttribute()]

[System.ComponentModel.DesignerCategoryAttribute("code")]

public class Service1 : System.Web.Services.Protocols.HttpGetClientProtocol

{

    public Service1()

    {

        this.Url = "http://localhost/Play/CH1/Service1.asmx";

    }

    [System.Web.Services.Protocols.HttpMethodAttribute(typeof(System.Web.Services.Protocols.XmlReturnReader),

        typeof(System.Web.Services.Protocols.UrlParameterWriter))]

    [return: System.Xml.Serialization.XmlRootAttribute("string", Namespace = "http://tempuri.org/", IsNullable = true)]

    public string doSearch(string keyword)

    {

        return ((string)(this.Invoke("doSearch", (this.Url + "/doSearch"), new object[] {

                    keyword})));

    }

    public System.IAsyncResult BegindoSearch(string keyword, System.AsyncCallback callback, object asyncState)

    {

        return this.BeginInvoke("doSearch", (this.Url + "/doSearch"), new object[] {

                    keyword}, callback, asyncState);

    }

    public string EnddoSearch(System.IAsyncResult asyncResult)

    {

        return ((string)(this.EndInvoke(asyncResult)));

    }

}