VB.Net Delete MySQL Data - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul VB.Net Delete MySQL Data , kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan
Artikel database,
Artikel delete,
Artikel How To Delete Data From MySQL Database By ID in VB.Net,
Artikel How To Delete Data From MySQL Database Using Vb.Net,
Artikel mysql,
Artikel mysql database,
Artikel vb.net,
Artikel VB.Net Delete MySQL Data, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
Judul : VB.Net Delete MySQL Data
link : VB.Net Delete MySQL Data
Anda sekarang membaca artikel VB.Net Delete MySQL Data dengan alamat link https://dev-create.blogspot.com/2017/11/vbnet-delete-mysql-data.html
Judul : VB.Net Delete MySQL Data
link : VB.Net Delete MySQL Data
VB.Net Delete MySQL Data
How To Remove Data From MySQL Database Using VbNet
In This VB.Net Tutorial We Will See How To Delete The Selected Data From MySQL DataBase Table Using TextBox For The ID To Just Remove The Data With This Specific ID Using MySqlCommand With Parameters In Visual Basic.Net Programming Language And Visual Studio Editor.
Project Source Code:
Imports MySql.Data.MySqlClient
Public Class Delete_MySQL_Data
Dim connection As New MySqlConnection("datasource=localhost;port=3306;username=root;password=;database=s_t_d")
Private Sub ButtonDelete_Click(sender As Object, e As EventArgs) Handles ButtonDelete.Click
Dim command As New MySqlCommand("DELETE FROM `student` WHERE `Id` = @id", connection)
command.Parameters.Add("@id", MySqlDbType.Int64).Value = TextBox1.Text
connection.Open()
Try
If command.ExecuteNonQuery() = 1 Then
MessageBox.Show("Data Deleted")
Else
MessageBox.Show("Error")
End If
Catch ex As Exception
MessageBox.Show("Something Wrong")
End Try
connection.Close()
End Sub
End Class
///////////////OUTPUT:
Demikianlah Artikel VB.Net Delete MySQL Data
Sekianlah artikel VB.Net Delete MySQL Data kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel VB.Net Delete MySQL Data dengan alamat link https://dev-create.blogspot.com/2017/11/vbnet-delete-mysql-data.html