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.

I found the issue.

Thanks.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.