Displaying Money on the gridview Problem

Question

Hi guys,

      Maybe someone here could help me, I'm trying to take a value from the my database in the SQL server and display it in a Gridview displayed with a currency format, I've tried inserting in the DataFormatString field  {0:c}, and it still doesn't work. I have a value of 2000 on my database but on the gridview it is displayed like this 2000.0000 instead of $2,000.00. The datatype of this culumn is defined as money.

  Thanks

Answer 1

Hi

Did you ever get a solution to this problem.
I seem to have the same problem.
Thanks if you can help

Answer 2

Hi bubbles,

Yes it was quite simple actually. You have to set your HTMLEncode on your gridview to false. At least it worked for me. like the example below:

 

<asp:boundfield datafield="CustomerName" headertext="Customer Name" htmlencode="false"/>

Answer 3

Hi
Thanks for your reply , but it doesn't work for me.
Think I'll scrap the currency field and use decimals.
Thanks again

Answer 4

Hi Bubbles

 

Just thought I would check with you that you are including the HtmlEncode="False" and DataFormatString="{0:c} in your code?

 

So for example:

<asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" HtmlEncode="False" DataFormatString="{0:c}" />

 

 

Answer 5

Thanks everybody for your help the HtmlEncode="False" and DataFormatString="{0:c}

Seems to have fixed the problem  Sorry Zorthgo I must have made a mistake when I first tried it