1、这是本人在学校时照老师的要求做的最简单的ajax功能，不好勿喷。这代码主要分为html代码和cs后台代码，和数据库连接的功能我就没发数据库了，都是简单的数据库。（基于C# 的ajax功能实现代码。），仅供参考。1、地区信息查询 var XMLHttpRequest; var requestType = ; function getXMLHttpRequest() if (window.ActiveXObject) XMLHttpRequest = new ActiveXObject(Microsoft.XMLHTTP); else if (window.XMLHttpRequest) XMLH
2、ttpRequest = new XMLHttpRequest(); function sendRquest(request) requestType = request; getXMLHttpRequest(); XMLHttpRequest.onreadystatechange = stateChange; XMLHttpRequest.open(GET, XMLFile2.xml); XMLHttpRequest.send(null); function stateChange() if (XMLHttpRequest.readyState = 4) if (XMLHttpRequest
3、.status = 200) if (requestType = north) listNorthStates(); else if (requestType = all) listAllStates(); else if (requestType = south) listSouthStates(); else if (requestType = east) listEastStates(); else if (requestType = west) listWestStates(); var northStates; var southStates; var eastStates; var
4、 westStates; var allStates; function listNorthStates() var xmlDOC = XMLHttpRequest.responseXML; var northNode = xmlDOC.getElementsByTagName(north)0; northStates = northNode.getElementsByTagName(state); output(北部?州Y名?, northStates); function listSouthStates() var xmlDOC = XMLHttpRequest.responseXML;
5、var southNode = xmlDOC.getElementsByTagName(south)0; southStates = southNode.getElementsByTagName(state); output(南?部?州Y名?, southStates); function listEastStates() var xmlDOC = XMLHttpRequest.responseXML; var eastStates = xmlDOC.getElementsByTagName(east)0; eastStates = eastNode.getElementsByTagName(
6、state); output(东?部?州Y名?, eastStates); function listWestStates() var xmlDOC = XMLHttpRequest.responseXML; var westStates = xmlDOC.getElementsByTagName(west)0; westStates = westNode.getElementsByTagName(state); output(西部?州Y名?, westStates); function listAllStates() var xmlDOC = XMLHttpRequest.responseX
7、ML; allStates = xmlDOC.getElementsByTagName(state); output(所有D州Y名?, allStates); function output(title, states) var out = title; var currentSate = null; for (var i = 0; i states.length; i+) currentState = statesi; out = out + n- + currentState.childNodes0.nodeValue; alert(out);显?示?美国的?州Y名? &nb
8、sp; 2、信息增删改查 Html页面 var xmlHttp; var name; var num; var Bclass; var deleteID; function createXMLHttpRequest() if (window.ActiveXObject) xmlHttp = new ActiveXObject(Microsoft.XMLHTTP); else if (window.XMLHttpRequest) xmlHttp = new XMLHttpRequest(); function addEmployee() name = document.getEle
9、mentById(name).value; num = document.getElementById(num).value; Bclass = document.getElementById(Bclass).value; if (name = | num = | Bclass = ) return; var url = zsgc.aspx? + createAddQueryString(name, num, Bclass, ffstudent); +&ts= + new Date().getTime(); createXMLHttpRequest(); xmlHttp.onreadystat
10、echange = handleAddStatechange; xmlHttp.open(GET, encodeURI(url), true); xmlHttp.send(null); function delEmployee() num = document.getElementById(num).value; if (num = ) return; var url = zsgc.aspx? + createDelQueryString(num, delstuent); +&ts= + new Date().getTime(); createXMLHttpRequest(); xmlHttp
11、.onreadystatechange = handleAddStatechange; xmlHttp.open(GET, encodeURI(url), true); xmlHttp.send(null); function cxEmployee() num = document.getElementById(num).value; action = cxstudent; if (num = ) return; var url = zsgc.aspx? + createcxQueryString(num, action); +&ts= + new Date().getTime(); crea
12、teXMLHttpRequest(); xmlHttp.onreadystatechange = handleAddStatechange; xmlHttp.open(GET, encodeURI(url), true); xmlHttp.send(null); function createAddQueryString(name, num, Bclass, action) var queryString = name= + name + &num= + num + &Bclass= + Bclass + &action= + action; return queryString; funct
13、ion createDelQueryString(num, action) var queryString = num= + num + &action= + action; return queryString; function createcxQueryString(num, action) var queryString = num= + num + &action= + action; return queryString; function handleAddStatechange() if (xmlHttp.readyState = 4) if (xmlHttp.status =
14、 200) alert(xmlHttp.responseText); clearInputBoxes(); else alert(Error while adding employee.); function clearInputBoxes() document.getElementById(name).value = ; document.getElementById(num).value = ; document.getElementById(Bclass).value = ; 学
15、生信?息姓?名?：o 学号?：o 班级?：o Cs后台代码.using System;using System.Collections.Generic;using System.Data;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;public partial class zsgc : System.Web.UI.Page protected void Page_Load(object sender, Even
16、tArgs e) string str = Data Source=.;Initial Catalog=Student;Integrated Security=True; SqlConnection coon = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); try coon.Open(); string action = Requestaction.ToString(); string num = Requestnum.ToString(); if (action = ffstudent) string Bclass =
17、 RequestBclass.ToString(); string name = Requestname.ToString(); SqlParameter par = new SqlParameter(name,name), new SqlParameter (num,num), new SqlParameter (Bclass,Bclass ) ; cmd.Connection = coon; cmd.CommandText = ffstudent; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddRange(
18、par); int i = cmd.ExecuteNonQuery(); if (i 0) Response.Write(添加成功|！?); else Response.Write(添加失败！?); else if (action = delstuent) SqlParameter par = new SqlParameter (num,num) ; cmd.Connection = coon; cmd.CommandText = delstuent; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddRange(
19、par); int i = cmd.ExecuteNonQuery(); if (i 0) Response.Write(删?除y成功|！?); else Response.Write(删?除y失败！?); else if (action = cxstudent) DataTable dt = new DataTable(); SqlParameter par = new SqlParameter (num,num) ; cmd.Connection = coon; cmd.CommandText = cxstudent; cmd.CommandType = CommandType.Store
20、dProcedure; cmd.Parameters.AddRange(par); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); string str1 = ; for (int i = 0; i dt.Rows.Count; i+) str1 += dt.Rowsi0.ToString() + : + dt.Rowsi1.ToString() + : + dt.Rowsi2.ToString(); Response.Write(str1); coon.Close(); catch (Exception e1) Respon
21、se.Write(e1.ToString();3、注册无T标题a页3 var xmlHttp; function vilidation() xmlHttp = new ActiveXObject(Microsoft.XMLHTTP); var name = document.getElementById(Txt1); if (name.value != ) xmlHttp.open(Post, zhuce.aspx?name= + name.value); xmlHttp.onreadystatechange = OnMessageBack; xmlHttp.send(null); else
22、alert(用?户名?不?能为a空?！?); function OnMessageBack() if (xmlHttp.readystate = 4 & xmlHttp.status = 200) alert(document.write(xmlHttp.responsetext); 用?户注册验证 Csusing System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;usi
23、ng System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;public partial class zhuce : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (Requestname != ) strin
24、g name = this.Requestname; string connStr = Data Source=.;Initial Catalog=User;Integrated Security=True;Pooling=False; SqlConnection conn = new SqlConnection(connStr); conn.Open(); string selStr = select * from dbo.use1 where name= + name + ; SqlCommand com = new SqlCommand(selStr, conn); SqlDataRea
25、der da = com.ExecuteReader(); if (da.Read() Response.Write(用?户名?已?存?在！?！?); else Response.Write(注册成功|！?！?); 4、自动完成 自?动完成 var xmlHttp; var completeDiv; var inputField; var nameTable; var nameTableBody; function createXMLHttpRequest() if (window.ActiveXObject) xmlHttp = new ActiveXObject(Microsoft.XML
26、HTTP); else if (window.XMLHttpRequest) xmlHttp = new XMLHttpRequest(); function initVars() inputField = document.getElementById(names); nameTable = document.getElementById(name_table); completeDiv = document.getElementById(popup); nameTableBody = document.getElementById(name_table_body); function fi
27、ndNames() initVars(); if (inputField.value.length 0) createXMLHttpRequest(); var url = ZDWC.aspx?names= + escape(inputField.value); xmlHttp.open(GET, url, true); xmlHttp.onreadystatechange = callback; xmlHttp.send(null); else clearNames(); function callback() if (xmlHttp.readyState = 4) if (xmlHttp.
28、status = 200) setNames(xmlHttp.responseXML.getElementsByTagName(name); else if (xmlHttp.status = 1223) clearNames(); function setNames(the_names) clearNames(); var size = the_names.length; setOffsets(); var row, cell, txtNode; for (var i = 0; i size; i+) var nextNode = the_namesi.firstChild.data; ro
29、w = document.createElement(tr); cell = document.createElement(td); cell.onmouseout = function() this.className = mouseOver; ; cell.onmouseover = function() this.className = mouseOut; ; cell.setAttribute(bgcolor, #FFFAFA); cell.setAttribute(border, 0); cell.onclick = function() populateName(this); ;
30、txtNode = document.createTextNode(nextNode); cell.appendChild(txtNode); row.appendChild(cell); nameTableBody.appendChild(row); function setOffsets() var end = inputField.offsetWidth; var left = calculateOffsetLeft(inputField); var top = calculateOffsetTop(inputField) + inputField.offsetHeight; completeD
