How to convert data entered in textbox to money type in vb + sql server

lovecjy01

It still doesn't work. My database used access before, which is good. Later, after converting to sql server2000, this problem occurred.
I checked a lot of information and changed the money type to int or other data types.

caipei

First judge isnumeric and then ccur()

caipei

Do not use cdbl() but ccur()

wufuyi

I have been developing software that uses SQLServer as a database. Please use the method I gave you above. Many of my database fields are of the Money type. This type is very easy to use. It is the same as Numeric (18/4). , Pay attention to two points when inserting values ​​into the database: 1. Do not insert non-numeric characters into the position where the data type should be, 2. Do not insert values ​​that exceed the range. If the problem still occurs, please find out if it is correct When you insert it, the position is incorrect, and the character is inserted into the value. In fact, Money is a numeric type, and other errors are impossible. If it still can’t be solved, please paste the text on your error dialog box.