AJAX三级联动

最新推荐文章于 2024-10-17 17:15:00 发布

刘少盟

最新推荐文章于 2024-10-17 17:15:00 发布

阅读量477

点赞数

文章标签： ajax dataset webservice function string cmm

本文链接：https://blog.csdn.net/meng6098/article/details/7435356

版权

WebService后台：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

namespace ProLianDong
{
/// <summary>
/// WebService1 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
[System.Web.Script.Services.ScriptService]
public class WebService1 : System.Web.Services.WebService
{

[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public string bindpr()
{
string str = ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
SqlConnection cnn = new SqlConnection(str);
SqlCommand cmm = cnn.CreateCommand();
cmm.CommandText = "select * from province";
SqlDataAdapter sda = new SqlDataAdapter(cmm);
DataSet dt = new DataSet();
sda.Fill(dt);
string opstr=null;
for (int i = 0; i <dt.Tables[0].Rows.Count; i++)
{

opstr += "<option value=" + dt.Tables[0].Rows[i][1].ToString() + ">" + dt.Tables[0].Rows[i][2].ToString() + "</option>";

}
return opstr;
}
[WebMethod]
public string bindct(int prid)
{
string str = ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
SqlConnection cnn = new SqlConnection(str);
SqlCommand cmm = cnn.CreateCommand();
cmm.CommandText = "select * from city where father="+prid;
SqlDataAdapter sda = new SqlDataAdapter(cmm);
DataSet dt = new DataSet();
sda.Fill(dt);
string ctstr = null;
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{

ctstr += "<option value=" + dt.Tables[0].Rows[i][1].ToString() + ">" + dt.Tables[0].Rows[i][2].ToString() + "</option>";

}
return ctstr;
}
[WebMethod]
public string bindar(int ctid)
{
string str = ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
SqlConnection cnn = new SqlConnection(str);
SqlCommand cmm = cnn.CreateCommand();
cmm.CommandText = "select * from area where father=" + ctid;
SqlDataAdapter sda = new SqlDataAdapter(cmm);
DataSet dt = new DataSet();
sda.Fill(dt);
string arstr = null;
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{

arstr += "<option value=" + dt.Tables[0].Rows[i][1].ToString() + ">" + dt.Tables[0].Rows[i][2].ToString() + "</option>";

}
return arstr;
}
}
}

..................................................................................
HTML：

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
<script src="Jquery1.7.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
bp();
$('#Select1').change(function () {
bc();
}),
$('#Select2').change(function () {
ba();
});
function bp() {
ProLianDong.WebService1.bindpr(onSuccess, onFailed);
function onSuccess(p) {

$('#Select1').html(p);

}
function onFailed() {

alert('失败！');
}
}
function bc() {
ProLianDong.WebService1.bindct($('#Select1').val(), onSuccess, onFailed);
function onSuccess(c) {
$('#Select2').html(c);
}
function onFailed() {

alert('失败！');
}
}
function ba() {
ProLianDong.WebService1.bindar($('#Select2').val(), onSuccess, onFailed);
function onSuccess(a) {

$('#Select3').html(a);

}
function onFailed() {

alert('失败！');
}
}
})
</script>
<style type="text/css">
#Select1
{
width: 89px;
}
#Select2
{
width: 101px;
}
#Select3
{
width: 177px;
}
#Text1
{
width: 142px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="~/WebService1.asmx" />
</Services>
</asp:ScriptManager>
<div>

姓名：<input id="Text1" type="text" /><br />
住址：<select id="Select1" name="D1">
<option></option>
</select><select id="Select2" name="D2">
<option></option>
</select><select id="Select3" name="D3">
<option></option>
</select></div>
</form>
</body>
</html>