C# oledb update executenonquery

AddWithValue " City" , city. End Using. The screenshot below displays the rows affected. Even if you use it you will not throw any error but the Rows Affected will be negative i. The screenshot below displays the rows affected returned Related Articles. Add Comments.

Thank you for the feedback. The comment is now awaiting moderation. You will be notified via email when the author replies to your comment. Please select a comment to reply. You can add your comment about this article using the form below.

Make sure you provide a valid email address else you won't be notified when the author replies to your comment Please note that all comments are moderated and will be deleted if they are Not relavant to the article Spam Advertising campaigns or links to other sites Abusive content.

Please do not post code, scripts or snippets. Required Invalid Email Address. Although the ExecuteNonQuery returns no rows, any output parameters or return values mapped to parameters are populated with data.

For all other types of statements, the return value is If a rollback occurs, the return value is also Skip to main content. This browser is no longer supported. Download Microsoft Edge More info.

Are your project's settings using the expected db file? Yes Ive verified that as well, other functions that retrieve data from the database pull in the correct data. I havnt written a script for those, I dont need them for this particular project — MichaelTaylor3D. Have you verified that the columns specified by updateColumn and lookupColumn are always going to be of type Text or Memo?

Show 12 more comments. Active Oldest Votes. WriteLine connection. HansUp HansUp Well Im stumped I turned my computer off, took some time off and then got back on just now to hash it out and it works.

I dont think I changed anything. Im happy that its working now but it makes me feel uneasy that I dont know why it didnt work before, so I can prevent it in the future. The only thing I can think of is that something was locking the database in read only that didnt reactivate when I restarted my computer. Any thoughts on this? It returned the proper value as well — MichaelTaylor3D.

Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.