Re: Money type - how to format money type in databind

You can add a format specifier:

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

Thanks a million Steve, U the king :) 

 

<%#DataBinder.Eval(Container.DataItem, "price",
"{0:c}")%>

I need to format the info retrieved from a column which uses the money type. 
All the retrieved values have 4 trailing 0's ie $100 is like $100.0000.  How do
i stop that.  I bing this data to webgrids and dropdownlists.

 

Regards

Shaun