Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/1/30 0:58:15 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
赞