Performing calculations on data in gridview

[mrp9090]

Is it possible to perform calculations on data in your gridview in your ASP, or do you need to do any calculations in the OnRowDataBound event? Here is what I am trying to do :

<asp:TemplateField HeaderText="Target (%)" SortExpression="TargetPercentage">
<ItemTemplate>
<asp:Label ID="lblTargetPercentage" Text='<%# Eval("TargetPercentage")*100 %>' runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle Height="24px" Width="50px" />
</asp:TemplateField>

 

[ca8msm]

Yes you can do calculations in the GridView itself although I'd be more inclined to do them in the database for your above example.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[mrp9090]

How do you do them then, given that my example above doesn't work?

 

[ca8msm]

What "doesn't work"? Do you get any errors?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[mrp9090]

I get the error :

Operator '*' cannot be applied to operands of type 'object' and 'int'

 

[ca8msm]

Try converting your Eval("TargetPercentage") to an Integer


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[mrp9090]

I thought you couldn't do a data type conversion in the declaration of the gridview? I would be interested to know what the syntax is for doing this.

I've managed to get it working using this approach :

<asp:TemplateField HeaderText="Target (%)" SortExpression="TargetPercentage">
<ItemTemplate>
<asp:Label ID="lblTargetPercentage" Text='<%# String.Format("{0:###0.00}", GetAsPercentage(Eval("TargetPercentage"))) %>' runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle Height="24px" Width="50px" />
</asp:TemplateField>


protected double GetAsPercentage(object objTarget)
{
double dblTargetAsPercentage = Convert.ToDouble(objTarget) * 100;

return dblTargetAsPercentage;
}

 

[ca8msm]

The syntax would be eaxtly the same as your function call but with Cint. I still don't think it's a very "clean" method though and would do this calculation on the database and return it as a field.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[tperri]

What ca8msm means is do this.

SQL statement

select targetpercentage * 100 as MyPercentage
from blahblah

GridView code

<asp:Label ID="lblTargetPercentage" Text='<%# Eval("MyPercentage")*100 %>' runat="server"></asp:Label>

 

[jbenson001]

You wouldn't need to multiply by 100 again in the EVAL. Just use the sql that tperri suplied and display that result.

 

[tperri]

oops forgot to remove the *100 in the GridView code.

My Mistake.

<asp:Label ID="lblTargetPercentage" Text='<%# Eval("MyPercentage") %>' runat="server"></asp:Label>

 

[jbenson001]

No biggie.. Just didn't want the OP to get confused..