Syntax error in INSERT INTO statement

[zqtqzq]

I have the following code in my webform
I have define my connection to an access Database(Ocnn)
Created an adapter oDa

strIns="Insert Into myTB(UserID,Pswd) Values(@UserId,@Pswd)
oCmd=new oledbCommand(strIns,Ocnn)
oDa.InsertCommand=oCmd

with ocmd
.parameters.Add(new oledbParameter ("@UserID",oledbtype.cahr,50)

.parameters.Add(new oledbParameter ("@Pswd",oledbtype.cahr,50)

.parameters("@UserID").value=txtID.Text.Trim
.parameters("@Pswd").value=txtPW.Text.Trim
end with
ocmd.ExecuteNonquery(0

after running my web form i keep receiving the error
error in INSERT INTO Statement

some times after trying other methods of getting this done i also receive the error

Operation must use an updateable query

pls help

tunde aransiola

 

[chiph]

You've got several typographical errors in your code, for instance:

oledbtype.cahr

Do you have option explicit and option strict turned on?

Chip H.



____________________________________________________________________
Donate to Katrina relief:

http://s1.amazon.com/paypage/PELYGQVJ8Q7IB/103-6821258-5919825

If you want to get the best response to a question, please read FAQ222-2244 first

 

[mansii]

I'm not sure about this, but maybe you need to add some spaces.
Try changing

strIns="Insert Into myTB(UserID,Pswd) Values(@UserId,@Pswd)"

to

strIns="Insert Into myTB (UserID,Pswd) Values (@UserId,@Pswd)"

Regards

 

[ralphtrent]

the problem looks to be a missing ".
Take a look:

strIns="Insert Into myTB(UserID,Pswd) Values(@UserId,@Pswd)

You need the " at the end of this statement.

also you are missing a )
Take a look:

ocmd.ExecuteNonquery(0

 

[TipGiver]

I had once posted only one char: this -> " , meaning what ralp said, but somebody deleted my post. Anyway