How can we obtain the currency value from the database table

[ATC]

I have to get the price (currency) from a database table, but I can not assign double & Decimal variable to it, which define type I should use?

[Wendelius]

If you're using SQL Server use SqlDbType.Money or SqlDbType.SmallMoney.

The need to optimize rises from a bad design. My articles[^]

[ATC]

Unfortunately I had MS Access database instead, but when I used VB.net then I defined Decimal type is OK! Also I can not re-define the database differently, because other applications are still using them (VC++) Any new suggestion? Thank

[Wendelius]

Could you post the parts of the code that are not working. I don't quite see why decimal wouldn't work. Also are getting an exception. If so, what is it?

The need to optimize rises from a bad design. My articles[^]