Brainegaiff
New Member
This what i have, I want to save a string from my asp.net page to a money type on the Sql server database. I had wrote:<BR><BR>CType(txtUSFunds.Text, Decimal)<BR><BR>and this is the error I get:<BR><BR>Disallowed implicit conversion from data type varchar to data type money, table '_PRfq.dbo.RFQMaster', column 'USFunds'. Use the CONVERT function to run this query.<BR><BR>Thankyou for your time.try converting your value to a dollar amount using the following then inserting into the DB.<BR><BR>dim a as string<BR>a = string.format("{0:c}",valuetoconvert)<BR><BR>a = $4.50<BR><BR>The only issue you may have a problem with is the dollar($) which you can remove using a function or the right() conversion.