Error Converting nvarchar to numeric

Jul 29 2004 2:49 PM
I have a webform that submits data to a SQL db via a stored procedure. When I test the SP all works fine. When I use the form I get an error indicating that there is an error converting nvarchar to numeric. I only have three fields that submit to numeric: cmd.Parameters.Add(new SqlParameter("@Version", Version.Text)); cmd.Parameters.Add(new SqlParameter("@Build", Build.Text)); cmd.Parameters.Add(new SqlParameter("@Cost", Cost.Text)); The table fields are setup as follows: @Version [numeric] (9), @Build [numeric] (9), @Cost [numeric] (9), I have attempted to initiate a Convert on the fields to no avail: cmd.Parameters.Add(new SqlParameter("@Version", Convert.ToInt32(Version.Text))); cmd.Parameters.Add(new SqlParameter("@Build", Convert .ToInt32(Build.Text))); cmd.Parameters.Add(new SqlParameter("@Cost", Convert.ToInt32(Cost.Text))); Is there anyone who has any idea how I can get past this error? Thank you. Tim

Answers (2)