convert string to currency
I'm taking user input from a form and putting the info in a database. One of the fields in the database has the datatype of money. The entered value in the form comes out as string. How can I convert this entered value into the matching currency (money) value to put into my sqlserver 2000 database?
I've tried to convert it to decimal and I get an error stating that input wasn't the expected format (when using Convert.Decimal()).
I've tried to use String.Format() but I get the same error.
Any help is appreciated.
Thanks

