MySQL VB.NET Tutorial 8 : Deleting selected data from database





Private Sub Button_Delete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
MysqlConn = New MySqlConnection
MysqlConn.ConnectionString =
"server=localhost;userid=root;password=root;database=database"
Dim READER As MySqlDataReader


Try
MysqlConn.Open()
Dim Query As String
Query ="Delete from database.edata where eid='" & TextBox_Eid.text &"'"
COMMAND = New MySqlCommand(Query, MysqlConn)
READER = COMMAND.ExecuteReader

MessageBox.Show("Data Deleted")
MysqlConn.Close()

Catch ex As MySqlException
MessageBox.Show(ex.Message)
Finally
MysqlConn.Dispose()

End Try
End Sub














----------------------------------------------------

mysql - How to delete data from database by using Visual Visual VB.NET 2010 2011 2012 2013 visual studio tutorial best beginners

Delete Data from MySQL Database using Visual VB.NET Windows Forms Application Visual basic

Delete one or more records from a database Visual basic VB.NET

Delete data from Database Visual basic VB.NET

Update and Delete data in database using Visual basic C#

Deleting Data from an SQL Table Visual basic VB.NET






Comments