private void btnCollect_Click(object sender, EventArgs e) { DataTable dt = null; objHRdb = new HRInfo(); try { dt = objHRdb.EmployeeDeductionsDetails(dtpMonth.Value.ToString("MMMyyyy").ToUpper()).Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } gvEmpLoanDetails.Rows.Clear(); try { if (dt.Rows.Count > 0) { for (int iVar = 0; iVar < dt.Rows.Count; iVar++) { gvEmpLoanDetails.Rows.Add(); gvEmpLoanDetails.Rows[iVar].Cells["SLNO"].Value = (iVar + 1).ToString(); gvEmpLoanDetails.Rows[iVar].Cells["CompCode"].Value = dt.Rows[iVar]["ld_Comp_Code"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["BranchCode"].Value = dt.Rows[iVar]["ld_Bran_Code"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["Ecode"].Value = dt.Rows[iVar]["ld_eora_code"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["EmpName"].Value = dt.Rows[iVar]["ld_emp_name"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["Desig"].Value = dt.Rows[iVar]["ld_desig_name"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["Department"].Value = dt.Rows[iVar]["ld_dept_name"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["PersonalLoan"].Value = dt.Rows[iVar]["ld_Pers_Loan"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["ComputerLoan"].Value = dt.Rows[iVar]["ld_laptop_Loan"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["VehicleLoan"].Value = dt.Rows[iVar]["ld_veh_loan"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["SalaryAdvance"].Value = dt.Rows[iVar]["ld_sal_Adv"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["Other"].Value = dt.Rows[iVar]["ld_Other_dedu"].ToString(); gvEmpLoanDetails.Rows[iVar].Cells["Total"].Value = dt.Rows[iVar]["ld_tot_dedu"].ToString(); } foreach (DataGridViewRow oItem in gvEmpLoanDetails.Rows) { if (Convert.ToDouble(oItem.Cells["PersonalLoan"].Value.ToString()) == 0) { oItem.Cells["PersonalLoan"].Value = ""; } if (Convert.ToDouble(oItem.Cells["ComputerLoan"].Value.ToString()) == 0) { oItem.Cells["ComputerLoan"].Value = ""; } if (Convert.ToDouble(oItem.Cells["VehicleLoan"].Value.ToString()) == 0) { oItem.Cells["VehicleLoan"].Value = ""; } if (Convert.ToDouble(oItem.Cells["SalaryAdvance"].Value.ToString()) == 0) { oItem.Cells["SalaryAdvance"].Value = ""; } if (Convert.ToDouble(oItem.Cells["Other"].Value.ToString()) == 0) { oItem.Cells["Other"].Value = ""; } if (Convert.ToDouble(oItem.Cells["Total"].Value.ToString()) == 0) { oItem.Cells["Total"].Value = ""; } } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } calculateTotal(); }