ajaxusername.aspx.cs

ajax+md5实现网站登陆注册模块源代码

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 ajaxUserName : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
   {

      string xmlStr = null;
      Response.ContentType = "text/xml";
      string str = Request.QueryString["userName"].Trim();
      string sqlstr = "select userName from UserTab where userName='" + str + "'";
      if (SelectTable(sqlstr) >= 1)
      {
          xmlStr = "<ajax-response><response type='element' id='findUserName'><p id='r'><font color='red' >用户名已经存在</font></p></response></ajax-response>";
          Response.Write(xmlStr);
      }
      else
      {
          xmlStr = "<ajax-response><response type='element' id='findUserName'><p id='r'><font color='green'>用户名可以使用</font></p></response></ajax-response>";
          Response.Write(xmlStr);
      }
       
    }
    public static int SelectTable(string sqlQuery)
    {
        SqlDataReader readset=null ;
        int i = 0;
        string strConn = "Initial Catalog = shopping; Data Source=127.0.0.1; Integrated Security=true";
        SqlConnection conn = new SqlConnection(strConn);
        conn.Open();
        SqlCommand cmd = new SqlCommand(sqlQuery ,conn);
        readset = cmd.ExecuteReader();
        if (readset.HasRows == true )
            i = 1;
        conn.Close();
        return i;
    }
    #region Web Form Designer generated code
    override protected void OnInit(EventArgs e)
    {

        InitializeComponent();
        base.OnInit(e);
    }

    /// <summary>
    /// 
    private void InitializeComponent()
    {
        this.Load += new System.EventHandler(this.Page_Load);
    }
    #endregion
}