asp.net2.0基于jquery的ajax二级联动(菜鸟分享)

编程有钱人了 2008-09-28 10:57:40

做了一个asp.net2.0基于jquery的ajax二级联动（服务器测试和本地测试正常）
我是菜鸟，不对的地方请大家批评指正，谢谢
也可以到我的BLOG上看
http://blog.csdn.net/wangjun8868/archive/2008/09/26/2983149.aspx
别忘了到JQUERY官网下载jquery-1.2.6.pack.js（压缩版）
Default.aspx



<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %> 

<%@ Import Namespace="System.Data.SqlClient" %> 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 



<html xmlns="http://www.w3.org/1999/xhtml" > 

<head runat="server"> 

    <title>无标题页</title> 

    <script type="text/javascript" src="jquery-1.2.6.pack.js"></script>   

     <script language="javascript" type="text/javascript">    

    $(document).ready(function(){ 

      $("#bTrade").change(function(){   

           $("#sTrade").load("getprovinces.aspx?id="+$("#bTrade").val()) ;     

       });     

    });    

  </script>   

</head> 

<body> 

    <form id="form1" runat="server"> 

  <select name="bTrade" id="bTrade">    

  <option value="-1">——所属省份——</option>    

  <%=provicename%>   <!--输出省份-->   

  </select>    

 <select name='sTrade' id="sTrade"> 

 <option value='-2'>——城市——</option>  

 </select> 

    </form> 

</body> 

</html>

Default.aspx.cs



using System; 

using System.Data; 

using System.Configuration; 

using System.Web; 

using System.Web.Security; 

using System.Web.UI; 

using System.Web.UI.WebControls; 

using System.Web.UI.WebControls.WebParts; 

using System.Web.UI.HtmlControls; 

using System.Text; 

using System.Data.SqlClient; 

public partial class _Default : System.Web.UI.Page  

{ 

    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString); 

   public  string provicename = string.Empty; 

    protected void Page_Load(object sender, EventArgs e) 

    { 

        StringBuilder st = new StringBuilder(); 

         

        SqlCommand comm=new SqlCommand("select * from provinces",conn); 

        conn.Open(); 

        SqlDataReader dr = comm.ExecuteReader(CommandBehavior.CloseConnection); 

        while(dr.Read()) 

        { 

            st.Append("<option value="+dr["provincetype"].ToString()+">----"+dr["province"].ToString()+"----</option>"); 

        } 

        dr.Close(); 

        conn.Close(); 

        provicename = st.ToString(); 

    } 

}

getprovinces.aspx



<%@ Page Language="C#" AutoEventWireup="true" CodeFile="getprovinces.aspx.cs" Inherits="getstrade" %> 



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 



<html xmlns="http://www.w3.org/1999/xhtml" > 

<head runat="server"> 

    <title>无标题页</title> 

</head> 

<body> 

    <form id="form1" runat="server"> 

    </form> 

</body> 

</html>

getprovinces.aspx.cs



using System; 

using System.Data; 

using System.Configuration; 

using System.Collections; 

using System.Web; 

using System.Web.Security; 

using System.Web.UI; 

using System.Web.UI.WebControls; 

using System.Web.UI.WebControls.WebParts; 

using System.Web.UI.HtmlControls; 

using System.Text; 

using System.Data.SqlClient; 

public partial class getstrade : System.Web.UI.Page 

{ 

    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString); 

    public string cityname = string.Empty; 

    protected void Page_Load(object sender, EventArgs e) 

    { 

        StringBuilder st = new StringBuilder(); 



        SqlCommand comm = new SqlCommand("select * from citiesTb where provincetype="+Request.QueryString["id"].ToString(), conn); 

        conn.Open(); 

        SqlDataReader dr = comm.ExecuteReader(CommandBehavior.CloseConnection); 

        while (dr.Read()) 

        { 

            st.Append("<option value=" + dr["provincetype"].ToString() + ">----" + dr["cityname"].ToString() + "----</option>"); 

        } 

        dr.Close(); 

        conn.Close(); 

        cityname =st.ToString(); 

       Response.Write(cityname); 

        Response.End(); 

    } 

}