protected override object GetDataFromDataRow(DataTable dt, int i) { NGUOIDUNG obj = new NGUOIDUNG(); obj.NGU_ID = int.Parse(dt.Rows[i]["NGU_ID"].ToString()); //some column return((object)obj); }
public void delete(NGUOIDUNG nguoidung) { SqlParameter[] prams = { MakeInParam("@NGU_ID", SqlDbType.Int, 4, nguoidung.NGU_ID) }; int errorcode = RunProc("usp_DeleteNGUOIDUNG", prams); if (errorcode > 0) { throw new Exception("Error"); } }
public void update(NGUOIDUNG nguoidung) { SqlParameter[] prams = { MakeInParam("@NGU_ID", SqlDbType.Int, 4, nguoidung.NGU_ID), MakeInParam("@NGU_Code", SqlDbType.NVarChar, 20, nguoidung.NGU_Code), MakeInParam("@NGU_Name", SqlDbType.NVarChar, 50, nguoidung.NGU_Name), MakeInParam("@NGU_UserName", SqlDbType.NVarChar, 50, nguoidung.NGU_UserName), MakeInParam("@NGU_Password", SqlDbType.NVarChar, 50, nguoidung.NGU_Password) }; int errorcode = RunProc("usp_UpdateNGUOIDUNG", prams); if (errorcode > 0) { throw new Exception("Error"); } }
public DataTable getByID_NGUOIDUNG(NGUOIDUNG nguoidung) { connect(); DataSet DS = new DataSet(); SqlParameter[] prams = { MakeInParam("@NGU_ID", SqlDbType.Int, 4, nguoidung.NGU_ID) }; int errorcode = RunProcDS("usp_SelectNGUOIDUNG", prams, out DS); if (errorcode > 0) { throw new Exception("Error!"); } return(DS.Tables[0]); }
public DataTable getNguoiDung_byUserName(NGUOIDUNG userName) { connect(); DataSet DS = new DataSet(); SqlParameter[] prams = { MakeInParam("@NGU_UserName", SqlDbType.NVarChar, 50, userName.NGU_UserName) }; int errorcode = RunProcDS("GetNguoiDung_ByUserName", prams, out DS); if (errorcode > 0) { throw new Exception("Error!"); } return(DS.Tables[0]); }