textbox content stored as database integer?

[WebEngineer]

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?

[matt-daly]

try this

objCmd.Parameters.Add("@Level", (int)txtLevel.Text)

alternatively you could convert it before you add it

string strLevel;
strLevel = (int) txtLevel.Text;

...

objCmd.Parameters.Add("@Level", strLevel)

[WebEngineer]

Thanks, Matt, but that does not work.

I cut out everything except the Level parameter and here is what my UPDATE looks like now:

strCmd = "Insert Into tblSponsors (Level) Values (@Level)"
Dim objCmd As New OleDbCommand(strCmd, objConn)
objCmd.Parameters.Add("@Level", int(txtLevel.Text))
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()

[danfran]

Does it work when you put in a literal value?

objCmd.Parameters.Add("@Level", 123)
or..
objCmd.Parameters.Add("@Level", "123")

Dan

[WebEngineer]

No, not with either, Dan

[WebEngineer]

OK, I found the problem and have solved it. I had to change the field name "Level" to something else. Apparently that is a reserved word.

Thanks to all who tried to help!

Dave