How to display one of my column cell values in gridview footer on a label.

Question

0.00/5 (No votes)

See more:

This is the query I am using to populate my grid view:

C#

string str = string.Format(@"select m.pcode, m.fyyear, m.date, m.salary, m.ta, m.contigency, m.nrc, m.institcharges, m.others, p.total FROM monthly AS m inner join project p on p.pcode=m.pcode where m.pcode = '{0}'", DropDownList1.SelectedItem.Value.ToString());

What I would like is that the value from total column is displayed in grid view footer on a label.
The value of total column is same along every row so it does not matter which ever cell we choose plus I would like to hide this column from actually being displayed in grid view. I only need to extract the value from this column.

Which event should I use?

Posted 16-Jan-13 8:44am

a2ulthakur

Updated 16-Jan-13 8:50am

André Kraak

v3

Add a Solution

Comments

pryashrma 16-Jan-13 23:30pm

try using OnRowBound event

a2ulthakur 17-Jan-13 5:16am

i have to get value from column total to a label25. The label 25 is inside gridview footer column 9th

pryashrma 17-Jan-13 7:53am

please provide code

5 solutions

Solution 2

not sure............
study this...

<asp:gridview id="GridView1" onrowdatabound="RowDataBound_gv" />

protected void RowDataBound_gv(object sender, EventArgs e)
    {
        double total;
        foreach (GridViewRow gvr in gvPoDetails.Rows)
        {
            Label lblTot = (Label)gvr.Cells(9).Text;
            total+= double.Parse(lblTot.Text);
        }

        Label lblTotFooter = (Label)GridView1.FindControl("label25");
        lblTotFooter.Text=total.ToString();
    }

Posted 17-Jan-13 2:01am

pryashrma

Updated 17-Jan-13 17:06pm

v2

Solution 1

try this reference

http://www.agrinei.com/gridviewhelper/gridviewhelper_en.htm[^]

hope this help..

Posted 16-Jan-13 9:19am

chester_it21

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

solanki.net · Accepted Answer · 2013-01-17T17:15:00

HI , u should try like that

C#

protected void gvHardware_RowDataBound(object sender, GridViewRowEventArgs e)
  {
      int intFirstYearAmt;
      
      if (e.Row.RowType == DataControlRowType.DataRow)
      {

          intFirstYearAmt = Convert.ToInt32(((DataRowView)e.Row.DataItem)["ColumnName"].ToString());
// _intSumFisrtYear is global variable so declare as a global. 
          _intSumFisrtYear += intFirstYearAmt;

      }
      if (e.Row.RowType == DataControlRowType.Footer)
      {

          Label lbl2010 = (Label)e.Row.FindControl("lblFooterFirstYear");

          lbl2010.Text = _intSumFisrtYear.ToString();

          _intSumFisrtYear = 0;
      }
  }

I HOPE THIS WILL HELP U

solanki.net · Accepted Answer · 2013-01-17T17:46:00

Solution 4

your syntax is wrong

//total = Convert.ToInt32((DataRowView)e.Row.DataItem["total"].ToString());

Write like this

total = Convert.ToInt32(((DataRowView)e.Row.DataItem)["total"].ToString());

Posted 17-Jan-13 17:46pm

solanki.net

Comments

a2ulthakur 17-Jan-13 23:54pm

now its giving this error:

lblamount7.Text =total.ToString();// use of unassigned local variable 'total'

solanki.net 17-Jan-13 23:55pm

send your code

a2ulthakur 18-Jan-13 0:07am

the code behind part is this
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
int total;
if (e.Row.RowType == DataControlRowType.DataRow)
{
total = Convert.ToInt32((DataRowView)e.Row.DataItem["total"].ToString()); // its showing error in this line "cannot apply indexing with [] to an expression of type object.
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblamount7 = (Label)e.Row.FindControl("Label27");
lblamount7.Text =total.ToString();
}
}

this is the aspx of the hidden column
<asp:TemplateField HeaderText="Total Allocated" Visible="False">
<edititemtemplate>
<asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("total") %>'>

<itemtemplate>
<asp:Label ID="Label9" runat="server" Text='<%# Bind("total") %>'>

if u want i can email the whole page thanks for ur help!

solanki.net 18-Jan-13 0:27am

// I all ready told u use global variable .improve your logic
//Declare global variable int _sum=0;
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { int total=0; if (e.Row.RowType == DataControlRowType.DataRow) { total = Convert.ToInt32(((DataRowView)e.Row.DataItem)["total"].ToString()); // its showing error in this line "cannot apply indexing with [] to an expression of type object.
_sum +=total;
} if (e.Row.RowType == DataControlRowType.Footer) { Label lblamount7 = (Label)e.Row.FindControl("Label27"); lblamount7.Text =_sum.ToString(); } }

a2ulthakur 18-Jan-13 0:29am

i made it a global variable the page is running without errors but no value is being fetched :(

solanki.net 18-Jan-13 0:39am

Put the break point and check value is coming or not in total .

solanki.net 18-Jan-13 0:41am

and declare _sum as global
static int _sum=0

a2ulthakur 18-Jan-13 0:46am

ok i did put the breakpoints on and the total variable has the value of the column its just that its not displaying it. one more thing i need to ask my column from which i am trying to reterive value is a hidden template field and so i m trying to display value in another column called grand total in there i have inserted a label, will it be able to show my value there ?

a2ulthakur 18-Jan-13 0:48am

its working thanks, m sorry it was my little mistake :) i was giving the wrong label id thats it ! thanks a ton man :)

solanki.net 18-Jan-13 1:03am

your welcome

a2ulthakur · Accepted Answer · 2013-01-17T18:50:00

//declaring global variable
static int total=0;

// under gridview RowDataBound Event

C#

if (e.Row.RowType == DataControlRowType.DataRow)
        {

            total = Convert.ToInt32(((DataRowView)e.Row.DataItem)["total"].ToString());

        }

        if (e.Row.RowType == DataControlRowType.Footer)
        {
            Label Label27 = (Label)e.Row.FindControl("Label25");
            Label27.Text =total.ToString();
        }

this is what worked for me :)

How to display one of my column cell values in gridview footer on a label.

5 solutions

Solution 3

Solution 4

Solution 2

Solution 5

Solution 1

Add your solution here

Preview 0

How to display one of my column cell values in gridview footer on a label.

5 solutions

Solution 3

Solution 4

Solution 2

Solution 5

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us