您现在的位置: 帝欧资源网 >> 文章中心 >> AJAX专区 >> 正文
Ajax实现在textbox中输入内容,动态从数据库中模糊查询显示到下拉框中
Ajax实现在textbox中输入内容,动态从数据库中模糊查询显示到下拉框中
作者:网络收集 文章来源:网络收集 点击数: 更新时间:2008-7-4 2:50:27

功能:在textbox中输入内容,动态从数据库模糊查询显示到下拉框中,以供选择

1.建立一aspx页面,html代码

<HTML>
    <HEAD>
        <title>WebForm1</title>
        <SCRIPT language="javascript">           
            //城市------------------------------
            function cityResult()
            {
                var city=document.getElementById("TextBox1");
                WebForm1.GetCityList(city.value,get_city_Result_CallBack);
            }
           
            function get_city_Result_CallBack(response)
            {
                if (response.value != null)
                {                   
                    //debugger;
                    document.getElementById("DropDownList1").style.display="block";
                    document.getElementById("DropDownList1").length=0;               
                var ds = response.value;
                    if(ds != null && typeof(ds) == "object" && ds.Tables != null)
                    {                   
                        for(var i=0; i<ds.Tables[0].Rows.length; i++)
                    {
                        var name=ds.Tables[0].Rows[i].city;
                      var id=ds.Tables[0].Rows[i].cityID;
                      document.getElementById("DropDownList1").options.add(new Option(name,id));
                    }
                    }
                }
                else
                {
                    document.getElementById("DropDownList1").style.display="none";
                }            
                return
            }
          
            function getData()
            {
                var province=document.getElementById("DropDownList1");
                var pindex = province.selectedIndex;
                var pValue = province.options[pindex].value;
                var pText  = province.options[pindex].text;                                               

                document.getElementById("<%=TextBox1.ClientID%>").innerText=pText;
            }
        </SCRIPT>
    </HEAD>
    <body>
        <form id="Form1" method="post" runat="server">
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <br>
            <asp:DropDownList ID="DropDownList1" runat="server" Width="192px" style="display:none"></asp:DropDownList>
        </form>
    </body>
</HTML>2.cs代码
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace ajaxselect
{
    /**//// <summary>
    /// Summary description for WebForm1.
    /// </summary>
    public class WebForm1 : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.TextBox TextBox1;
        protected System.Web.UI.WebControls.DropDownList DropDownList1;
   
        private void Page_Load(object sender, System.EventArgs e)
        {
            Ajax.Utility.RegisterTypeForAjax(typeof(WebForm1));
            if (!Page.IsPostBack)
            {
                this.TextBox1.Attributes.Add("onchange", "cityResult();");
                this.DropDownList1.Attributes.Add("onclick", "getData();");
            }
        }

        Web Form Designer generated code#region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }
       
        /**//// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {   
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        GetCityList#region GetCityList
        [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
        public DataSet G

[1] [2] 下一页

文章录入:feilaiyu    责任编辑:feilaiyu 
  • 上一篇文章:

  • 下一篇文章:
  • 【字体: 】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口
      网友评论:(只显示最新10条。评论内容只代表网友观点,与本站立场无关!)
        热门文章 更多...
     基于css样式绑定的样式驱动式AJA
     ajax进度条
     利用Asp.net Ajax异步获取xml文档
     Ajax实现无刷新树
     Ajax实现在textbox中输入内容,动
        推荐文章 更多...
     在AJAX开发中集成数据库技术
     对Gmail中使用AJAX技术的研究
     利用AJAX技术开发应用程序实战
     利用AJAX技术开发应用程序实战发
     在 AJAX 开发中集成数据库技术
        相关文章 更多...
    在ASP.Net中应用Javascr
    结合JavaScript与ASP.NE
    在Web DataGrid中当鼠标
    ASP.NET 2.0 Treeview C
    在atlas里面的UpdatePan

    Copyright 2008 版权所有:帝欧资源网 辽ICP备05010304号
    站长信箱:admin@do666.com
    建议、投诉、报障:admin@do666.com
    站长:小猴