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

lovecjy01

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

lava2411

cdbl (text1.text)

lionel

text1.text = Format (text1.text, "## 0.00")

justindx

Format (text1.text, "#, ## 0.00")

lovecjy01

Boss: No, report an error
Real-time error '-2147217913 (80040e07)'
Invisible conversion from data type varchar to data type money (.......) is not allowed, please use the convert function to run this query

wufuyi

First of all, you must make sure that the string entered in your text box can be converted into a value normally, and then directly substituted into the SQL statement according to the string.No conversion is required. When substituting, you can consider the following method:
drs.open "select * from table name where MoneyField="+cstr(val(text1.text)), yourcn

After two data conversions under VB, it is to convert the content in the text box into a string that can indeed be interpreted by SQL as Money

wufuyi

mcn.execute "insert into table name (Number,Name,Money) values ​​('00001','"+me.txtName.text+"',"+cstr(val(me.txtMoney.text))+")"

身材正

dim dec_Money as decimal=0
dec_Money=Cdec(trim$(txtMoney.text))

fenghui1231

First check whether it can be converted to a numeric type and then convert it. Maybe it is a null value and cannot be converted
if isnumeric(text1) then
....
end if

thetian

Convert the value first to format the money.