private void BindData() { DataTable dt = GetData(); if (dt.Rows.Count > 0) { SettlementGrid.DataSource = dt; SettlementGrid.Columns[0].FooterText = "Total"; SettlementGrid.Columns[1].FooterText = dt.Compute("SUM(iOCE)", "").ToString(); SettlementGrid.Columns[2].FooterText = dt.Compute("SUM(OCE)", "").ToString(); SettlementGrid.Columns[3].FooterText = dt.Compute("SUM(iICE)", "").ToString(); SettlementGrid.Columns[4].FooterText = dt.Compute("SUM(ICE)", "").ToString(); SettlementGrid.Columns[5].FooterText = dt.Compute("SUM(iORE)", "").ToString(); SettlementGrid.Columns[6].FooterText = dt.Compute("SUM(ORE)", "").ToString(); SettlementGrid.Columns[7].FooterText = dt.Compute("SUM(iIRE)", "").ToString(); SettlementGrid.Columns[8].FooterText = dt.Compute("SUM(IRE)", "").ToString(); SettlementGrid.Columns[9].FooterText = dt.Compute("SUM(OCEApr)", "").ToString(); SettlementGrid.Columns[10].FooterText = dt.Compute("SUM(ICEApr)", "").ToString(); SettlementGrid.Columns[11].FooterText = dt.Compute("SUM(Net)", "").ToString(); SettlementGrid.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { SettlementViewDiv.Style["height"] = sHeight; SettlementDB db = new SettlementDB(); DataTable dt; if (sECEType == 1) { dt = db.GetBranchSettlementRV(); } else { dt = db.GetBranchSettlementHV(); } //DataTable dt = db.GetBranchSettlement(sECEType); SettlementGrid.DataSource = dt; SettlementGrid.DataBind(); string HRV; if (sECEType > 1) { HRV = "HV"; SettlementGrid.RowStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#dee9fc"); } else { HRV = "RV"; SettlementGrid.RowStyle.BackColor = System.Drawing.Color.LightYellow; } LblTotal.Text = "Total -" + HRV; try { OCE.Text = dt.Compute("SUM(OCE)", "").ToString(); ICE.Text = dt.Compute("SUM(ICE)", "").ToString(); ORE.Text = dt.Compute("SUM(ORE)", "").ToString(); IRE.Text = dt.Compute("SUM(IRE)", "").ToString(); iOCE.Text = dt.Compute("SUM(iOCE)", "").ToString(); iICE.Text = dt.Compute("SUM(iICE)", "").ToString(); iORE.Text = dt.Compute("SUM(iORE)", "").ToString(); iIRE.Text = dt.Compute("SUM(iIRE)", "").ToString(); } catch { } //dt.Dispose(); SettlementGrid.Dispose(); }