Asp.net学习之第一个web service发布

/****** 对象: 存储过程 dbo.searchkey    脚本日期: 2006-5-9 23:36:51 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[searchkey]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[searchkey]
GO

/****** 对象: 表 [dbo].[OK]    脚本日期: 2006-5-9 23:36:51 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OK]
GO

/****** 对象: 表 [dbo].[OK]    脚本日期: 2006-5-9 23:36:51 ******/
CREATE TABLE [dbo].[OK] (
    [ID] [int] IDENTITY (1, 1) NOT NULL ,
    [hanzi] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [pinyin] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [wubi] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [zhengma] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [unicode] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [GBK] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [bihuashu] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [bushou] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [bishunbianhao] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/****** 对象: 存储过程 dbo.searchkey    脚本日期: 2006-5-9 23:36:52 ******/
/*
查询关键字
创建日期:2006-5-9
创建者:德仔
*/
create procedure searchkey
@searchword char(2)
as
select ID,hanzi,pinyin,wubi,zhengma,[unicode],GBK,bihuashu,bushou,bishunbianhao from ok
where
hanzi=@searchword
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

using System;
using System.Data;
using System.Data.SqlClient;


namespace character
{
    ///

    /// words 的摘要说明。
    ///

    public class words
    {

        private int _id;
        private string _hanzi;
        private string _pinyin;
        private string _wubi;
        private string _zhengma;
        private string _unicode;
        private string _gbk;
        private int _bihuashu;
        private string _bushou;
        private string _bishunbianhao;

        public int id
        {
            get
            {
                return _id;
            }
            set
            {
             _id =value;
            }
        }


        public string hanzi
        {
            get
            {
                 return _hanzi;
            }
            set
            {
                  _hanzi =value;
            }
        }

        public string pinyin
        {
            get
            {
               return _pinyin;


            }
            set
            {
                _pinyin = value;
            }
        }


        public string wubi
        {
            get
            {

                return _wubi;

            }
            set
            {
                _wubi = value;

            }
        }


        public string zhengma
        {
            get
            {

                return _zhengma;

            }
            set
            {

                _zhengma = value;

            }
        }


        public string unicode
        {
            get
            {

                return _unicode;

            }
            set
            {
                _unicode = value;

            }
        }


        public string gbk
        {
            get
            {

                return _gbk;

            }
            set
            {
                _gbk = value;

            }
        }


        public int bihuashu
        {
            get
            {

                return _bihuashu;

            }
            set
            {
                _bihuashu = value;

            }
        }


        public string bushou
        {
            get
            {

                return _bushou;

            }
            set
            {
                _bushou = bushou;

            }
        }


        public string bishunbianhao
        {
            get
            {

                return _bishunbianhao;

            }
            set
            {
                _bishunbianhao = value;

            }
        }

    

        public words()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        public words(string hanzi,string pinyin,string wubi,string zhengma,string unicode,string gbk,int bihuashu,string bushou,string bishunbianhao)
        {
            this._hanzi = hanzi;
            this._pinyin = pinyin;
            this._wubi = wubi;
            this._zhengma =zhengma;
            this._gbk = gbk;
            this._bihuashu = bihuashu;
            this._bushou = bushou;
            this._bishunbianhao = bishunbianhao;

        }

        public words(DataRow record)
        {
            this._id =Convert.ToInt32(record["ID"]);
            this._hanzi = record["hanzi"].ToString();
            this._pinyin=record["pinyin"].ToString();
            this._wubi=record["wubi"].ToString();
            this._zhengma=record["zhengma"].ToString();
            this._unicode=record["unicode"].ToString();
            this._gbk=record["gbk"].ToString();
            this._bihuashu=Convert.ToInt32(record["bihuashu"]);
            this._bushou=record["bushou"].ToString();
            this._bishunbianhao=record["bishunbianhao"].ToString();


        }
    }
}

using System;
using System.Configuration;
using System.Data.SqlClient;

namespace character
{
    ///

    /// conndb 的摘要说明。
    ///

    public class conndb
    {
        public conndb()
        {
            
            
                //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        public static SqlConnection create()
        {
            return new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);

        }
    }
}