Dear All,
Good Morning!
I am facing this issue i tried a lot but not able to find the issue with this function when i call this function i get error
Argument not specified for parameter 'LVL' of 'Public Function UL(LVL As String) As String'
The code is listed below, if someone can help me on this i will be greatful.
Public Function UL(ByVal LVL As String) As String
Dim con As OracleConnection = New OracleConnection(My.Settings.ConnectionString)
Dim com As OracleCommand = Nothing
Dim userLevel As String = True
Try
con.Open()
com = New OracleCommand("SELECT LVL FROM Users WHERE Username = '" & Username & "'", con)
userLevel = com.ExecuteScalar
con.Close()
Catch Exp As OperationAbortedException
If con.State = ConnectionState.Open Then
con.Close()
userLevel = "Failed to retrieve permission level"
End If
End Try
Return userLevel
End Function
Thanks in Advance.
Have a good day.