小试Ajax-下拉框联动

 


 本文参考http://singlepine.cnblogs.com/articles/257954.html，学习一把Ajax

表示感谢

1.Html

 

<HTML>
    <HEAD>
        <meta name="vs_snapToGrid" content="False">
        <title>Test</title>
        <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
        <script language="javascript">
        function TBRResult()
        {
            var TBR = document.getElementById("TBDW");
            AjaxClass.GetTBRData(TBR.value,get_TBR_Result_CallBack);
        }
        
        function get_TBR_Result_CallBack(response)
        {
            if(response != null)
            {
                document.all("TBR").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 ID = ds.Tables[0].Rows[i].USER_ID;
　　                    var NAME = ds.Tables[0].Rows[i].USER_NAME;
　　                    document.all("TBR").options.add(new Option(NAME,ID));
                    }
                }
            }
            return
        }
        </script>
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <form id="Form1" method="post" runat="server">
            <FONT face="宋体">
                <asp:dropdownlist id="TBDW" style="Z-INDEX: 101; LEFT: 200px; POSITION: absolute; TOP: 120px" runat="server"
                    Width="120px"></asp:dropdownlist>
                <asp:dropdownlist id="TBR" style="Z-INDEX: 102; LEFT: 352px; POSITION: absolute; TOP: 120px" runat="server"
                    Width="120px"></asp:dropdownlist></FONT>
        </form>
    </body>
</HTML>

 

2.后台cs

 

Ajax.Utility.RegisterTypeForAjax(typeof(AjaxClass));
            if(!this.IsPostBack)
            {
                //绑定填报单位下拉列表框
                DataSet ds = new AjaxClass().GetTBDWData();
                shareFunction.BindDropDownList("","ORG_NAME","ORG_ID",TBDW,ds);
                TBDW.Attributes.Add("onclick","TBRResult();");
            }

 

3.AjaxClass

 

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

        获取填报单位数据

        获取填报人数据

4.GetData取数据

 

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

        public DataSet GetTBDWData()
        {
            //绑定填报单位下拉列表框
            string SQL = "select * from ORGANIZATION order by ORG_ID";
            DataSet ds = shareDataOperation.ExecuteSelectSql(SQL,"ORGANIZATION");
            return ds;
        }

        public DataSet GetTBRData(string DWID)
        {
            //绑定填报人下拉列表框
            string SQL = "select * from USERS where ORG_ID="+ DWID;
            DataSet ds = shareDataOperation.ExecuteSelectSql(SQL,"USERS");
            return ds;
        }

 

5.web.config

 

<httpHandlers>
        <add verb="POST,GET" path="ajax/*.ashx" type="Ajax.PageHandlerFactory, Ajax" />
   </httpHandlers>  

posted @ 2006-03-30 17:45  CooS  阅读(844)  评论(0)  编辑  收藏  举报