private void PopulateApplyLoans()
        {
            LoanService loanService = new LoanService();
            DataView dtVw = loanService.GetApplyLoans(0, string.Empty);
            if (dtVw != null)
            {
                grdView1.DataSource = dtVw;
                grdView1.DataBind();

            }
        }
        private void PopulateApplyLoans()
        {
            string query = this.txtSearch.Text.Trim();
            LoanService loanService = new LoanService();
            DataView dtVw = loanService.GetApplyLoans(id, query);
            if (dtVw != null)
            {
                grdView1.DataSource = dtVw;
                grdView1.DataBind();

            }
        }