这个是前台的:
<asp:DropDownList ID="ddlPro" runat="server" AutoPostBack="True" DataSourceID="sdsPro"
DataTextField="ProvinceName" DataValueField="ProvinceID">
</asp:DropDownList>
<asp:SqlDataSource ID="sdsPro" runat="server" ConnectionString="<%$ ConnectionStrings:connStr %>"
SelectCommand="SELECT [ProvinceID], [ProvinceName] FROM [Province]"></asp:SqlDataSource>
<asp:DropDownList ID="ddlCit" runat="server" AutoPostBack="True" DataSourceID="sdsCit"
DataTextField="CityName" DataValueField="CityID">
</asp:DropDownList>
<asp:SqlDataSource ID="sdsCit" runat="server" ConnectionString="<%$ ConnectionStrings:connStr %>"
SelectCommand="SELECT [CityID], [CityName], [ProvinceID] FROM [city] WHERE ([ProvinceID] = @ProvinceID)">
<SelectParameters>
<asp:ControlParameter ControlID="ddlPro" Name="ProvinceID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:DropDownList ID="ddlReg" runat="server" DataSourceID="sdsReg" DataTextField="RegionalName"
DataValueField="RegionalID">
</asp:DropDownList>
<asp:SqlDataSource ID="sdsReg" runat="server" ConnectionString="<%$ ConnectionStrings:connStr %>"
SelectCommand="SELECT [RegionalID], [RegionalName], [CityID] FROM [Regional] WHERE ([CityID] = @CityID)">
<SelectParameters>
<asp:ControlParameter ControlID="ddlCit" Name="CityID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>这个是后台绑定:
public void DBClub()
{
string ClubID = Request.QueryString["cid"].ToString();
string Sql = "SELECT Club.ClubID, Club.ClubName, Club.ClubTypesID, Club.ProvinceID, Club.CityID, Club.RegionalID, Club.Address, Club.TelePhone, Club.Bus, Club.Facilities, Club.Email, Club.WebSite, Club.Res, Club.ClubLongitude, Club.ClubLatitude, Club.ClubHtmlURL, Club.ClubResourcesURL, Club.Recommend, Club.UpdateTime, Club.Score, ClubInfo.ClubID AS Expr1, ClubInfo.ClubInfo, ClubInfo.ClubIntroduced, ClubInfo.ClubInfoCoursesIntroduced, ClubInfo.ClubDisplay FROM Club INNER JOIN ClubInfo ON Club.ClubID = ClubInfo.ClubID where Club.ClubID=" + ClubID;
DataBase db = new DataBase();
DataRow dr = db.GetDataRow(Sql);
ddlPro.SelectedValue = dr["ProvinceID"].ToString();
ddlCit.SelectedValue = dr["CityID"].ToString();
ddlReg.SelectedValue = dr["RegionalID"].ToString();
}怎么就是没有办法连动了,也没有绑定好!二个就可以!!
高手如果有什么好的方法,教小弟一下,新手!!!
<asp:DropDownList ID="ddlPro" runat="server" AutoPostBack="True" DataSourceID="sdsPro"
DataTextField="ProvinceName" DataValueField="ProvinceID">
</asp:DropDownList>
<asp:SqlDataSource ID="sdsPro" runat="server" ConnectionString="<%$ ConnectionStrings:connStr %>"
SelectCommand="SELECT [ProvinceID], [ProvinceName] FROM [Province]"></asp:SqlDataSource>
<asp:DropDownList ID="ddlCit" runat="server" AutoPostBack="True" DataSourceID="sdsCit"
DataTextField="CityName" DataValueField="CityID">
</asp:DropDownList>
<asp:SqlDataSource ID="sdsCit" runat="server" ConnectionString="<%$ ConnectionStrings:connStr %>"
SelectCommand="SELECT [CityID], [CityName], [ProvinceID] FROM [city] WHERE ([ProvinceID] = @ProvinceID)">
<SelectParameters>
<asp:ControlParameter ControlID="ddlPro" Name="ProvinceID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:DropDownList ID="ddlReg" runat="server" DataSourceID="sdsReg" DataTextField="RegionalName"
DataValueField="RegionalID">
</asp:DropDownList>
<asp:SqlDataSource ID="sdsReg" runat="server" ConnectionString="<%$ ConnectionStrings:connStr %>"
SelectCommand="SELECT [RegionalID], [RegionalName], [CityID] FROM [Regional] WHERE ([CityID] = @CityID)">
<SelectParameters>
<asp:ControlParameter ControlID="ddlCit" Name="CityID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>这个是后台绑定:
public void DBClub()
{
string ClubID = Request.QueryString["cid"].ToString();
string Sql = "SELECT Club.ClubID, Club.ClubName, Club.ClubTypesID, Club.ProvinceID, Club.CityID, Club.RegionalID, Club.Address, Club.TelePhone, Club.Bus, Club.Facilities, Club.Email, Club.WebSite, Club.Res, Club.ClubLongitude, Club.ClubLatitude, Club.ClubHtmlURL, Club.ClubResourcesURL, Club.Recommend, Club.UpdateTime, Club.Score, ClubInfo.ClubID AS Expr1, ClubInfo.ClubInfo, ClubInfo.ClubIntroduced, ClubInfo.ClubInfoCoursesIntroduced, ClubInfo.ClubDisplay FROM Club INNER JOIN ClubInfo ON Club.ClubID = ClubInfo.ClubID where Club.ClubID=" + ClubID;
DataBase db = new DataBase();
DataRow dr = db.GetDataRow(Sql);
ddlPro.SelectedValue = dr["ProvinceID"].ToString();
ddlCit.SelectedValue = dr["CityID"].ToString();
ddlReg.SelectedValue = dr["RegionalID"].ToString();
}怎么就是没有办法连动了,也没有绑定好!二个就可以!!
高手如果有什么好的方法,教小弟一下,新手!!!
import="java.util.*" errorPage=""% >
<!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 >
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" / >
<title >三级级联菜单 </title >
</head > <body >
<center >
<h1 >
三级级联菜单
</h1 >
</center >
<div align="center" >
<form name="isc" >
<table border="0" cellspacing="0" cellpadding="0" >
<tr align="center" >
<td nowrap height="11" >
国家:
<select name="example" size="1"
onChange="redirect(this.options.selectedIndex)" > <option selected >
中国
</option >
<option >
美国
</option >
<option >
日本
</option >
<option >
韩国
</option >
</select >
省份:
<select name="stage2" size="1"
onChange="redirect1(this.options.selectedIndex)" > <option value=" " selected >
辽宁省
</option >
<option value=" " >
四川省
</option >
<option value=" " >
吉林省
</option >
<option value=" " >
广东省
</option >
</select >
市区:
<select name="stage3" size="1"
onChange="" > <option value=" " selected >
沈阳市
</option >
<option value=" " >
大连市
</option >
<option value=" " >
抚顺市
</option >
<option value=" " >
铁岭市
</option >
</select >
</table >
</form >
</div >
<script language="JavaScript" >
<!--
var groups=document.isc.example.options.length
var group=new Array(groups)
for (i=0; i <groups; i++)
group[i]=new Array() file://以下是中国的第二选项
group[0][0]=new Option("辽宁省");
group[0][1]=new Option("四川省");
group[0][2]=new Option("吉林省");
group[0][3]=new Option("广东省"); file://以下是美国的第二选项
group[1][0]=new Option("纽约州");
group[1][1]=new Option("加利福尼亚州");
group[1][2]=new Option("华盛顿州");
group[1][3]=new Option("阿拉斯加州"); file://以下是日本的第二选项
group[2][0]=new Option("东京县");
group[2][1]=new Option("神奈川县");
group[2][2]=new Option("九州县");
group[2][3]=new Option("大阪县"); file://以下是韩国的第二选项
group[3][0]=new Option("韩国A");
group[3][1]=new Option("韩国B");
group[3][2]=new Option("韩国C");
group[3][3]=new Option("韩国D"); var temp=document.isc.stage2
function redirect(x){
for (m=temp.options.length-1;m >0;m--)
temp.options[m]=null
for (i=0;i <group[x].length;i++){
temp.options[i]=new Option(group[x][i].text,group[x][i].value)
}
temp.options[0].selected=true
redirect1(0)
} var secondGroups=document.isc.stage2.options.length
var secondGroup=new Array(groups)
for (i=0; i <groups; i++) {
secondGroup[i]=new Array(group[i].length)
for (j=0; j <group[i].length; j++) {
secondGroup[i][j]=new Array() }}
file://以下是中国的第三选项
secondGroup[0][0][0]=new Option("沈阳市");
secondGroup[0][0][1]=new Option("大连市");
secondGroup[0][0][2]=new Option("抚顺市");
secondGroup[0][0][3]=new Option("铁岭市");
secondGroup[0][1][0]=new Option("成都市");
secondGroup[0][1][1]=new Option("宜宾市");
secondGroup[0][1][2]=new Option("南充市");
secondGroup[0][1][3]=new Option("泸州市");
secondGroup[0][2][0]=new Option("延边市");
secondGroup[0][2][1]=new Option("白城市");
secondGroup[0][2][2]=new Option("白山市");
secondGroup[0][2][3]=new Option("黑山市");
secondGroup[0][3][0]=new Option("深圳市");
secondGroup[0][3][1]=new Option("广州市");
secondGroup[0][3][2]=new Option("佛山市");
secondGroup[0][3][3]=new Option("珠海市");
file://以下是美国的第三选项
secondGroup[1][0][0]=new Option("纽约市1");
secondGroup[1][0][1]=new Option("纽约市2");
secondGroup[1][0][2]=new Option("纽约市3");
secondGroup[1][0][3]=new Option("纽约市4");
secondGroup[1][1][0]=new Option("加利福尼亚1");
secondGroup[1][1][1]=new Option("加利福尼亚2");
secondGroup[1][1][2]=new Option("加利福尼亚3");
secondGroup[1][1][3]=new Option("加利福尼亚4");
secondGroup[1][2][0]=new Option("华盛顿州1");
secondGroup[1][2][1]=new Option("华盛顿州2");
secondGroup[1][2][2]=new Option("华盛顿州3");
secondGroup[1][2][3]=new Option("华盛顿州4");
secondGroup[1][3][0]=new Option("阿拉斯加州1");
secondGroup[1][3][1]=new Option("阿拉斯加州2");
secondGroup[1][3][2]=new Option("阿拉斯加州3");
secondGroup[1][3][3]=new Option("阿拉斯加州4"); file://以下是日本第三选项
secondGroup[2][0][0]=new Option("东京市1");
secondGroup[2][0][1]=new Option("东京市2");
secondGroup[2][0][2]=new Option("东京市3");
secondGroup[2][0][3]=new Option("东京市4");
secondGroup[2][1][0]=new Option("神奈川1");
secondGroup[2][1][1]=new Option("神奈川2");
secondGroup[2][1][2]=new Option("神奈川3");
secondGroup[2][1][3]=new Option("神奈川4");
secondGroup[2][2][0]=new Option("九州1");
secondGroup[2][2][1]=new Option("九州2");
secondGroup[2][2][2]=new Option("九州3");
secondGroup[2][2][3]=new Option("九州4");
secondGroup[2][3][0]=new Option("大阪1");
secondGroup[2][3][1]=new Option("大阪2");
secondGroup[2][3][2]=new Option("大阪3");
secondGroup[2][3][3]=new Option("大阪4"); file://以下是韩国第三选项
secondGroup[3][0][0]=new Option("韩国A1");
secondGroup[3][0][1]=new Option("韩国A2");
secondGroup[3][0][2]=new Option("韩国A3");
secondGroup[3][0][3]=new Option("韩国A4");
secondGroup[3][1][0]=new Option("韩国B1");
secondGroup[3][1][1]=new Option("韩国B2");
secondGroup[3][1][2]=new Option("韩国B3");
secondGroup[3][1][3]=new Option("韩国B4");
secondGroup[3][2][0]=new Option("韩国C1");
secondGroup[3][2][1]=new Option("韩国C2");
secondGroup[3][2][2]=new Option("韩国C3");
secondGroup[3][2][3]=new Option("韩国C4");
secondGroup[3][3][0]=new Option("韩国D1");
secondGroup[3][3][1]=new Option("韩国D2");
secondGroup[3][3][2]=new Option("韩国D3");
secondGroup[3][3][3]=new Option("韩国D4"); var temp1=document.isc.stage3
function redirect1(y){
for (m=temp1.options.length-1;m >0;m--)
temp1.options[m]=null
for (i=0;i <secondGroup[document.isc.example.options.selectedIndex][y].length;i++){
temp1.options[i]=new Option(secondGroup[document.isc.example.options.selectedIndex][y][i].text,secondGroup[document.isc.example.options.selectedIndex][y][i].value)
}
temp1.options[0].selected=true
} </script >
</body >
</html >