TUTORIAL VB.NET (DATA KOTA)

DISUSUN OLEH,Nama: Yohanes Hariyanto SubektiNim: 1115070161Kelas: SI 13 JSM

Aktifkan server terlebih dahulu Pertama buka xampp, jalan kan module apace dan my sql Setelah itu buka browser, di ane pake opmin Ketikan localhost>>phpmyadmin>>test>>new>>buat database(disini ane nama dbnya katalog)

penampakannya seperti ini

setelah selesai buat data basenya, kita akan membuka vb.netnya Install terlebih dahulu mysql network connector, jika tidak ada bias download di mbah google Ketik new project>>windows forms application Klik kanan pada nama form yang kita buat yang berada di solution explorer(disini ane pake nama form kelompok_kota

Add reference>>.net>>mysql.data Setelah itu buat toolbox button 4 unit, textboxnya 4 dan label 4

Jadilah seperti ini

Di menu toolbox carilah datagridview Sesuaikan lebar dan ukurannya Bgini penampakannya

Setelah itu ketikan codingan seperti ini, agar bisa terkonek dengan data base yang kita buat tadi.Imports MySql.Data.MySqlClientPublic Class Form1 Dim MySqlConn As MySqlConnection Dim MySqladapter As MySqlDataAdapter Dim CMD As MySqlCommand

Private Property idkota As Integer

Private Sub konek() MySqlConn = New MySqlConnection() MySqlConn.ConnectionString = "server=localhost;" _ & "user id=root;" _ & "password=;" _ & "database=test" Try MySqlConn.Open() 'MessageBox.Show("koneksi ok") Catch myerror As MySqlException MessageBox.Show("Cannot connect to database: " & myerror.Message) End Try End Sub Private Sub view() Dim bSource As New BindingSource Dim dtData As New DataTable MySqladapter = New MySqlDataAdapter Try konek() CMD = New MySqlCommand("Select * from kota", MySqlConn) MySqladapter.SelectCommand = CMD MySqladapter.Fill(dtData) bSource.DataSource = dtData DataGridView1.DataSource = bSource MySqladapter.Update(dtData) Catch ex As MySqlException MessageBox.Show("Data Tidak Dapat Ditampilkan :" & ex.Message) End Try End Sub Public Function executequery(ByVal sql As String) Try konek() CMD = New MySqlCommand(sql, MySqlConn) CMD.ExecuteNonQuery() MySqlConn.Close() Return True Catch ex As MySqlException MessageBox.Show("data tidak dapat ditampilkan :" & ex.Message) Finally MySqlConn.Dispose() End Try Return False End Function

Setelah itu dibawah codingan diatas, tambahin codingan seperti ini,Sub viewRecord(ByVal i As Integer) If DataGridView1.Item(0, i).Value vbNull Then idkota = DataGridView1.Item(0, i).Value TxtNama.Text = DataGridView1.Item(1, i).Value.ToString() TxtProvinsi.Text = DataGridView1.Item(2, i).Value.ToString() TxtWalikota.Text = DataGridView1.Item(3, i).Value.ToString() TxtPenduduk.Text = DataGridView1.Item(4, i).Value.ToString() End If

End Sub

Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick Call viewRecord(e.RowIndex) End Sub

Private Sub DataGridView1_RowEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.RowEnter Call viewRecord(e.RowIndex) End Sub

Sub clearform() idkota = 0 TxtNama.Text = "" TxtProvinsi.Text = "" TxtWalikota.Text = "" TxtPenduduk.Text = "" End Sub Private Sub BtnNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnNew.Click

clearform() TxtNama.Focus()

End Sub Private Sub BtnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSave.Click Dim sql As String 'insert into kota values 9null,'nama','provinsi'/,'walikota','penduduk',4) sql = "insert into kota values (null,'" & TxtNama.Text & "','" & TxtProvinsi.Text & "','" & TxtWalikota.Text & "'," & TxtPenduduk.Text & ")" Dim res = executequery(sql) If res = True Then MessageBox.Show("save ok") Else MessageBox.Show("gagal save") End If Call view() Dim btn As Integer btn = MessageBox.Show("tambah data.?", "simpan data.?", MessageBoxButtons.YesNo) If btn = DialogResult.Yes Then BtnNew.Focus() Else clearform() End If End Sub Private Sub BtnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnDelete.Click Dim sql As String 'delete from kota where id=1 sql = "delete from kota where id=" & idkota.ToString() Dim res = executequery(sql) If res = True Then MessageBox.Show("delete ok") idkota = 0 Else MessageBox.Show("delete gagal") End If Call view() End Sub Private Sub BtnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnUpdate.Click Dim sql As String 'update kota set nama='susan', provinsi='banten', walikota='tangerang', penduduk='5', where id=1 sql = "update kota set nama='" & TxtNama.Text & "', walikota='" & TxtWalikota.Text & "', provinsi='" & TxtProvinsi.Text & "', penduduk='" & TxtPenduduk.Text & "' where id=" & idkota.ToString() Dim res = executequery(sql) If res = True Then MessageBox.Show("update sukses") idkota = 0 Else MessageBox.Show("update gagal") End If Call view() End Sub

Private Sub FORM_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Call view() End Sub

Private Sub FORM1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

Private Sub TxtNama_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtNama.GotFocus TxtNama.BackColor = Color.Blue End Sub

Private Sub TxtNama_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TxtNama.KeyPress If e.KeyChar = ChrW(Keys.Return) Then Me.TxtNama.Focus()

End If End Sub

Private Sub TxtNama_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtNama.LostFocus TxtNama.BackColor = Color.White

End Sub

Private Sub TxtNama_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TxtNama.TextChanged

End Sub

Private Sub TxtProvinsi_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtProvinsi.GotFocus TxtProvinsi.BackColor = Color.Blue End Sub

Private Sub TxtProvinsi_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TxtProvinsi.KeyPress If e.KeyChar = ChrW(Keys.Return) Then End If Me.TxtProvinsi.Focus() End Sub

Private Sub TxtProvinsi_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtProvinsi.LostFocus TxtProvinsi.BackColor = Color.White End Sub

Private Sub TxtWalikota_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtWalikota.GotFocus TxtWalikota.BackColor = Color.Blue End Sub

Private Sub TxtWalikota_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TxtWalikota.KeyPress If e.KeyChar = ChrW(Keys.Return) Then End If Me.TxtWalikota.Focus() End Sub

Private Sub TxtWalikota_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtWalikota.LostFocus TxtWalikota.BackColor = Color.White End Sub

Private Sub TxtPenduduk_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtPenduduk.GotFocus TxtPenduduk.BackColor = Color.Blue End Sub

Private Sub TxtPenduduk_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TxtPenduduk.KeyPress If e.KeyChar = ChrW(Keys.Return) Then End If Me.TxtPenduduk.Focus() End Sub

Private Sub TxtPenduduk_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtPenduduk.LostFocus TxtPenduduk.BackColor = Color.White End Sub

Private Sub TxtPenduduk_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TxtPenduduk.TextChanged

End SubEnd Class

Setelah itu, lihat hasilnya yang di bawah ini

BUTTON NEWBUTTON SAVEBEFORE

PROCESS

AFTER

BUTTON DELETEBEFORE

PROCESS

AFTER

BUTTON UPDATEBEFORE

PROCESS

AFTER

-------------------------------------sekian tutorial membuat data kota melalui vb.net------------------------------