Advertisement
cong88

CRUD DatagridView

Feb 1st, 2015
234
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 2.47 KB | None | 0 0
  1. Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
  2.         Dim Constr As String
  3.         Constr = "server=localhost;" & "user=root;" & "password='';" & "database=sipdapeli;"
  4.         Dim sqlstr As String = "SELECT tb_perijinan.ID_PERUSAHAAN, tb_perijinan.JNS_PERIJINAN, tb_perijinan.NO_PERIJINAN, tb_perijinan.TGL_PERIJINAN FROM tb_perijinan WHERE tb_perijinan.ID_PERUSAHAAN = 003"
  5.         adapter = New MySqlDataAdapter
  6.  
  7.         Try
  8.             conn = New MySqlConnection(Constr)
  9.             conn.Open()
  10.             adapter.SelectCommand = New MySqlCommand(sqlstr, conn)
  11.             Dim cb As MySqlCommandBuilder
  12.             cb = New MySqlCommandBuilder(adapter)
  13.             adapter.Fill(ds, "tb_perijinan")
  14.             DataGridView1.DataSource = ds
  15.             DataGridView1.DataMember = "tb_perijinan"
  16.         Catch ex As Exception
  17.             MessageBox.Show(ex.Message)
  18.         End Try
  19.     End Sub
  20.  
  21.     Private Sub BtnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSimpan.Click
  22.         'Penambahan Data
  23.  
  24.         Dim dschange As DataSet = New DataSet
  25.         If (ds.HasChanges(DataRowState.Added)) Then
  26.             'Menambahkan Record Yang Ditambahkan
  27.             dschange = ds.GetChanges(DataRowState.Added)
  28.             Dim rowchange As Integer
  29.             rowchange = adapter.Update(dschange, "tb_perijinan")
  30.             If (rowchange > 0) Then
  31.                 MessageBox.Show(rowchange.ToString() & " Record Berhasil Dimasukan")
  32.             End If
  33.         End If
  34.  
  35.         'Pengubahan Data
  36.         If (ds.HasChanges(DataRowState.Modified)) Then
  37.             dschange = ds.GetChanges(DataRowState.Modified)
  38.             Dim Rowchange As Integer
  39.             Rowchange = adapter.Update(dschange, "tb_perijinan")
  40.             If (Rowchange > 0) Then
  41.                 MessageBox.Show(Rowchange.ToString() & " Record Berhasil diubah")
  42.             End If
  43.         End If
  44.  
  45.         'Penghapusan Data
  46.         If (ds.HasChanges(DataRowState.Deleted)) Then
  47.             dschange = ds.GetChanges(DataRowState.Deleted)
  48.             Dim Rowchange As Integer
  49.             Rowchange = adapter.Update(dschange, "tb_perijinan")
  50.             If (Rowchange > 0) Then
  51.                 MessageBox.Show(Rowchange.ToString() & " Record Berhasil dihapus")
  52.             End If
  53.         End If
  54.  
  55.         'Menerapkan perubahan
  56.         ds.AcceptChanges()
  57.  
  58.         'Refress Datagrid
  59.         DataGridView1.Refresh()
  60.     End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement