protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string lblPrGroup = e.Row.Cells[0].Text; TextBox txtQty = (TextBox)e.Row.FindControl("txtqty"); //total qty conv TextBox txtBoxQty = (TextBox)e.Row.FindControl("txtBox"); //box TextBox txtPcsQty = (TextBox)e.Row.FindControl("txtPcs"); //pcs qty TotalQtyConv += Convert.ToDecimal(txtQty.Text); // Total Box with Pcs BoxQty += Convert.ToDecimal(txtBoxQty.Text); PcsQty += Convert.ToDecimal(txtPcsQty.Text); if (Convert.ToDecimal(txtQty.Text) > Convert.ToDecimal(e.Row.Cells[9].Text)) { e.Row.BackColor = System.Drawing.Color.Tomato; } Crates += Convert.ToDecimal(e.Row.Cells[3].Text); ltr += Convert.ToDecimal(e.Row.Cells[8].Text); #region Pcs Billing Applicability DataTable dt = baseObj.GetPcsBillingApplicability(Session["SCHSTATE"].ToString(), lblPrGroup); string ProductGroupApplicable = string.Empty; if (dt.Rows.Count > 0) { ProductGroupApplicable = dt.Rows[0][1].ToString(); } if (ProductGroupApplicable == "Y") { txtPcsQty.Enabled = true; } else { txtPcsQty.Enabled = false; } #endregion } //if (e.Row.RowType == DataControlRowType.Footer) //{ // //e.Row.Cells[2].Text = "TOTAL :"; // //e.Row.Cells[2].HorizontalAlign = HorizontalAlign.Left; // //e.Row.Cells[2].ForeColor = System.Drawing.Color.MidnightBlue; // //e.Row.Cells[2].Font.Bold = true; // e.Row.Cells[3].Text = "Total:"+ Crates.ToString(); // e.Row.Cells[3].HorizontalAlign = HorizontalAlign.Left; // e.Row.Cells[3].ForeColor = System.Drawing.Color.MidnightBlue; // e.Row.Cells[3].Font.Bold = true; // e.Row.Cells[4].Text = "Total:" + BoxQty.ToString(); // e.Row.Cells[4].HorizontalAlign = HorizontalAlign.Right; // e.Row.Cells[4].ForeColor = System.Drawing.Color.MidnightBlue; // e.Row.Cells[4].Font.Bold = true; // e.Row.Cells[5].Text = "Total:" + PcsQty.ToString(); // e.Row.Cells[5].HorizontalAlign = HorizontalAlign.Right; // e.Row.Cells[5].ForeColor = System.Drawing.Color.MidnightBlue; // e.Row.Cells[5].Font.Bold = true; // e.Row.Cells[6].Text = "Total:" + TotalQtyConv.ToString(); // e.Row.Cells[6].HorizontalAlign = HorizontalAlign.Right; // e.Row.Cells[6].ForeColor = System.Drawing.Color.MidnightBlue; // e.Row.Cells[6].Font.Bold = true; // e.Row.Cells[8].Text = "Total:" + ltr.ToString(); // e.Row.Cells[8].HorizontalAlign = HorizontalAlign.Right; // e.Row.Cells[8].ForeColor = System.Drawing.Color.MidnightBlue; // e.Row.Cells[8].Font.Bold = true; //} }