adminteacheradd.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 _Default : System.Web.UI.Page
{
    SqlConnection conn;
    protected void Page_Load(object sender, EventArgs e)
    {
      string myconn=System .Configuration .ConfigurationManager .AppSettings ["ConnectionString"];
      conn = new SqlConnection(myconn );
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        string sql = "insert into Teacher(teaID,teaName,teasex,teaDepart,teazc,teaphone,teaaddress,teaPwd,tearemark) values('"+teaid.Text +"','"+teaname.Text +"','"+teasex.SelectedValue.ToString ()+"','"+ddldepart .SelectedValue .ToString ()+"','"+teazc.SelectedValue .ToString ()+"','"+teaphone.Text +"','"+teaaddress .Text +"','"+teapwd .Text +"','"+tearemark .Text +"')";
        SqlCommand insertCmd = new SqlCommand(sql, conn);
        
        try
        {
            conn.Open();
            int flag = insertCmd.ExecuteNonQuery();
            if (flag > 0)
            {
                lblMessage.Text = "成功添加教师信息！";
                
            }
            else
                lblMessage.Text = "添加教师信息失败，查看输入是否正确！";
        }
        catch (System.Exception ee)
        {
            Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
        }
        finally
        {
            conn.Close();
        }
       
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        teaid.Text = string.Empty;
        teaname.Text = string.Empty;
        teaphone.Text = string.Empty;
        teaaddress.Text = string.Empty;
        teapwd.Text = string.Empty;
        tearemark.Text = string.Empty;
        teaid.Focus();
        lblMessage.Text = string.Empty;
    }
}