Advertisement
Rdx291

Untitled

May 25th, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. Sub panggildata()
  2. konek()
  3. DA = New OleDb.OleDbDataAdapter("SELECT * FROM tb_rayon", conn)
  4. DS = New DataSet
  5. DS.Clear()
  6. DA.Fill(DS, "tb_rayon")
  7. DataGridView1.DataSource = DS.Tables("tb_rayon")
  8. DataGridView1.Enabled = True
  9. End Sub
  10. Sub jalan()
  11. Dim objcmd As New System.Data.OleDb.OleDbCommand
  12. Call konek()
  13. objcmd.Connection = conn
  14. objcmd.CommandType = CommandType.Text
  15. objcmd.CommandText = sqlnya
  16. objcmd.ExecuteNonQuery()
  17. objcmd.Dispose()
  18. TextBox1.Text = ""
  19. TextBox2.Text = ""
  20. TextBox3.Text = ""
  21. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement