Set decimal places in typed dataset?

[qwert231]

I have a typed dataset that gets filled from a SQL table with money datatype fields. When I bind to my text boxes I get 4 decimal places. What's the best way to show only 2 decimal places? Thanks.

 

[Isadore]

Dim MyPos As Double = 19.95
Dim MyString As String = MyPos.ToString("$#,##0.00;($#,##0.00);Zero&quot
...yields $19.95

Also, one might use the DataFormatString {0:C} for currency, for example, in a datagrid:

<asp:BoundColumn
HeaderText=&quot;Price&quot;
DataField=&quot;CurrencyValue&quot;
DataFormatString=&quot;{0:c}&quot;>
</asp:BoundColumn>

..and there are surely other paths one could take. For example, see the discussion at thread855-712598

Post back if any troubles, someone else may drop by and post something along these lines.

 

[qwert231]

Hmm... DataFormatString isn't available in a Text Box. Also, I don't want to have to run code on every value returned from the database.

 

[Isadore]

qwert: Good point - it seems, on first glance, that when the data is bound (e.g., if you are doing simple binding), you can format on binding...

...however, I am not familiar with using a Format string within a textbox - something tells me that it can be done; but the only examples I can find (not at home now, so no library in front of me) is to format on binding.

Good question though. I suspect you could use JavaScript to accomplish this. It'll be interesting to see how this works out.

 

[qwert231]

Hmm... I design time DataBind the textbox with a typed dataset, and I didn't notice before, but with VS 2k3 you have a drop down box that allows you to specify formatting. Thanks for the tips tho.