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

    }
   
    //添加按鈕Click事件
    protected void imgBtnAdd_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);//創建連接對象
        SqlCommand insertCmd = new SqlCommand("insert into Student(stuID,stuPwd,stuName,stuDepart,stuGrade,stuClass) values(@stuID,@stuPwd,@stuName,@stuDepart,@stuGrade,@stuClass)", conn);
        insertCmd.Parameters.Add("@stuID", SqlDbType.VarChar, 15);//設置參數
        insertCmd.Parameters.Add("@stuPwd", SqlDbType.VarChar, 20);
        insertCmd.Parameters.Add("@stuName", SqlDbType.VarChar, 10);
        insertCmd.Parameters.Add("@stuDepart", SqlDbType.Int, 4);
        insertCmd.Parameters.Add("@stuGrade", SqlDbType.Int, 4);
        insertCmd.Parameters.Add("@stuClass", SqlDbType.Int, 4);
        insertCmd.Parameters["@stuID"].Value = txtID.Text; //為每個參數賦值
        insertCmd.Parameters["@stuPwd"].Value = txtID.Text;
        insertCmd.Parameters["@stuName"].Value = txtName.Text;
        insertCmd.Parameters["@stuDepart"].Value = int.Parse(ddlDepart.SelectedValue);
        insertCmd.Parameters["@stuGrade"].Value = int.Parse(ddlGrade.SelectedValue);
        insertCmd.Parameters["@stuClass"].Value = int.Parse(ddlClass.SelectedValue);
        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 imgBtnReset_Click(object sender, ImageClickEventArgs e)
    {
        txtID.Text = "";
        txtName.Text = "";
    }
}