Vb.Net Mysql: How To Create, Read, Update, Delete (Crud) - Part 3

To support you in understanding this topic, please read also these articles: How to connect VB.NET to MySQL database How to binding MySQL data to DataGridView How to binding MySQL data to ComboBox List I divide this topic into 4 parts. Make sure you have read the previous article. How to Create, Read, Update, Delete (CRUD) - Part 1 How to Create, Read, Update, Delete (CRUD) - Part 2 The next process is to delete a row. What users do for deleting is they choose a row to delete then click the Delete button. I also add a message for confirmation before the actual delete process. The code below is typed under tbrDelete_Click event. Private Sub tbrDelete_Click( ByVal sender As System.Object, _     ByVal e As System.EventArgs) Handles tbrDelete.Click     If MsgBox( "Yakin akan menghapus data?" , MsgBoxStyle.YesNo, _               "Konfirmasi" ) = MsgBoxResult.No Then Exit Sub     Dim myCommand As New MySqlCommand     conn = New MySqlConnection()     conn.ConnectionString = "server=localhost;user id=root;" & _                             "password=;database=database"     Try         conn.Open()         SQL = "DELETE FROM class WHERE classcode = " & _               "'" & grdData.CurrentRow.Cells(0).Value & "'"         myCommand.Connection = conn         myCommand.CommandText = SQL         myCommand.ExecuteNonQuery()         MsgBox( "Data terhapus" )         tbrCancel_Click( Nothing , Nothing )         conn.Close()     Catch myerror As MySqlException         MessageBox.Show( "Error: " & myerror.Message)     Finally         conn.Dispose()     End Try End Sub Last code to be added is under tbrClose_Click event. Its function is to close the form. Private Sub tbrClose_Click( ByVal sender As System.Object, _     ByVal e As System.EventArgs) Handles tbrClose.Click     Me .Close() End Sub All done with CRUD. Let's try to run. Get complete code here.
Sumber http://rani-irsan.blogspot.com