• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 818
  • Last Modified:

formatting a decimal inside repeater

Hi,
I have the repeater below.

The value that InvoiceAmount is giving is:
512.33000 or whatever - it is a decimal.

I need to format it to 2 decimal place.

I have tried:
<%#DataBinder.Eval(Container.DataItem, "InvoiceAmount").ToString("#00.00")%>

but get:
 System.FormatException: Input string was not in a correct format.

What am I doing wrong?
<asp:Repeater ID="rptResults" runat="server" >                                       
                        <ItemTemplate>
                        <tr>
                            <td>                                
                                <%#DataBinder.Eval(Container.DataItem, "RegNumber")%>
                            </td>
                            <td>
                                <%#DataBinder.Eval(Container.DataItem, "SupplierOnInvoice.Name")%>
                            </td>
                            <td>
                                <%#DataBinder.Eval(Container.DataItem, "Payee.Name")%>
                           </td>                               
                           <td>
                                <%#DataBinder.Eval(Container.DataItem, "InvoiceAmount")%>
                           </td>                                                       
                            
                        </tr>            
                        </ItemTemplate>                            
                    </asp:Repeater>

Open in new window

0
scm0sml
Asked:
scm0sml
  • 3
2 Solutions
 
s_chilkuryCommented:
Change to:

<%#DataBinder.Eval(Container.DataItem, "InvoiceAmount", "{0:d}")%>
0
 
scm0smlAuthor Commented:
System.FormatException: Format specifier was invalid.

Source Error:


Line 187:                           </td>                              
Line 188:                           <td>
Line 189:                                <%#DataBinder.Eval(Container.DataItem, "InvoiceAmount", "{0:d}")%>
Line 190:                           </td>          
 
0
 
scm0smlAuthor Commented:
This works:
<%#DataBinder.Eval(Container.DataItem, "InvoiceAmount", "{0:F2}")%>

found it at it:
http://connect.microsoft.com/VisualStudio/feedback/details/324166/format-specifier-invalid-exception-introduced-by-net-2-0-sp1
0
 
scm0smlAuthor Commented:
Go the answer myself.

One answer was correct for an old framework so have given some points.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now