protected void Page_Load(object sender, EventArgs e) { try { mainDSTableAdapters.Dashboard_PBDTableAdapter disb = new mainDSTableAdapters.Dashboard_PBDTableAdapter(); mainDS.Dashboard_PBDDataTable tblDisb = disb.GetData(DateTime.Now.AddMonths(-1).ToShortDateString(), MySessionManager.CurrentUser.BranchID, 0, 0); string myfinalDT = "[['Category','Provision Amount'],"; for (int i = 0; i < tblDisb.Rows.Count; i++) { if (i == (tblDisb.Rows.Count - 1)) { myfinalDT += "['" + tblDisb[i].datCategory + "'," + tblDisb[i].provision + "]"; } else { myfinalDT += "['" + tblDisb[i].datCategory + "'," + tblDisb[i].provision + "],"; } } myfinalDT += "]"; this.data_debt.Value = myfinalDT; //this.data_debt1.Value = mailerman; } catch (Exception ex) { } try { mainDSTableAdapters.Dashboard_PBDTableAdapter disb1 = new mainDSTableAdapters.Dashboard_PBDTableAdapter(); mainDS.Dashboard_PBDDataTable tblDisb1 = disb1.GetData(DateTime.Now.AddDays(-1).ToShortDateString(), MySessionManager.CurrentUser.BranchID, 0, 0); string myfinalDT1 = "[['Category','Provision Amount'],"; for (int i = 0; i < tblDisb1.Rows.Count; i++) { if (i == (tblDisb1.Rows.Count - 1)) { myfinalDT1 += "['" + tblDisb1[i].datCategory + "'," + tblDisb1[i].provision + "]"; } else { myfinalDT1 += "['" + tblDisb1[i].datCategory + "'," + tblDisb1[i].provision + "],"; } } myfinalDT1 += "]"; this.data_debt1.Value = myfinalDT1; } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { try { mainDSTableAdapters.Dashboard_PBDTableAdapter disb = new mainDSTableAdapters.Dashboard_PBDTableAdapter(); mainDS.Dashboard_PBDDataTable tblDisb = disb.GetData(DateTime.Now.AddMonths(-1).ToShortDateString(), MySessionManager.CurrentUser.BranchID, 0, 0); string myfinalDT = "[['Category','Provision Amount'],"; for (int i = 0; i < tblDisb.Rows.Count; i++) { if (i == (tblDisb.Rows.Count - 1)) { myfinalDT += "['" + tblDisb[i].datCategory + "'," + tblDisb[i].provision + "]"; } else { myfinalDT += "['" + tblDisb[i].datCategory + "'," + tblDisb[i].provision + "],"; } } myfinalDT += "]"; this.data_debt.Value = myfinalDT; //this.data_debt1.Value = mailerman; } catch (Exception ex) { } try { mainDSTableAdapters.Dashboard_PBDTableAdapter disb1 = new mainDSTableAdapters.Dashboard_PBDTableAdapter(); mainDS.Dashboard_PBDDataTable tblDisb1 = disb1.GetData(DateTime.Now.AddDays(-1).ToShortDateString(), MySessionManager.CurrentUser.BranchID, 0, 0); string myfinalDT1 = "[['Category','Provision Amount'],"; for (int i = 0; i < tblDisb1.Rows.Count; i++) { if (i == (tblDisb1.Rows.Count - 1)) { myfinalDT1 += "['" + tblDisb1[i].datCategory + "'," + tblDisb1[i].provision + "]"; } else { myfinalDT1 += "['" + tblDisb1[i].datCategory + "'," + tblDisb1[i].provision + "],"; } } myfinalDT1 += "]"; this.data_debt1.Value = myfinalDT1; } catch (Exception ex) { } }