casting sql datatypes

[LostProgrammer]

Anybody know how to cast sql money to a string or a decimal in vb.net? Need something like txt.Text =
cType(sqlDataReader(col_Number), decimal) or use a number format string like txt.Text.Format = "{0:c}"
Thanks for the help.

 

[rustyd]

txt.Text =Format(CDouble(sqlDataReader(col_Number),"$#,##0.00;($#,##0.00)"))

 

[rustyd]

Sorry, got the parenthesis in the wrong spot.

txt.Text =Format(CDouble(sqlDataReader(col_Number)),"$#,##0.00;($#,##0.00)")