輸入頁面:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EX_Ajax.aspx.cs" Inherits="Test" %>
<!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 id="Head1" runat="server">
<title>輸入頁面</title>
</head>
<script language="javascript">
var xmlHttp;
function createXMLHttpRequest()
{
if(window.ActiveXObject)
xmlHttp=new window.ActiveXObject("Microsoft.XMLHttp");
else if(window.XMLHttpRequest)
xmlHttp=new window.XMLHttpRequest();
}
function startRequest()
{
var url="EX_Ajax_Check.aspx?UniqueID="+document.form1 .TextBox1.value;
createXMLHttpRequest();
xmlHttp.OnReadyStateChange=HandleStateChange;
xmlHttp.open("Get",url,true);
xmlHttp.send(null);
}
function HandleStateChange()
{
if(xmlHttp.ReadyState==4)
{
if(xmlHttp.Status==200)
{
try
{
simple();
}
catch (exception)
{
alert("error");
}
}
}
}
function simple()
{
var response = xmlHttp.responseText;
alert(response);
}
</script>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /><br />
<br />
<br />
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/Data/Blog.mdb"
SelectCommand="SELECT [UniqueID], [DTitle], [DPostDate] FROM [Daily]"></asp:AccessDataSource>
</div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="UniqueID" DataSourceID="AccessDataSource1">
<Columns>
<asp:BoundField DataField="UniqueID" HeaderText="UniqueID" InsertVisible="False"
ReadOnly="True" SortExpression="UniqueID" />
<asp:BoundField DataField="DTitle" HeaderText="DTitle" SortExpression="DTitle" />
<asp:BoundField DataField="DPostDate" HeaderText="DPostDate" SortExpression="DPostDate" />
</Columns>
</asp:GridView>
</form>
</body>
</html>
Button添加:Button1.Attributes.Add("onclick", "javascript:startRequest();");
驗證頁面:
Response.Clear();
string temp = Request.QueryString["UniqueID"].Trim ();
if (temp != null)
{
string connectstring = "provider=Microsoft.jet.oledb.4.0;data source=" + Server.MapPath("../data/blog.mdb");
OleDbConnection conn = new OleDbConnection(connectstring);
conn.Open();
string sql = "select count(*) as num from daily where UniqueID=" + temp + "";
OleDbCommand cmd = new OleDbCommand(sql, conn);
int i = Convert.ToInt16(cmd.ExecuteScalar());
if (i > 0)
{
Response.Write("已存在");
}
else
{
Response.Write("不存在!");
}
}
Response.End();