Grand Total For Each Column Based On RefNo[Answered] RSS

• • Reply
  Gopi.MCA

  Member

  293 Points

  676 Posts

  Grand Total For Each Column Based On RefNo

  Dec 05, 2019 10:39 AM|Gopi.MCA|LINK

  Hello

  This is my Gridview Data

  RefNo	Item	Color	Quantity	Rate	Percentage
  R1	I1	A	150	5	10
  R2	I1	B	200	5	10
  R3	I4	C	50	6	11
  R3	I4	D	50	7	20
  R3	I4	E	50	5	10
  		Total	400

  Column total should come based on Refno

  That is 150 + 200 +50  =400

  coz 50 three times but see only one Refno

  how to get column total

  Thanking You

• • Reply
  samwu

  Contributor

  3370 Points

  1409 Posts

  Re: Grand Total For Each Column Based On RefNo

  Dec 06, 2019 03:27 AM|samwu|LINK

  Hi Gopi.MCA,

  Gopi.MCA

  Column total should come based on Refno

  That is 150 + 200 +50  =400

  coz 50 three times but see only one Refno

  According to your description, i made demo for you. I compare the 2 adjacent values by traversing the GridView, and if they are not the same, let them add.

  The code:

   
   <asp:GridView ID="GridView1" runat="server" OnDataBound="GridView1_DataBound" ShowFooter="true"></asp:GridView>
  
  protected void Page_Load(object sender, EventArgs e)
          {
              if (!IsPostBack)
              {
                  DataTable dt = new DataTable();
                  dt.Columns.AddRange(new DataColumn[6] { new DataColumn("RefNo"), new DataColumn("Item"), new DataColumn("Color"), new DataColumn("Quantity"), new DataColumn("Rate"), new DataColumn("Percentage") });
                  dt.Rows.Add("R1", "I1", "A", 150, 5, 10);
                  dt.Rows.Add("R2", "I1", "B", 200, 5, 10);
                  dt.Rows.Add("R3", "I4", "C", 50, 6, 11);
                  dt.Rows.Add("R3", "I4", "D", 50, 7, 20);
                  dt.Rows.Add("R3", "I4", "E", 50, 5, 10);
                  GridView1.DataSource = dt;
                  GridView1.DataBind();
  
              }
          }
         
          protected void GridView1_DataBound(object sender, EventArgs e)
          {
              double sumqty = Convert.ToDouble(GridView1.Rows[0].Cells[3].Text);
              for (int rowIndex = 0; rowIndex < GridView1.Rows.Count - 1; rowIndex++)
              {
  
                  GridViewRow gvRow = GridView1.Rows[rowIndex];
                  GridViewRow gvPreviousRow = GridView1.Rows[rowIndex + 1];
  
                  if (gvRow.Cells[0].Text != gvPreviousRow.Cells[0].Text)
                  {
                      sumqty += Convert.ToDouble(GridView1.Rows[rowIndex + 1].Cells[3].Text);
                  }
                  GridView1.FooterRow.Cells[2].Text = "Total";
                  GridView1.FooterRow.Cells[3].Text = sumqty.ToString();
  
              }
  
          }

  The result:

  

  Best regards,

  Sam

  .NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.