Convert to double

[ruca]

Hi people,

I can I format this expression into a double of two places:

<ItemTemplate>
<asp:Label runat="server" text='<%#
((DataBinder.Eval(Container,"DataItem.Duracao"))*24).ToString()%>' />
</ItemTemplate>

 

[Martin Dechev]

Hi, ruca,

Have a look at:

http://msdn.microsoft.com/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp

For your case I think

..ToString("#####.00")

should work.

Possible problems:

1. (I'm not sure if it is a problem in VB.NET, but it is in C#) When
multiplying by 24 (this literal is treated as System.Int32 in C#) the result
will be System.Int32. Apart from that, I can only guess what will be the
type of DataBinder.Eval(Container,"DataItem.Duracao") on the late binding in
VB.NET. In C# it is object (no late binding) and you have to parse it (as I
don't think the cast will work) and you have to add the appropriate suffix
for the literal to be treated as the required type in order to get the
result of the multiplication to be the required type, i.e. System.Decimal.

2. It is way more performant to make this calculation inside your sql or at
least in the page class before the databinding thus having the data ready
for the presentation layer to only display it to the client.

Hope this helps
Martin