syntax error in insert into statement with access 2003 in vb.net 2010

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ryan malaque
    New Member
    • Oct 2011
    • 1

    syntax error in insert into statement with access 2003 in vb.net 2010

    Why is it that when I'm trying to run my program i always see this error>>>> syntax error in insert into statement.....

    i declared everything

    in this function has an error:
    Code:
    if inc <>-1 then
    dim cb as new oledb.oledbcommandbuilder(da)
    dim dsnewrow as datarow
    
    dsnewrow=ds.tables("ryan").newrow()
    
    dsnewrow.item("ID")=textbox1.text
    dsnewrow.item("Password")=textbox2.text
    ds.tables("ryan").rows.add(dsnewrow)
    msgbox("data added!")
    anyone help plz!!!
    Last edited by Meetee; Oct 11 '11, 08:33 AM. Reason: code tags added
  • kadghar
    Recognized Expert Top Contributor
    • Apr 2007
    • 1302

    #2
    close the IF with END IF

    Comment

    Working...