ok so i got my currency formatting working to where it doesnt store $'s and ,'s in the DB but dispays them in the output from the DB
BUT now.....
no its rounding them up and down.... it wasnt doin this at first.... it just suddenly changed.... it would truncate from 12.345 to 12.34 and stuff but now if you enter 12.34 it rounds to 12.00 and im witting here like ***???
heres the code for both columns
asp.net (1.1) Code:
<asp:Label ID=dcmPriceRange runat="server" Text='<%# String.Format("{0:$#,###,###.00}",(Convert.ToDouble(DataBinder.Eval(Container, "DataItem.dcmPriceRange"))))%>'> <asp:Label runat="server" ID="PriceRangeS" Text='<%# String.Format("{0:C2}",(Convert.ToDecimal(DataBinder.Eval(Container, "DataItem.dcmPriceRange")))) %>'>





Reply With Quote