strsql = "insert into book(bookid,classid,bookname,pron,author,publisher,abstract,price,discount,amount,isvalid) values('" & _bookid & "','" & _classid & "','" & _bookname & "','" & _pron & "','" & _author & "','" & _publisher & "','" & _abstract & "','" & _price & "','" & _discount & "','" & _amount & "','" & _isvalid & "')"
其中price为Money型,bookid和classid为decimal型
我在提交时报"不允许从数据类型 varchar 到数据类型 money 的隐性转换（表 'shopping.dbo.book'，列 'price'）.再就是报将数据类型 varchar 转换为 numeric 时出错。

没人回我自己回
问题是数值类型的不要单号
strsql = "insert into book(bookid,classid,bookname,pron,author,publisher,abstract,price,discount,amount,isvalid) values(" & _bookid & "," & _classid & ",'" & _bookname & "','" & _pron & "','" & _author & "','" & _publisher & "','" & _abstract & "'," & _price & "," & _discount & ",'" & _amount & "','" & _isvalid & "')"