Trouble Converting Datatype For Database Insert

Hi,


I need to take a value from a textbox and insert it into a field in my database which takes decimals. My problem, no matter what I try I cannot convert the value so that the database will accept it. This all happens when the submit button is hit on my webpage. Here is the cmdSubmit_click sub code:





Dim surveyNum As Decimal = Decimal.Parse(txtSurveyNum.Text, Globalization.NumberStyles.Number)


myCmd.CommandText = "INSERT INTO survey(ID) VALUES('" & surveyNum & "')"


myCmd.Parameters.Add("surveyNum", SqlDbType.Decimal)


myCmd.Parameters("surveyNum").Value = System.Convert.ToDecimal(txtSurveyNum.Text)





myConn.Open()


Try


myCmd.ExecuteNonQuery()


lblMessage.Text = "Record successfully updated"


Catch


lblMessage.Text = "Query error: " & Err.Description


End Try


myConn.Close()





Thnx in advance, any help would be greatly appreciated.