?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 SMS;
using System.Data.SqlClient;

public partial class add_Student : System.Web.UI.Page
{
    SMS.OPDataBase OP = new OPDataBase();
    protected void Page_Load(object sender, EventArgs e)
    {  if (!IsPostBack )
    {
       
        SqlConnection conn = OP.sqlConnection();
        conn.Open();
        string sql = "select  ClassID ,Desn from Class";
     
        SqlDataReader dr = OP.getDataReader(sql);
        
       

       
      
        while (dr.Read() )
        {
            this.DropDownList1.Items.Add(new ListItem(dr["Desn"].ToString(), dr["ClassID"].ToString()));
           
        }
     
       
      }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        // 將下拉列表的對應值顯示在TextBox1中；

        this.TextBox11.Text = DropDownList1.SelectedValue.ToString();
    }
    protected void Button2_Click(object sender, EventArgs e)
        {
         
            this.TextBox2.Text = "";
            this.TextBox3.Text = "";
            this.TextBox4.Text = "";
            this.TextBox6.Text = "";
            this.TextBox7.Text = "";
            this.TextBox8.Text = "";
            this.TextBox9.Text = "";
            this.TextBox10.Text = "";
            this.TextBox11.Text = "";
            this.TextBox12.Text = "";
            
    }
   
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(OP.getConnection());
        conn.Open();
        //為對應字段賦值
        string  name,age,sex,classid,phone,address,nationality,political,nativeplace,desn,entrancedata;
                 name =TextBox7 .Text.Trim ();
                 age = TextBox9.Text.Trim();
                 classid = TextBox11 .Text .Trim ();
              
                 phone = TextBox3.Text.Trim();
                 address = TextBox8.Text.Trim();
                 nationality = TextBox4.Text.Trim();
                 political = TextBox10.Text.Trim();
                 nativeplace = TextBox6.Text.Trim();
                 desn = TextBox2.Text.Trim();
                 entrancedata = TextBox12.Text.Trim();
                 sex = RadioButtonList1.SelectedItem.Value ;
        //執(zhí)行Command 插入命令。
                string str = "insert into student (Name,Age,Sex,ClassID,Phone,Address,Nationality,Political,NativePlace,Desn,EntranceDate)values('" + name + "','" +
        age +"','"+sex +"','"+classid  +"','"+phone +"','"+
         address +"','"+nationality +"','"+political +"','"+nativeplace +"','"+desn +"','"+entrancedata +"')";
      SqlCommand cmd = new SqlCommand(str, conn);
      try
      {
          cmd.ExecuteNonQuery();
          Response.Write("<script> alert('成功！')</script>");
       
      }
      catch(Exception ex)
      {
          string a=ex.Message.ToString();
         TextBox2 . Text = a;
          //Response.Write("<script> alert('失??！'+)</script>");
      }

        
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Redirect("Index.aspx");
    }
}