我今天晚上打算学习使用xmlHttp读取服务器端的数据库里面的某表的几个字段的数据,然后显示到客户端!谢谢大家帮助我!提示:我已经有了一小点无刷新基础知识,我能做到无刷新注册、判断是否注册重名,两个小小的扎实基础拉!但是我对于JS不太熟悉,希望大家帮助!需要的核心代码是:①服务器以什么样的方式返回各字段数据的值到客户端②客户端接收到数据之后,又如何显示出来,那种JS代码怎么写啊11点半之前结贴在此谢过!
调试欢乐多
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Index.aspx.cs" Inherits="Index" %><!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>
</head><script>
var xmlhttp=new ActiveXObject("Microsoft.XMLhttp");
var oDoc = new ActiveXObject("MSXML2.DOMDocument"); function SendAjax()
{ //通过post方式访问Receive.aspx页面
xmlhttp.Open("post","Receive.aspx",true);
xmlhttp.send("");
xmlhttp.onreadystatechange = GetValue;
}
function GetValue()
{
if(xmlhttp.ReadyState==4)
{
//获取页面返回结果。
var result = xmlhttp.responsetext;
oDoc.loadXML(result);
//获取table节点
items=oDoc.selectNodes("/NewDataSet/Table");
var pp = document.getElementById("px");
var text="<table style='border: 1px #ccc solid;'>";
var item = items.nextNode();
while(item)
{
text+="<tr><td>"+item.selectSingleNode("name").nodeTypedValue+"</td><td>"+item.selectSingleNode("sex").nodeTypedValue+"</td></tr>";
item=items.nextNode();
}
text+="</table>";
pp.innerHTML=text;
}
}
</script><body>
<form id="form1" runat="server">
<div>
<input id="ok" value="我看看" type="button" onclick="javascript:SendAjax();" />
<div id="px"></div>
</div>
</form>
</body>
</html>通过Receive页面读取数据,Receive页面后台代码。using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Diagnostics;
using System.Data.SqlClient;
using System.Xml;
public partial class Receive : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//读取数据库信息并转换为xml
using (SqlConnection conn = new SqlConnection("server=.;database=master;uid=sa;pwd=wsp"))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select name,sex from ps", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds); XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding);
ds.WriteXml(writer);
writer.Flush();
Response.End();
writer.Close();
}
}
}