Advertisement
PlajariKode

clsRuang - ubah()

Nov 7th, 2019
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.58 KB | None | 0 0
  1.     Public Function ubah(nm_ruang As String, keterangan As String, id As Integer)
  2.         db.koneksi()
  3.         query = "UPDATE ruang SET nama_ruang = @nr, keterangan = @ket WHERE id_ruang = @id"
  4.         cmd = New SqlCommand(query, db.konek)
  5.  
  6.         cmd.Parameters.Add("@nr", SqlDbType.VarChar).Value = nm_ruang
  7.         cmd.Parameters.Add("@ket", SqlDbType.VarChar).Value = keterangan
  8.         cmd.Parameters.Add("@id", SqlDbType.Int).Value = id
  9.  
  10.         If cmd.ExecuteNonQuery Then
  11.             Return True
  12.         Else
  13.             Return False
  14.         End If
  15.     End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement