日期:2012-09-23  浏览次数:20420 次

我做了一个三级联动的下拉列表框,后台用webservice,前台用webservice behavior与后台通讯。请高手们多提改进意见。

server端:(service1.asmx.cs)
using System;
using System.Text;
using System.Configuration;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Web;
using System.Web.Services;

namespace WebService1
{
    /// <summary>
    /// Summary description for Service1.
    /// </summary>
    public class Service1 : System.Web.Services.WebService
    {
        SqlConnection con;
        

        public Service1()
        {
            //CODEGEN: This call is required by the ASP.NET Web Services Designer
            InitializeComponent();
        }

        #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()
        {
            string dsn = ConfigurationSettings.AppSettings["yitong"];

            con=new SqlConnection(dsn);
        }
        #endregion

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        protected override void Dispose( bool disposing )
        {
        }


        [WebMethod]
        public string fenlei()
        {
            string str="select distinct substring(code,1,3) as fenlei from jinan ";
            SqlCommand cmd=new SqlCommand(str,con);            

            cmd.Connection.Open();
            SqlDataReader dr=cmd.ExecuteReader();
            

            string s="请选择:";
            while(dr.Read())
            {
                s += ","+dr["fenlei"].ToString();