public int ModifyPwd(SysAdmin objAdmin) { //组合SQL语句 string sql = "update Admins set LoginPwd='{0}' where LoginId={1}"; sql = string.Format(sql, objAdmin.LoginPwd, objAdmin.LoginId); try { return(SQLHelper.Update(sql)); } catch (SqlException) { throw new Exception("应用程序和数据库连接出现问题!"); } catch (Exception ex) { throw ex; } }
public int DeleteStudentById(string studentId) { string sql = "delete from Students where StudentId=" + studentId; try { return(SQLHelper.Update(sql)); } catch (SqlException ex) { if (ex.Number == 547) { throw new Exception("this student object exists in other tables, can't delete it!"); } else { throw new Exception("Data base exception! information is: " + ex.Message); } } catch (Exception ex) { throw ex; } }