System.Data.SqlClient.SqlException: Error Converting Data Type Numeric To Decimal.

Hi There,





I'm using C# to get a value for a DOUBLE precision variable, called "Length", from a textBox using the following line:





Length = Convert.ToDouble( txtLength.Text )





I'm also using the following lines to prepare my stored procedure call:





arParms[9] = new SqlParameter("@Length", SqlDbType.Decimal, 5);


arParms[9].Value = record.Length;





My stored procedure has the following parameter definition:





@Length decimal(9,3)





My problem is that if someone types a value bigger than 999999 in the textbox he will get for sure the following error:





System.Data.SqlClient.SqlException: Error converting data type numeric to decimal.





I don't know how to either make sql or C# to truncate the value or catch the exception to automatically assign 0 to the parameter.





Please Help.


Moshe