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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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 :)