register.aspx.cs

这是我做的第一个网络购书中心asp.net网站!

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;

public partial class User_Register : System.Web.UI.Page
{
    DBConn dbconn = new DBConn();
    UserInfo ui = new UserInfo();
    protected void Page_Load(object sender, EventArgs e)
    {
        labWarm.Visible = false;
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (ui.IsUserExist(txtName.Text.Trim()))
        {
            labWarm.Visible = true;
            labWarm.Text = "用户以存在,请选择其他的用户名";
        }
        else
        {
            string sql = "INSERT INTO tb_Member(Name, Sex, [Password], TrueName, Questions, Answers, Phonecode,"
            + "Emails, City, Address, PostCode,LoadDate)VALUES ('" + txtName.Text.Trim() + "','"
            + ddlSex.SelectedIndex + "','" + txtPassword.Text.Trim() + "','" + txtTrueName.Text.Trim() + "','','','" +txtPhone.Text.Trim()
            +"','"+ txtEmail.Text.Trim() + "','" + ddlCity.SelectedItem.ToString() +"','"+txtAddress.Text.Trim()+"','"+txtPostCode.Text.Trim() 
            +"','"+DateTime.Now.ToString()+ "')";
            if (ui.registerUser(sql))
            {
                Response.Redirect("~/User/registerloadingw.aspx");
            }
            else
            {
                labWarm.Visible = true;
                labWarm.Text = "注册失败";
            }
        }
    }
}