Cannot get data from my gridview

Question

I have problems to get the data of a particular cell in my gridview i'm doing it this way :

double total = 0;

for (int i = 0; i < GridFactures.Rows.Count; i++)
    total += Convert.ToDouble(GridFactures.Rows[i].Cells[6].Text.ToString());

lblTotalTTC.Text = "Montant total TTC : " + total;

The column in question is declared in my aspx file :

<asp:TemplateField HeaderText="Montant TTC">
    <ItemTemplate>
        <asp:Label ID="lblMontantTTC" runat="server" Text='<%#Eval("MontantTTC") %>'/>
    </ItemTemplate>
</asp:TemplateField>

i'm sure this is always the sixth column i want to check. i put a break and GridFactures.Rows[i].Cells[6].Text.ToString()always contains "" nothing more ... thanks for your help

Vano Maisuradze · Accepted Answer · 2012-05-10 18:09:43Z

1

Instead of this code:

for (int i = 0; i < GridFactures.Rows.Count; i++)
    total += Convert.ToDouble(GridFactures.Rows[i].Cells[6].Text.ToString());

Try this:

for (int i = 0; i < GridFactures.Rows.Count; i++)
{
    Control ctrl = GridFactures.Rows[i].Cells[6].FindControl("lblMontantTTC");
    if (ctrl != null)
    {
        Label lbl = ctrl as Label;
        if (lbl != null)
        {
            total += Convert.ToDouble(lbl.Text);
        }
    } 
}

answered May 10, 2012 at 18:09

Vano Maisuradze

5,9196 gold badges48 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Black Moose · Accepted Answer · 2012-05-10 15:10:30Z

0

If I'm not mistaken (and your label is the first/only control in the cell) -

You need to ask for the control at index 0, or find it by id, then ask for the .Text

Like so:

GridFactures.Rows[i].Cells[6].Controls[0].Text.ToString()

answered May 10, 2012 at 15:10

Black Moose

161 bronze badge

5 Comments

user1173169 Over a year ago

Unfortunately this is not working. I cannot manage to get any data from the gridview actually.

Black Moose Over a year ago

For testing purposes, try using the GridFactures.Rows[i].FindControl("lblMontantTTC") method and see if you can find it that way around.

user1173169 Over a year ago

thanks again but it's not working either... i don't understand

user1173169 Over a year ago

it displays { text = "40.01" } ( with a spy ) I need to get this value but i cannot get access to the Text Property for instance

user1173169 Over a year ago

WORKING WITH THIS : total = total + Convert.ToDouble(((System.Web.UI.WebControls.Label)(GridFactures.Rows[i].FindControl("lblMontantTTC"))).Text); thanks for your help

RhysW · Accepted Answer · 2012-05-10 14:48:51Z

0

remember it is a zero based index, so [6] means cell 7

answered May 10, 2012 at 14:48

RhysW

4531 gold badge4 silver badges16 bronze badges

1 Comment

RhysW Over a year ago

hehe a mistake that is made far too often just had to be sure ;)

BinBin · Accepted Answer · 2012-05-10 17:56:51Z

0

I know why. I just ran into the same situation myself. You need to check fields that are empty, if so, convert it to zero first.

   total += (GridFactures.Rows[i].Cells[6].Text == "")? 0d : Convert.ToDouble(GridFactures.Rows[i].Cells[6].Text.ToString());

answered May 10, 2012 at 17:56

BinBin

864 bronze badges

Comments

p.campbell · Accepted Answer · 2012-05-10 18:02:14Z

0

How about use LINQ instead of looping?

double mySum = 
        GridFactures.Rows
                    .Cast<GridViewRows>()
                    .Sum(row =>  
                Double.Parse(((Label)row.FindControl("lblMontantTTC")).Text));

If you're seeing no values, then your grid actually hasn't been databound yet, or ViewState is disabled on the grid. This all depends on where/when you're performing this calculation in the page lifecycle.

answered May 10, 2012 at 18:02

p.campbell

101k70 gold badges264 silver badges326 bronze badges

Collectives™ on Stack Overflow

Cannot get data from my gridview

5 Answers 5

Comments

5 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

5 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related