日期:2014-05-18  浏览次数:20468 次

谁有二级联动的代码呀?发给我看看吧**********************
我用的是asp.net+SqlServer,
想做的是用两个DropDownList来实现省市的联动.
省和市从数据库里取的.谢谢啦

------解决方案--------------------
http://blog.csdn.net/iuhxq/archive/2006/11/08/1372602.aspx
------解决方案--------------------
http://www.51aspx.com/S/%e8%81%94%e5%8a%a8.aspx
------解决方案--------------------
对于比较大型的项目来说,把联动类别在添加或者修改时生成静态的js文件(数组存放),然后在应用时候只是调用就行了,不用去读库...写几个js函数来关联相关项
------解决方案--------------------
顶BLUEICExx!
------解决方案--------------------
我就是用vs2003 做的 数据库是 sqlserver2000 你看看吧 把数据库附加上 直接能打开运行
------解决方案--------------------
function load(state){
var drp2 = document.getElementById( "usershi ");
for(var i = drp2.length; i > = 0; i--)
{
drp2.options.remove(i);
}
try
{
var oHttpReq = new ActiveXObject( "MSXML2.XMLHTTP ");
var oDoc = new ActiveXObject( "MSXML2.DOMDocument ");

}
catch(e)
{
var oHttpReq = new ActiveXObject( "Microsoft.XMLHTTP ");
var oDoc = new ActiveXObject( "Microsoft.DOMDocument ");

}
oHttpReq.open( "POST ", "../getchild.aspx?pid= "+state, false);
oHttpReq.send( " ");
result = oHttpReq.responseText;
oDoc.loadXML(result);
items1 = oDoc.selectNodes( "//NewDataSet/Table/xianshi_id ");
items2 = oDoc.selectNodes( "//NewDataSet/Table/xianshi_name ");
var itemsLength=items1.length;
   for(i=0;i <itemsLength;i++){
   var newOption = document.createElement( "OPTION ");
   newOption.text=items2[i].text;
   newOption.value=items1[i].text;
   drp2.options.add(newOption);
   }

getchild.aspx
public partial class getchild : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{


if(this.Request[ "pid "]!=null){
string pid = this.Request[ "pid "].ToString().Trim();
string sql= "select xianshi_id,xianshi_name from zwdh_xianshi where xianshi_pid = ' "+pid+ " ' ";
DataSet ds = new DataSet();
ds=DataClass.FillDs(sql);
XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, System.Text.Encoding.UTF8);
writer.Formatting=Formatting.Indented;
writer.Indentation=4;

writer.IndentChar= ' ';
ds.WriteXml(writer);
//ds.WriteXml(writer);

writer.Flush();
Response.End();
writer.Close();

}
}
}