VB.Net And MySQL Search - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul VB.Net And MySQL Search, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan
Artikel database,
Artikel How To Search Data In MySQL DataBase Using Visual Basic .Net,
Artikel mysql,
Artikel mysql database,
Artikel search,
Artikel Search Data In MySQL DataBase Using VB.Net,
Artikel vb.net, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
Judul : VB.Net And MySQL Search
link : VB.Net And MySQL Search
Anda sekarang membaca artikel VB.Net And MySQL Search dengan alamat link https://dev-create.blogspot.com/2017/11/vbnet-and-mysql-search.html
Judul : VB.Net And MySQL Search
link : VB.Net And MySQL Search
VB.Net And MySQL Search
How To Search Data In MySQL Database Using VbNet
In This VB.Net Tutorial We Will See How To Get The ID From TextBox And Search In Database Data With This Specific ID And Display The Other Information From MySQL DataBase Table Using 2 Way (MySqlDataReader, MySqlDataAdapter + DataTable) In Visual Basic.Net Programming Language And Visual Studio Editor.
Project Source Code:
Imports MySql.Data.MySqlClient
Public Class Search_Data_In_MySQL
Dim connection As New MySqlConnection("datasource=localhost;port=3306;username=root;password=;database=s_t_d")
Private Sub ButtonSearch_Click(sender As Object, e As EventArgs) Handles ButtonSearch.Click
' using dataReader
'Dim command As New MySqlCommand("SELECT * FROM `student` WHERE `Id` = @id", connection)
'command.Parameters.Add("@id", MySqlDbType.Int64).Value = TextBox1.Text
'Dim reader As MySqlDataReader
'connection.Open()
'reader = command.ExecuteReader()
'If reader.Read() Then
' TextBox2.Text = reader(1)
' TextBox3.Text = reader(2)
' DateTimePicker1.Value = reader(3)
'End If
'connection.Close()
'---------------------------------------
' using dataTable
Dim command As New MySqlCommand("SELECT * FROM `student` WHERE `Id` = @id", connection)
Command.Parameters.Add("@id", MySqlDbType.Int64).Value = TextBox1.Text
Dim adapter As New MySqlDataAdapter(command)
Dim table As New DataTable()
Try
adapter.Fill(table)
If table.Rows.Count > 0 Then
'TextBox1.Text = table(0)(0)
TextBox2.Text = table(0)(1)
TextBox3.Text = table(0)(2)
DateTimePicker1.Value = table(0)(3)
Else
TextBox2.Text = ""
TextBox3.Text = ""
DateTimePicker1.Value = Now()
End If
Catch ex As Exception
MessageBox.Show(ex.Message.ToString())
End Try
End Sub
End Class
///////////////OUTPUT:
Demikianlah Artikel VB.Net And MySQL Search
Sekianlah artikel VB.Net And MySQL Search kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel VB.Net And MySQL Search dengan alamat link https://dev-create.blogspot.com/2017/11/vbnet-and-mysql-search.html