money data type

hi,

please someone tell me how can i display the data type money correctly.

i have a textbox for keying tha amount of money and it also display the amount in other textbox. It always display with 4 decimal. how to solved this??:blush:

viv

what variable type are you using?

money data type in SQL server but i do not know how to convert it in VB.Net.

Thanks,
viv

problem solved, thanks guys.

viv:wave:

Hey, how about posting what you found to be the solution of your troubles.

It could help someone else out who may be in a similar jam.

Hi,

here is what i found to solved the problem:

Dim intTotal As Single

intTotal = CType(txt5.Text, Single) + CType(txt8.Text, Single)

Thanks guys
viv:wave:

why are u casting the variable from a single to a single?