利用webservice实现无刷新

最新推荐文章于 2016-11-15 14:12:32 发布

caizisy

最新推荐文章于 2016-11-15 14:12:32 发布

阅读量926

点赞数

CC 4.0 BY-SA版权

分类专栏：经验文章标签： webservice server database components assembly string

本文链接：https://blog.youkuaiyun.com/caizisy/article/details/893611

经验专栏收录该内容

5 篇文章

订阅专栏

这篇博客介绍了一种使用Atlas和Web服务技术来实现在网页上进行无刷新联动操作的方法。通过示例代码展示了如何在选择省份后动态更新城市下拉列表，从而在不重新加载页面的情况下获取并显示相关数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

此文件是利用atlas和webservice技术实现无刷新的联动操作.具体操作过程见代码:

页面文件

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Update.aspx.cs" Inherits="Update" %><%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="cc1" %>
<!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 runat="server">
    <title>无标题页</title>
    <script language = "javascript" type = "text/javascript" >


    function getCity(value)
    {
        if(value != null)
        {
            Double.City(value, returnCity);
        }
    }

    function returnCity(result)
    {

       //删除旧的纪录
      for (var i=document.getElementById("ddlCity").options.length - 1 ; i>-1; i--) //记住，要从后面删除起
     {
         document.getElementById("ddlCity").options[i] = null;
      }

        var cityArr = result.split(";"); //拆分返回的字符串

//向下拉列表框中添加数据

        </div>
    </form>
    <script type="text/xml-script">
        <page xmlns:script="http://schemas.microsoft.com/xml-script/2005">
            <references>
            </references>
            <components>
            </components>
        </page>
    </script>
</body>
</html>

cs文件

public partial class Update : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            LoadProv();
            ddlProv.Attributes.Add("onchange", "getCity(this.value)");

        }

    }

    private void LoadProv()
    {
        SqlConnection sqlCon = new SqlConnection("server = NIC; database = yourtrip; uid = sa; pwd = 888888");
        SqlCommand sqlCmd = new SqlCommand();
        sqlCmd.Connection = sqlCon;
        sqlCmd.CommandType = CommandType.Text;
        sqlCmd.CommandText = "select code, codename from dd where code like '001%' and len(code) = 6";
        SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
        DataTable dt = new DataTable("temp");
        sqlDa.Fill(dt);
        ddlProv.DataValueField = "code";
        ddlProv.DataTextField = "codename";
        ddlProv.DataSource = dt;
        ddlProv.DataBind();
    }
}

webservice代码

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Collections.Generic;
using System.Collections.Specialized;
using AtlasControlToolkit;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Double 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Double : System.Web.Services.WebService
{

    [WebMethod]
    public string City(string code)
    {
        SqlConnection sqlCon = new SqlConnection("server = 127.0.0.1; database = text; uid = sa; pwd = 888888");
        SqlCommand sqlCmd = new SqlCommand();
        sqlCmd.Connection = sqlCon;
        sqlCmd.CommandType = CommandType.Text;
        sqlCmd.CommandText = "select code, codename from dd where code like '" + code + "%'";
        SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
        DataTable dt = new DataTable("temp");
        sqlDa.Fill(dt);
        string city = string.Empty;
        foreach(DataRow dr in dt.Rows)
        {
            city += Convert.ToString(dr["code"]) + Convert.ToString(dr["codename"]) + ";";
        }
        return city;
    }

}