Advertisement
Guest User

Untitled

a guest
Jun 30th, 2017
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 1.70 KB | None | 0 0
  1. Public Function Login(ByVal username As String, ByVal password As String) As String
  2.             Dim role As String
  3.             If cnn.State = ConnectionState.Open Then
  4.                 cnn.Close()
  5.             End If
  6.             Try
  7.                 Dim strCom As String = "select Jabatan from tblUser where Username='" + username + "' and Password='" + password + "'"
  8.                 cnn.ConnectionString = CnnStr
  9.                 cnn.Open()
  10.                 Dim Comm As New OleDbCommand(strCom, cnn)
  11.                 Dim dr As OleDbDataReader = Comm.ExecuteReader
  12.                 If dr.Read Then
  13.                     role = dr(0).ToString
  14.                     Return role
  15.                 End If
  16.                 cnn.Close()
  17.  
  18.             Catch ex As Exception
  19.                 Return ex.ToString
  20.             Finally
  21.             End Try
  22.  
  23.         End Function
  24.  
  25.         Public Function getMenu(ByVal jabatan As String) As List(Of String)
  26.             Dim menu As List(Of String)
  27.             If cnn.State = ConnectionState.Open Then
  28.                 cnn.Close()
  29.             End If
  30.             Try
  31.                 Dim strCommand As String = "select Menu from tblJabatan where JabatanName='" + jabatan + "'"
  32.                 Dim Comm As New OleDbCommand(strCommand, cnn)
  33.                 Dim dr As OleDbDataReader = Comm.ExecuteReader
  34.                 cnn.ConnectionString = CnnStr
  35.                 cnn.Open()
  36.                 If dr.Read Then
  37.                     menu.Add(dr("Menu").ToString)
  38.                     Return menu
  39.                 End If
  40.                 cnn.Close()
  41.             Catch er As OleDb.OleDbException
  42.  
  43.  
  44.             Catch ex As Exception
  45.  
  46.             Finally
  47.             End Try
  48.         End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement