botton插入數據

 

private void Button2_Click(object sender, System.EventArgs e)
  {
    
   SqlConnection con=DBC.CreateDB();
   string cmdText=@"insert into Staff_Register(introducer_dept,introducer_name,introducer_indate,staff_identitycard,staff_name,staff_native,staff_sex,staff_birthday,staff_diploma,staff_skill,staff_rapport,staff_ismarry,staff_old_dept,staff_old_leavedate) values('"+introducer_dept.SelectedValue+"','"+introducer_name.Text+"','"+introducer_indate.Text+"','"+staff_identitycard.Text+ "','"+staff_name.Text+"','"+staff_native.SelectedValue+"','"+staff_sex.SelectedValue +"','"+staff_birthday.Text+"','"+staff_diploma.SelectedValue+"','"+staff_skill.SelectedValue+"','"+staff_rapport.SelectedValue+"','"+staff_ismarry.SelectedValue+"','"+staff_old_dept.Text+"','"+staff_old_leavedate.Text+"')";
   SqlCommand MyCommand=new SqlCommand(cmdText,con);
   con.Open();
   MyCommand.ExecuteNonQuery(); 
   con.Close();
   if(ValidationSummary1.Visible==true)
          
   {  
    Response.Write("<script>alert(/"登記成功/");</script>");
   }
            
   
  }