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>");
}
}