问题描述
有人用过dropdownlist联动没有,二级联动,发一个给我吧联系QQ:414152461
解决方案
解决方案二：
#region根据sql语句对dropdownlist的绑定///<summary>///根据sql语句绑定代码的下拉信息///</summary>///<paramname="HdropList"></param>///<paramname="Hsql"></param>publicvoidassetDropDownListBind(stringHtext,stringHvalue,System.Web.UI.WebControls.DropDownListHdropList,stringHsql,stringHtablename){Open();try{myDataSet=this.GetDataSet(Hsql,Htablename);if(myDataSet.Tables[0].Rows.Count>0){HdropList.DataSource=myDataSet.Tables[0].DefaultView;HdropList.DataTextField=myDataSet.Tables[0].Columns[Htext].ToString().Trim();HdropList.DataValueField=myDataSet.Tables[0].Columns[Hvalue].ToString().Trim();HdropList.DataBind();}}catch(Exceptionex){Trace.Write(ex.Message);//RegisterStartupScript("btn","<scriptlanguage="javascript">alert('"+this.GetErrorDis()+"');</"+"script>");}finally{Close();}}///<summary>///根据选定的值绑定下拉框///</summary>///<paramname="Htext"></param>///<paramname="Hvalue"></param>///<paramname="HdropList"></param>///<paramname="Hsql"></param>///<paramname="Htablename"></param>///<paramname="CsValue"></param>publicvoidassetDropDownListBindSelected(stringHtext,stringHvalue,System.Web.UI.WebControls.DropDownListHdropList,stringHsql,stringHtablename,stringCsValue){Open();try{myDataSet=this.GetDataSet(Hsql,Htablename);if(myDataSet.Tables[0].Rows.Count>0){for(inty=0;y<myDataSet.Tables[0].Rows.Count;y++){ListItemTempli=newListItem();Templi.Text=myDataSet.Tables[0].Rows[y][Htext].ToString().Trim();Templi.Value=myDataSet.Tables[0].Rows[y][Hvalue].ToString().Trim();HdropList.Items.Add(Templi);if(myDataSet.Tables[0].Rows[y][Hvalue].ToString().Trim()==CsValue){Templi.Selected=true;}}}}catch{RegisterStartupScript("btn","<scriptlanguage="javascript">alert('"+this.GetErrorDis()+"');</"+"script>");}finally{Close();}}#endregion
解决方案三：
前一个绑定dropdownlist,后一个根据选择联动.其中有得到dataset的类没发,你自己写就行