Asp.Net+Ajax 用户名检测_[Asp.Net教程]
AJAX用户名检测
前台的JS代码:
前台的控件:
查询页checkusername.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 checkusername : System.Web.UI.Page
{
private string sConnectionString = ConfigurationManager.ConnectionStrings["WebConnString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
string sUserName = Request.QueryString["username"].Trim().ToString();
using (SqlConnection conn = new SqlConnection(sConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM tbWebManage WHERE UserName=@UserName", conn))
{
cmd.Parameters.AddWithValue("@UserName", sUserName);
string sResult = Convert.ToString(cmd.ExecuteScalar());
Response.Clear();
if (sResult == "0")
{
Response.Write("1");
}
else
{
Response.Write("0");
}
Response.End();
}
}
}
}
来源:cnblogs