Data saved in database through oledbcommand problem

[vks.gautam1]

 cmd = New OleDbCommand("insert into userinfo(FirstName,LastName,UserName,Password,SequrityQuestion,Answer,Address) values(@FirstName,@LastName,@username,@password,@SequrityQuestion,@Answer,@Address)", cn)
            With cmd.Parameters
                .Add("@FirstName", OleDbType.VarChar).Value = Me.TxtFirstName.Text
                .Add("@LastName", OleDbType.VarChar).Value = Me.TxtLastName.Text
                .Add("@UserName", OleDbType.VarChar).Value = Me.TxtUserName.Text
                .Add("@Password", OleDbType.VarChar).Value = Me.TxtPassword.Text
                .Add("@SequrityQuestion", OleDbType.VarChar).Value = Me.DDLSequirityQuestion.SelectedItem.Text
                .Add("@Answer", OleDbType.VarChar).Value = Me.TxtAnswer.Text
                .Add("@Address", OleDbType.VarChar).Value = Me.TxtAddress.Text
            End With
            cmd.ExecuteNonQuery()
            MsgBox("Data Updated")

Error-Syntax Error INSERT Statement. Field name in insert query is correct.

 

[JohnH]

If you have table names that is same as reserved db words you have to espace them like this: [specialname]
VS data access wizards escapes all table names like this.

 

[vks.gautam1]

Userinfo =Table Name
i used select command

cmd = New OleDbCommand("select username,password from userinfo where username=@username and password=@password", cn)

in the other Page.. It works. I do not know which is reserved word in Insert query.

This all is in ASP.NET

 

[JohnH]

Column names, too, VS escapes everything.

 

[vks.gautam1]

i get it .
Changed the

UserName=User_Name
Password=Psw
Fieldnames of database & parameter names.

Thanks