im trying to get the insert to work but the problem i am facing is i keep getting this error
Can someone help please
thanks in advance my code is
Dim strsql As String = "Insert into cg_security_user (user_name,user_pwd) values (@field1,@field2) "
Dim acscmd As New OleDb.OleDbCommand ' the oledbcommand
With objcmd
.Parameters.AddWithValue("@field1", txtuser.Text)
.Parameters.AddWithValue("@field2", txtpass.Text)
End With
objcmd.ExecuteNonQuery()
objcmd.Dispose()
MsgBox("Saved")