Thursday, March 20, 2014

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






No comments:

Post a Comment