CODEWITHSUNDEEP
asp.net
PassionateDeveloper
PassionateDeveloper

Reputation: 15138

ASP.Net: Eval Format for money expressions

how I can format my database-query in a list view with 2 signs after comma?

Now: 100 Should be: 100,00

Now: 75,3 Should be: 75,30

How I get it when I insert the data in the list view with Eval(xxx)?

Upvotes: 16

Views: 43687

Answers (2)

Colin Pickard
Colin Pickard

Reputation: 46663

this will give you the exact format you are looking for:

<%# Eval("currency", "{0:0,00}") %>

or this will give you the amount in the local currency (based on the webserver's locale).

<%# Eval("currency", "{0:c}") %>

Upvotes: 16

pmarflee
pmarflee

Reputation: 3428

<%# Eval("myField", "{0:c}") %>

will format the value using the locale-specific currency settings.

Upvotes: 47

Related Questions