ajax+WebServer及Dataset转xml操作实例

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

前台

1. <%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
3. <html>
4. <head runat="server">
5.     <title>ajax+WebServer及Dataset转xml操作实例</title>
6.      <script type="text/javascript" language="javascript">
7.     var xmlhttp;//声明一个变量
8.     try
9.     {
10.         xmlhttp=new ActiveXObject('Msxml2.XMLHTTP');
11.     }
12.     catch(e)
13.     {
14.         try
15.         {
16.             xmlhttp= new ActiveXObject('Microsoft.XMLHTTP');
17.         }
18.         catch(e)
19.         {
20.             try
21.             {
22.                 xmlhttp=new XMLHttpRequest();
23.             }
24.             catch(e)
25.             {
26.             }
27.         }
28.     }
29.     var temp=new Array();
30.     var url="WebService.asmx/HelloWorld";
31.     xmlhttp.open("post",url,true);        
32.     xmlhttp.onreadystatechange=function()
33.     {
34.         if(xmlhttp.readyState==4)
35.         {
36.             if(xmlhttp.status==200)
37.             {
38.                 var xmldoc=xmlhttp.responseText;
39.                 xmldocxmldoc=xmldoc.replace(/</gi,"<");
40.                 xmldocxmldoc=xmldoc.replace(/>/gi,">");
41.                 var xmlDoc2 = new ActiveXObject("Microsoft.XMLDOM");
42.                 xmlDoc2.async="false";
43.                 xmlDoc2.loadXML(xmldoc);
44.                 if(xmlDoc2.parseError.errorCode != 0)
45.                 {
46.                     alert("读取xml出错");
47.                 }
48.                 else
49.                 {
50.                     if(xmlDoc2.readyState==4)
51.                     {
52.                         var id = xmlDoc2.documentElement.selectNodes("//id");
53.                         var name = xmlDoc2.documentElement.selectNodes("//name");
54.                         var temp="";
55.                         for(var i=0;i<id.length;i++)
56.                         {   
57.                             temp+=id(i).text+"  "+name(i).text+"<br>";                         
58.                         }        
59.                         document.getElementById("list").innerHTML=temp;             
60.                     }
61.                     else
62.                     {
63.                         alert("加载失败");
64.                     }
65.                 }
66.             }
67.             else
68.             {
69.                alert(xmlhttp.status);
70.             }
71.         }
72.     }
73.     xmlhttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded");   
74.     xmlhttp.send(null);        
75.     </script>
76. </head>
77. <body>
78.     <form id="form1" runat="server">
79.     <div>
80.     <span id="list"></span>
81.     </div>
82.     </form>
83. </body>
84. </html>

WebService.asmx

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

 

WebService.cs

1. using System;
2. using System.Web;
3. using System.Collections;
4. using System.Web.Services;
5. using System.Web.Services.Protocols;
6. using System.Data;
7. using System.Data.SqlClient;
8. using System.Xml;
10. /// <summary>
11. /// WebService 的摘要说明
12. /// </summary>
13. [WebService(Namespace = "http://tempuri.org/")]
14. [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
15. public class WebService : System.Web.Services.WebService {
17.     public WebService () {
19.         //如果使用设计的组件，请取消注释以下行 
20.         //InitializeComponent(); 
21.     }
23.     [WebMethod]
24.     public string HelloWorld() {
25.         string conn = "server=127.0.0.1;database=temp;min pool size=40;User ID=sa;Password=sa123";
26.         SqlConnection myConn = new SqlConnection(conn);
27.         myConn.Open();
28.         string cmd = "select * from [user] order by id desc";
29.         SqlDataAdapter myRead = new SqlDataAdapter(cmd, myConn);
30.         DataSet mySet = new DataSet();
31.         myRead.Fill(mySet, "user");
32.         myConn.Close();
33.         return mySet.GetXml();
34.     }
35.     
36. }

数据库名称temp

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