private void cboSearchBy_SelectedIndexChanged(object sender, EventArgs e) { switch (cboSearchBy.Text) { case "BORROWE ID": oFilterBorrower = eVariable.FIND_BORROWER.BORROWER_ID; break; case "FIRST NAME": oFilterBorrower = eVariable.FIND_BORROWER.FIRST_NAME; break; case "MIDDLE NAME": oFilterBorrower = eVariable.FIND_BORROWER.MIDDLE_NAME; break; case "LAST NAME": oFilterBorrower = eVariable.FIND_BORROWER.LAST_NAME; break; default: oFilterBorrower = eVariable.FIND_BORROWER.FIRST_NAME; break; } }
public void LoadBorrower() { try { oBorrower = new DataAccess.Borrower(); dgExport.Rows.Clear(); oFilterBorrower = ePublicVariable.eVariable.FIND_BORROWER.FIRST_NAME; BorrowerStructure(); foreach (DataRow row in oBorrower.GetRecords(oFilterBorrower, "").Rows) { dgExport.Rows.Add(row["BORROWER_ID"], row["FIRST_NAME"], row["MIDDLE_NAME"], row["LAST_NAME"], row["DOB"], row["AGE"], row["CONTACT_NO"], row["ADDRESS"], row["STATUS"], row["PROFILE_PIC"]); } } catch (Exception ex) { } }