ajax+WebServer及Dataset转xml操作实例

来源：互联网发布：物理教学软件编辑：程序博客网时间：2024/05/12 22:33

一个程序代码把它写到blog上

前台

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<html>
<head runat="server">
    <title>ajax+WebServer及Dataset转xml操作实例</title>
     <script type="text/javascript" language="javascript">
    var xmlhttp;//声明一个变量
    try
    {
        xmlhttp=new ActiveXObject('Msxml2.XMLHTTP');
    }
    catch(e)
    {
        try
        {
            xmlhttp= new ActiveXObject('Microsoft.XMLHTTP');
        }
        catch(e)
        {
            try
            {
                xmlhttp=new XMLHttpRequest();
            }
            catch(e)
            {
            }
        }
    }
    var temp=new Array();
    var url="WebService.asmx/HelloWorld";
    xmlhttp.open("post",url,true);        
    xmlhttp.onreadystatechange=function()
    {
        if(xmlhttp.readyState==4)
        {
            if(xmlhttp.status==200)
            {
                var xmldoc=xmlhttp.responseText;
                xmldocxmldoc=xmldoc.replace(/</gi,"<");
                xmldocxmldoc=xmldoc.replace(/>/gi,">");
                var xmlDoc2 = new ActiveXObject("Microsoft.XMLDOM");
                xmlDoc2.async="false";
                xmlDoc2.loadXML(xmldoc);
                if(xmlDoc2.parseError.errorCode != 0)
                {
                    alert("读取xml出错");
                }
                else
                {
                    if(xmlDoc2.readyState==4)
                    {
                        var id = xmlDoc2.documentElement.selectNodes("//id");
                        var name = xmlDoc2.documentElement.selectNodes("//name");
                        var temp="";
                        for(var i=0;i<id.length;i++)
                        {   
                            temp+=id(i).text+"  "+name(i).text+"<br>";                         
                        }        
                        document.getElementById("list").innerHTML=temp;             
                    }
                    else
                    {
                        alert("加载失败");
                    }
                }
            }
            else
            {
               alert(xmlhttp.status);
            }
        }
    }
    xmlhttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded");   
    xmlhttp.send(null);        
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <span id="list"></span>
    </div>
    </form>
</body>
</html>

WebService.asmx

<%@ WebService Language="C#" CodeBehind="~/App_Code/WebService.cs" Class="WebService" %>

WebService.cs

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
/// <summary> 
/// WebService 的摘要说明 
/// </summary> 
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class WebService : System.Web.Services.WebService {
    public WebService () {
        //如果使用设计的组件，请取消注释以下行  
        //InitializeComponent();  
    }
    [WebMethod]
    public string HelloWorld() {
        string conn = "server=127.0.0.1;database=temp;min pool size=40;User ID=sa;Password=sa123";
        SqlConnection myConn = new SqlConnection(conn);
        myConn.Open();
        string cmd = "select * from [user] order by id desc";
        SqlDataAdapter myRead = new SqlDataAdapter(cmd, myConn);
        DataSet mySet = new DataSet();
        myRead.Fill(mySet, "user");
        myConn.Close();
        return mySet.GetXml();
    }
    
}

数据库名称temp

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[user]
GO
CREATE TABLE [dbo].[user] (
    [id] [int] IDENTITY (1, 1) NOT NULL ,
    [name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO