下面是代码,不知哪出错了
if (txtEName.Text == ""){ MessageBox.Show("员工姓名不能为空"); }
else {boperate.getcom("insert into tb_employee(EID,EName,ESex,EDiploma,EDepartment,EPosition)"
+ "values('" + txtECode.Text.Trim() + "','" + txtEName .Text .Trim ()+ "','" +txtESex .Text .Trim () + "','" + txtDiploma.Text.Trim() + "','" +cboxDepartment.Text .Trim () + "','" + txtEPosition.Text.Trim() + "')");
frmEInfoManage_Load(sender, e); MessageBox.Show("员工信息添加成功!");
tsbtnSave.Enabled = false; }
public SqlConnection getcon()
{string M_str_sqlcon = "server=.;dataBase=db_crm;uid=sa;pwd=";
SqlConnection myCon = new SqlConnection(M_str_sqlcon);return myCon;}
public void getcom(String M_str_Sqlstr)
{SqlConnection sqlcon = this.getcon();sqlcon.Open();
SqlCommand sqlcom = new SqlCommand(M_str_Sqlstr, sqlcon);sqlcom.ExecuteNonQuery();
sqlcom.Dispose();sqlcon.Close();sqlcon.Dispose();
}
|