How To Insert Numbers From A Text Box To A Sql Database Table Column’s Type Numeric?

Hi,





I am getting an error when I try to insert a number typed in a text box control into a Sql database table column’s type numeric(6,2). For example: If I type 35,22 into the text box, or 35, and then I submit the form to insert the data into database, I get the follow error:





System.FormatException: Input string was not in a correct format.


Line 428: CmdInsert.Parameters.Add(New SqlParameter("@Measure", SqlDbType.decimal, "Measure"))





A piece of the SP inside Sql server:





USE market26


GO


ALTER PROC new_offer


@Offer_id bigint, @Measure numeric(6,2) = null, …





What is wrong? Why it doesn’ t accept the number typed in my text box?





Thank you,


Cesar