Data Binding and formatting

[Chris]

Where can I find a fairly comprehensive list of the formatting codes used
when data binding. e.g. <%# Bind("Debit", "{0:C}") %>. Specifically
formatting a number to 2 decimal places. Regards, Chris.

 

[Winista]

use "{0:C2}" for 2 decimal places..

 

[Andrew Robinson]

Chris,

Eval and Bind both use string.Format(). Here is a good reference for that:

http://msdn2.microsoft.com/en-us/library/fht0f5be.aspx

 

[ReyN]

"{0:C2}" is for currency formats

when formatting a number to 2 decimal places, use

"{0:n2}"

http://authors.aspalliance.com/aspxtreme/aspnet/types/numericformatstrings.aspx

 

[Richard Carpenter]

use "{0:C2}" for 2 decimal places..

On a related note, what does the "0" in {0:C2} indicate? I've seen
references to {1:xx} as well, though I've never seen it implemented.

Rich

 

[chris]

Rich,

the 0 in {0:C2} is the placeholder for the variable you are formatting.

You could say:
double myMoney = 1;
double yourMoney = 2;
string foo = string.Format("My money is {0:C3}, and your money is
{1:C3}.", myMoney, yourMoney);

foo would be "My money is $1.000, and your money is $2.000.

Chris

 

[Richard Carpenter]

Rich,

the 0 in {0:C2} is the placeholder for the variable you are formatting.

You could say:
double myMoney = 1;
double yourMoney = 2;
string foo = string.Format("My money is {0:C3}, and your money is
{1:C3}.", myMoney, yourMoney);

foo would be "My money is $1.000, and your money is $2.000.

Thanks, chris. Out of curiosity, is that a known function from C or
something introduced with .Net? It looks familiar, but I don't recall
every encountering it in VB.

Rich

 

[chris]

Not Sure Rich.