Automatically Update Values in Database from DataGridView Automatically Update Values in Database from DataGridView mysql mysql

Automatically Update Values in Database from DataGridView


c# mysql winforms

Please try this update query it works.

UPDATE mushrooms SET comment = @commentWHERE l_id=(select id from l where lot=@lot)

c# mysql winforms

Your update statement is incorrect. It should be:

"UPDATE m FROM mushrooms m JOIN lots l ON m.lot_id = l.id SET m.comment = @comment WHERE l.lot = @lot"

c# mysql winforms

Did you forget to execute the warenlagerMySqlDataAdapter.UpdateCommand?You are just setting the command and the parameters but not executing it.

What I see is that you are calling the update when the info is updated, but your update command is not loaded.You just call updateWarenlagerView when you update the row, but where are you calling initialzeFields?

Or am I missing code?

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last