Guys, I found a solution at last. Thanks for all the replies. and specially Plater.
Amazingly, the fault in my program was to include a column name 'password'. When I changed it to 'pass' the whole program is working. I think the 'password' clashes with another attribute in the INSERT INTO command.
thanks to crow_w in http://www.daniweb.com/forums/thread173074.html
User Profile
Collapse
-
Hi Plater,
I'm happy about the quick response. I changed the item(1) into item("username" ) and item(2) into item("password" ). which are exactly correct as the database.
still no chance.Leave a comment:
-
Same Problem with me, Simple Scenario
Hi, I have the same problem. And my application is a quite simple log in box. I'm using Microsoft Visual Basic 2008 express edition.
The 'syntax error in INSERT INTO statement' apears at da.Update(ds, "table_schedule ") line. Please help me in this issue. Thank you in advance.
Code:Private Sub btnCrtUsrCreate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Leave a comment:
No activity results to display
Show More
Leave a comment: