Please i need to display the money column in DataBase in an asp.net page but i get something like this 786.0000 how can i format it so that i get something like 786.00
Thanx
That kind of formatting is best done at the application level.|||You could use the ToString("c") to display as currency on your page.
Double TotalCost = 786.0000;
lblCost.Text = TotalCost.ToString("c");
Your label should now be set to $786.00
|||
If you are binding it, you can use <%# Bind("YourColumnName","{0:c}") %> and will display $786.00
If you dont want to display the currency, repace c with your own format like #0.00 at it should display 786.00
