private void loadGrid()
{
core_petty_cash_reimbursement pcrObj = new core_petty_cash_reimbursement();
DataSet ds = pcrObj.SelectMethod(@"SELECT
pcr.Id_Petty_Cash_Reimbursement,
pcr.Id_Petty_Cash_Book,
pcb.Petty_Cash_Book_Name,
pcb.Petty_Cash_Book_Code,
pcb.Petty_Cash_Book_Max_Amount,
pcr.Amount_ThatShouldBe_Reimbursed,
pcr.Reimbursement_Amount,
pcr.Balance_Carried_Forward,
pcr.Petty_Cash_Reimbursement_Remark,
pcr.Created_Date,
pcr.Created_User,
pcr.Edited_Date,
pcr.Edited_User
FROM core_petty_cash_reimbursement AS pcr
INNER JOIN core_petty_cash_book AS pcb ON pcr.Id_Petty_Cash_Book=pcb.Id_Petty_Cash_Book
WHERE pcr.Is_Active='0' AND pcb.Is_Active='0';", "core_petty_cash_reimbursement");
if (ds.Tables["core_petty_cash_reimbursement"] != null)
{
pcrGrid.DataSource = ds.Tables["core_petty_cash_reimbursement"];
pcrGrid.DataBind();
}
else
{
pcrGrid.DataSource = new int[] { };
pcrGrid.DataBind();
}
}
