下载的一个封装好的JS省市区联动,怎样把数据库的信息赋值给下拉
<select name="province3" id="province3" class="province3"></select><select name="city3" id="city3" class="city3"></select><select name="area3" id="area3"></select>
<script language="javascript" type="text/javascript">
new PCAS("province3", "city3", "area3");
</script>asp.netjs
<select name="province3" id="province3" class="province3"></select><select name="city3" id="city3" class="city3"></select><select name="area3" id="area3"></select>
<script language="javascript" type="text/javascript">
new PCAS("province3", "city3", "area3");
</script>asp.netjs
<option value='值1'>文本1</option>
<option value='值2'>文本2</option>
<option value='值3'>文本3</option>
填充到下拉狂里面(jquery): $("#下拉id").html(返回的字符串);
window.onload = function() {
document.getElementById("province3").value = document.getElementById("HiddenField1").value;
document.getElementById("city3").value = document.getElementById("HiddenField2").value;
document.getElementById("area3").value = document.getElementById("HiddenField3").value;
}
</script>
把数据库的信息放到这三个隐藏域HiddenField里了,省可以被正确赋值
public string province,city,area;赋值:
province = "北京市";
city = "市辖区";
area = "朝阳区";
.aspx页面
<select name="province3" id="province3" class="province3"></select><select name="city3" id="city3" class="city3"></select><select name="area3" id="area3"></select>
<script language="javascript" type="text/javascript">
new PCAS("province3", "city3", "area3",<%=province%>,<%=city%>,<%=area%>);
</script>
http://popub.net:81/script/PCAS.html
public string province, city, area;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
province = "北京市";
city = "市辖区";
area = "朝阳区";
}
}
前台按你刚说的弄得
<select name="province3" id="province3"></select><select name="city3" id="city3"></select><select name="area3" id="area3"></select>
<script language="javascript" type="text/javascript">
new PCAS("province3", "city3", "area3",<%=province%>,<%=city%>,<%=area%>);
</script>
window.onload = function() {
document.getElementById("province3").value = document.getElementById("HiddenField1").value;
document.getElementById("city3").value = document.getElementById("HiddenField2").value;
document.getElementById("area3").value = document.getElementById("HiddenField3").value;
}
</script>
把数据库的信息放到这三个隐藏域HiddenField里了,省可以被正确赋值
以前我也这么做过,但是很麻烦,还是异步获取方便,尽量不要这么做吧:
首次加载即加载所有省(如果是修改页面则在夹在后选中一个)
其次选择省的话,在onchange事件里面 异步获取选中省的市,填充市的下拉(县则相同),(如果选择其他省那么省以下的市区县 都要清空从而重新加载市);
<select id="pro" onchange="GetCity()"></select>
<select id="city" onchange="GetArea()"></select>
<select id="areas"></select><script src="../../Scripts/jquery-1.7.1.js" type="text/javascript"></script><script type="text/javascript">
window.onload = GetProvince;
//页面初始化加载省
function GetProvince() {
$.ajax({
type: "post",
url: "请求省数据的路径",
success: function (strpro) {
if (strpro != "") {
$("#pro").html(strpro);
}
}
});
}
function GetCity() {
//清空市和县
$("#city").empty();
$("#areas").empty(); //请求市的数据
$.ajax({
type: "post",
url: "请求市数据的路径",
date: { proid: $("#pro").val() },//参数,省id
success: function (strcity) {
if (strcity != "") {
$("#city").html(strcity);
}
}
});
}
function GetArea() {
//请求县区数据
$.ajax({
type: "post",
url: "请求县数据的路径",
date: { proid: $("#city").val() }, //参数,市id
success: function (strares) {
if (strares != "") {
$("#areas").html(strares);
}
}
});
}
</script>
<script language="javascript" type="text/javascript">
new PCAS("province3", "city3", "area3","<%=province%>","<%=city%>","<%=area%>");
</script>
window.onload = function() {
document.getElementById("province3").value = document.getElementById("HiddenField1").value;
document.getElementById("city3").value = document.getElementById("HiddenField2").value;
document.getElementById("area3").value = document.getElementById("HiddenField3").value;
}
</script>
把数据库的信息放到这三个隐藏域HiddenField里了,省可以被正确赋值
以前我也这么做过,但是很麻烦,还是异步获取方便,尽量不要这么做吧:
首次加载即加载所有省(如果是修改页面则在夹在后选中一个)
其次选择省的话,在onchange事件里面 异步获取选中省的市,填充市的下拉(县则相同),(如果选择其他省那么省以下的市区县 都要清空从而重新加载市);
<select id="pro" onchange="GetCity()"></select>
<select id="city" onchange="GetArea()"></select>
<select id="areas"></select><script src="../../Scripts/jquery-1.7.1.js" type="text/javascript"></script><script type="text/javascript">
window.onload = GetProvince;
//页面初始化加载省
function GetProvince() {
$.ajax({
type: "post",
url: "请求省数据的路径",
success: function (strpro) {
if (strpro != "") {
$("#pro").html(strpro);
}
}
});
}
function GetCity() {
//清空市和县
$("#city").empty();
$("#areas").empty(); //请求市的数据
$.ajax({
type: "post",
url: "请求市数据的路径",
date: { proid: $("#pro").val() },//参数,省id
success: function (strcity) {
if (strcity != "") {
$("#city").html(strcity);
}
}
});
}
function GetArea() {
//请求县区数据
$.ajax({
type: "post",
url: "请求县数据的路径",
date: { proid: $("#city").val() }, //参数,市id
success: function (strares) {
if (strares != "") {
$("#areas").html(strares);
}
}
});
}
</script>
现在可以了,谢了