Part III: Update and Delete Specific Data in MySQL Database using Visual Basic.Net

In this lesson we will focus on completing the user CRUD tutorial or the Create, Read, Update and Delete user. So to start with, Open our last tutorial called "Part II: Inserting and Reading of Data in MySQL Database Using Visual Basic.Net" and select the Manage User form and add two buttons in it. The first button we will name it as “btnupdate” and the text of this button we be “Update User”, and the other button we name it as “btnDelete” as the text will be “Delete User”. The form now will look same as shown below. Next we’re going to add functionality in Update Button. But first we need to make sure that, what we’re going to update is the specific data that has been selected by the user. Meaning the process to do this action is that the first will load all the data into the datagridview that has been saved to the database by clicking the “Read User”. And when the user clicks the specific data in the datagridview, it will show in the textbox that correspond to its value. And one of the most important one, is that we need to add another label that will hold later the value of Id Number of specific data that has been selected by the user. The code will be based on the “datagridview cell Mouse Click”. To do this just simply add another label and Name it as “lblid” and make it Invisible to the user by setting the “visible” property into “false”. So that when we run the program this will not be visible to the user. I think this time we are ready to add functionality to our “btnupdate” button. To do this just double click the “ btnupdate” button and add this code. And after this we can now test if this code works same as we expected. By running the program and clicking the “Read User” button. And clicking the specific data in the datagridview and changing the data based on what we wanted. For the “btnDelete” we can just simply copy the code in the “btnupdate” and only the difference is the query, so we can write it like this.