Monday, 15 September 2014

vb.net - Error Code 0x80040E14 update syntax error -



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