add new row to gridview with totals

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Mike

    add new row to gridview with totals

    On my gridview I need to a add a new row that will have totals of a previous
    rows. It will be something like this


    row1 1 2 3 4 9 10
    11
    row2 5 6 7 8 12 13
    14
    Total Row cell[1] + cell[6] | cell[2] + cell[7] | cell[3] + cell[8]
    row4 15 16 17 18 19 20
    21


    and so one, Is this possible to accomplish and if so how would one do
    something like this?


  • Eliyahu Goldin

    #2
    Re: add new row to gridview with totals

    If you are with VS2008, use new ListView control that lets you use an item
    template. Make an item template out of 2 rows, one for the cells and another
    for the totals. In the ItemDataBound event calculate the totals and control
    the total row visibility.

    If you are with VS2005 or 2003, use a repeater.

    --
    Eliyahu Goldin,
    Software Developer
    Microsoft MVP [ASP.NET]




    "Mike" <Mike@aseagullp oopedonmyhead.c omwrote in message
    news:uDYza1IdIH A.3400@TK2MSFTN GP03.phx.gbl...
    On my gridview I need to a add a new row that will have totals of a
    previous rows. It will be something like this
    >
    >
    row1 1 2 3 4 9 10
    11
    row2 5 6 7 8 12 13
    14
    Total Row cell[1] + cell[6] | cell[2] + cell[7] | cell[3] +
    cell[8]
    row4 15 16 17 18 19 20
    21
    >
    >
    and so one, Is this possible to accomplish and if so how would one do
    something like this?
    >
    >

    Comment

    • Mike

      #3
      Re: add new row to gridview with totals

      I'm using 2005 and I have the app completed. The users decided to show a
      calculation field after the fact.
      There is no way in the gridview to get the cell values, calculate them, then
      add a new row with that total?


      "Eliyahu Goldin" <REMOVEALLCAPIT ALSeEgGoldDinN@ mMvVpPsS.orgwro te in
      message news:%23V2oj9Id IHA.5448@TK2MSF TNGP03.phx.gbl. ..
      If you are with VS2008, use new ListView control that lets you use an item
      template. Make an item template out of 2 rows, one for the cells and
      another for the totals. In the ItemDataBound event calculate the totals
      and control the total row visibility.
      >
      If you are with VS2005 or 2003, use a repeater.
      >
      --
      Eliyahu Goldin,
      Software Developer
      Microsoft MVP [ASP.NET]


      >
      >
      "Mike" <Mike@aseagullp oopedonmyhead.c omwrote in message
      news:uDYza1IdIH A.3400@TK2MSFTN GP03.phx.gbl...
      >On my gridview I need to a add a new row that will have totals of a
      >previous rows. It will be something like this
      >>
      >>
      >row1 1 2 3 4 9 10
      >11
      >row2 5 6 7 8 12 13
      >14
      >Total Row cell[1] + cell[6] | cell[2] + cell[7] | cell[3] +
      >cell[8]
      >row4 15 16 17 18 19 20
      >21
      >>
      >>
      >and so one, Is this possible to accomplish and if so how would one do
      >something like this?
      >>
      >>
      >
      >

      Comment

      • Mark Rae [MVP]

        #4
        Re: add new row to gridview with totals

        "Mike" <Mike@aseagullp oopedonmyhead.c omwrote in message
        news:ueaMq$IdIH A.484@TK2MSFTNG P06.phx.gbl...
        There is no way in the gridview to get the cell values, calculate them,
        then add a new row with that total?
        Fairly trivial:



        --
        Mark Rae
        ASP.NET MVP


        Comment

        Working...