ajax验证用户名是否存在_ajax请求完成注册判断用户名是否存在-CSDN博客

本文链接：https://blog.csdn.net/susongyu/article/details/5848901

LoginValidate.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="LoginValidate.aspx.cs" Inherits="Admin_LoginValidate" %>

<!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>
<body>
    <form id="form1" runat="server">
        <div>
            <h1 align="center">
                验证用户名是否存在</h1>
            <table align="center" style="width: 487px">
                <tr>
                    <td style="width: 70px">
                        用户名：</td>
                    <td style="width: 231px">
                        <input id="username" οnchange="CheckUserName();" type="text" />
                        <input id="Button1" type="button" value="button" οnclick="CheckUserName();" /></td>
                    <td id="Msg1">
                        <asp:Label ID="Msg" runat="server" ForeColor="Blue"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td style="width: 70px">
                    </td>
                    <td style="width: 231px">
                    </td>
                    <td>
                    </td>
                </tr>
            </table>
        </div>
    </form>
</body>
</html>

LoginValidate.ashx

<%@ WebHandler Language="C#" Class="LoginValidate" %>

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public class LoginValidate : IHttpHandler {

    public void ProcessRequest (HttpContext context) {
        //context.Response.ContentType = "text/plain";
        //context.Response.Write("Hello World");
        context.Response.ContentType = "text/plain";
        string username = context.Request.QueryString["username"].ToString();
        string strSQL = "select username from users where username='" + username + "'";
        if (ReDataSet(strSQL).Tables[0].Rows.Count > 0)
        {
            context.Response.Write("该用户已经有人使用！");
        }
        else
        {
          if (username.Trim().Length>int.Parse("0"))
            {
            context.Response.Write("恭喜你！" + username + "可以使用！");
            }
            else
            {
                context.Response.Write("请您输入用户名！");
            }

}
System.Threading.Thread.Sleep(1000);

}

//数据库连接字符串
public static string strCon = "Data Source=.;database=test;uid=sa;pwd=;";

    /// <summary>
    /// 执行SQL语句，返回DataSet
    /// </summary>
    /// <param name="strSQL"></param>
    /// <returns></returns>
    public DataSet ReDataSet(string strSQL)
    {
      // SqlConnection con = new SqlConnection(strCon);
        using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
        try
        {
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter(strSQL, con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
        finally
        {
            con.Close();
        }
    }