Admin/AddTeacher.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            if (DB.getDataTable("select UserName from Teachers where UserName='" + this.txtUserName.Text.Trim() + "'").Rows.Count > 0)
            {
                Label1.Text = "该账号已使用，请重新输入！";
                return;
            }
            else
            {
                Label1.Text = "";
                string sql = "insert into  Users(UserName, UserPassword, Email, Telephone, Sex, Lever, Course) " +
                             "values('" + txtUserName.Text.Trim() + "','" + txtPwd.Text.Trim() + "','" + txtEmail.Text.Trim() + "','" + txtPhone.Text.Trim() + "','" + DropDownList1.SelectedValue + "','" + DropDownList2.SelectedValue + "','"+txtCoure.Text.Trim()+"')";
                SqlConnection cn = DB.OpenConnection();
                SqlCommand cmd = new SqlCommand(sql, cn);
                cmd.ExecuteNonQuery();
                cn.Close();
                cn.Dispose();
                Common.ShowMessage(this.Page, "注册成功！", "", "Admin/Login.aspx");
            }

        }
        catch (Exception)
        {
            Common.ShowMessage(this.Page, "信息保存失败，请稍后重试。", "");
            return;
        }
    }
}