In an Access table I have a field with type Number (Integer) and need to store an ASP.NET textbox value in it. I get a syntax error in the INSERT command when I use:

objCmd.Parameters.Add("@Level", FormatNumber(txtLevel.Text)) or any other conversion function I have tried

yet in another page the command

objCmd.Parameters.Add("@CostPerPerson", FormatCurrency(txtCostPerPerson.Text))

works fine.

How do I store a numeric text value as a database numeric value?