html代码:
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<script type="text/javascript" language="javascript">
var xmlHttp = null;
function createXMLHTTP()
{
var arrSignatures=["MSXML2.XMLHTTP.5.0","MSXML2.XMLHTTP.4.0","MSXML2.XMLHTTP.3.0","MSXML2.XMLHTTP","Microsoft.XMLHTTP"];
for(var i=0;i<arrSignatures.length;i++)
try
{
var oRequest=new ActiveXObject(arrSignatures[i]);
return oRequest;
}
catch(oError)
{
}
throw new Error("MSXML is not installed on your system.");
}
function CheckUser()
{
xmlHttp=createXMLHTTP();
var Text1 = document.getElementById("Text1");
var url = "chkuser.aspx?User=" + Text1.value;
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange = OnHandler;
xmlHttp.send(null);
}
function OnHandler()
{
if(xmlHttp.readyState == 4)
{
var isValid = xmlHttp.responseText;
var exists = document.getElementById("exsits");
exists.innerHTML = isValid.substring(0,8);
}
}
</script>
<body>
<form id="form1" runat="server">
<div>
<input id="Text1" type="text" οnblur=CheckUser() /><label id="exsits"></label><br />
</div>
</form>
</body>
</html>
chkuser.aspx页面代码:
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.Data.SqlClient;
public partial class chkuser : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string username = Request.QueryString["User"].ToString();
checkuser(username);
}
protected void checkuser(string username)
{
SqlConnection con=new SqlConnection("Data Source=QJD-91554EB2B63//SQLEXPRESS;Initial Catalog=test;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("select count(*) from UserInfo where userName='"+username+"'", con);
int count=Convert.ToInt32(cmd.ExecuteScalar());
if (count <= 0)
{
Response.Write("用户不存在");
}
else
{
Response.Write("用户已经存在");
}
}
}