teacheradd.aspx.cs

学生选课管理系统 谁想要的找我qq564633432

using System;
using System.Data;
using System.Data.SqlClient;
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 teacheradd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["userName"] == null)//如果没有登录，转向登录界面
        {
            Response.Redirect("Login.aspx");
        }
    }
    protected void imgBtnAdd_Click(object sender, ImageClickEventArgs e)
    {
        string Teaid = txtID.Text.ToString().Trim();
        string Name = txtName.Text.ToString().Trim();
        string Pwd = txtPwd.Text.ToString();
        string Depart = ddlDepart.SelectedValue;
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["web"]);
        try
        {
            string sqlstr = "insert into Teacher(Teaid, Name, Pwd, Depart) values('" + Teaid + "','" + Name + "','" + Pwd + "', '" + Depart + "')";
            SqlCommand comm = new SqlCommand(sqlstr, conn);
            conn.Open();
            comm.ExecuteNonQuery();
            comm.Dispose();
            lblMessage.Text = "添加成功";
            conn.Close();
            txtID.Text = "";
            txtName.Text = "";
        }
        catch (Exception ee)
        {
            Response.Write(ee.Message.ToString());
        }


            

    }
    protected void imgBtnReset_Click(object sender, ImageClickEventArgs e)
    {
        txtID.Text = "";
        txtName.Text = "";
    }
}