vb.net - Error Code 0x80040E14 update syntax error -
i trying update column in ms access 2007 database via vb.net express 2010. code causing error
0x80040e14 syntax error in update statement
i don't know had done mistake. please help me in finding problem.
here code.
dim ole new oledb.oledbconnection ole.connectionstring = "provider=microsoft.ace.oledb.12.0;data source=""c:\documents , settings\admin\my documents\visual studio 2010\projects\test\lm.accdb"";jet oledb:database password=9876543210;" dim reader new integer dim query new oledb.oledbcommand dim cmdupdate new oledb.oledbcommand dim querystring string seek ole.open() querystring = "update security set password = '" + maskedtextbox2.text + "' username = '"+ textbox1.text +"' " query.commandtext = querystring query.commandtype = commandtype.text query.connection = ole query.executenonquery() grab ex exception messagebox.show(ex.tostring()) ole.close() end seek
vb.net ms-access-2007
No comments:
Post a Comment