M
Manuel Canas
Hello there,
This is my SQL Insert Statement to insert a single into a table on a
database;
INSERT tb_test VALUES(' & _
txtTest1.Text & "' " & _
txtTest2.Text & "' " & _
txtPrice.Text & "')"
Now when I execute this code against the data provider I got and error
saying that I should use the Convert Function on the column "Price", because
of course, the Price on the SQL MSDE is of money type.
I have tried this to try to convert from varchar to money, but no luck.
Dim us As New CultureInfo("en-US")
CType((txtPrice.Text), Decimal).ToString("c", us)
Anybody out there to guide me or give a hint on how to solve this issue?
Thanks very much for your help on this one.
Manny
This is my SQL Insert Statement to insert a single into a table on a
database;
INSERT tb_test VALUES(' & _
txtTest1.Text & "' " & _
txtTest2.Text & "' " & _
txtPrice.Text & "')"
Now when I execute this code against the data provider I got and error
saying that I should use the Convert Function on the column "Price", because
of course, the Price on the SQL MSDE is of money type.
I have tried this to try to convert from varchar to money, but no luck.
Dim us As New CultureInfo("en-US")
CType((txtPrice.Text), Decimal).ToString("c", us)
Anybody out there to guide me or give a hint on how to solve this issue?
Thanks very much for your help on this one.
Manny