Advertisement
PlajariKode

clsRuang - cari()

Nov 7th, 2019
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.39 KB | None | 0 0
  1.     Public Sub cari()
  2.         db.koneksi()
  3.         query = "SELECT * FROM ruang WHERE nama_ruang LIKE '%" & Form1.UcInventaris1.txtCariRuang.Text & "%'"
  4.  
  5.         Dim da As New SqlDataAdapter(query, db.konek)
  6.         Dim dt As New DataTable
  7.         da.Fill(dt)
  8.  
  9.         Form1.UcInventaris1.dgvRuang.DataSource = dt
  10.         Form1.UcInventaris1.dgvRuang.Columns(0).Visible = False
  11.     End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement