regist.aspx.cs

一个简单的ASP.NET校友录系统。基于SQL

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 Regist : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack)
        {
            tbbyyx.Text = tbxusername.Text = tbxaddress.Text = tbxpass.Text = tbxqq.Text = tbxtel.Text = tbxrealname.Text = "";
        }

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        tbbyyx.Text = tbxusername.Text = tbxaddress.Text = tbxpass.Text = tbxqq.Text = tbxtel.Text = tbxrealname.Text = "";
    }
    protected void btnregist_Click(object sender, EventArgs e)
    {
        if (tbxusername.Text.Trim() == "")
        {
            Response.Write("<script>alert('用户名不能为空!')</script>");
            return;
        }
        if (tbxpass.Text.Trim() == "")
        {
            Response.Write("<script>alert('密码不能为空!')</script>");
            return;
        }
        if (tbxusername.Text.Trim() != "" && tbxpass.Text.Trim() != "")
        {
            if ((tbxpass.Text.Trim()) != (TextBox3.Text.Trim()))
            {
                Response.Write("<script>alert('两次密码不一致!')</script>");
                return;
            }
            else
            {
                db userdb = new db();
                userdb.Insert(tbxusername.Text, tbxpass.Text, tbxtel.Text, tbxrealname.Text, tbxaddress.Text, tbxqq.Text, tbxemail.Text, DropDownList1.SelectedValue, tbbyyx.Text);
            }
        }
        Response.Write("<script>alert('注册成功~')</script>");
        Response.Redirect("home.aspx");
    }
    protected void btnyz_Click(object sender, EventArgs e)
    {
        string sql;
        sql="select username from username where username='"+tbxusername.Text.Trim()+"'";
        db username = new db();
        SqlDataReader dr = username.Login(sql);
        if (dr.Read())
        {
            Session["username"] = dr["username"].ToString();
            message.Text = "用户名已经存在";
            return;
        }

        message.Text = "可以使用该用户名";
    }
}