how to correct the error when odbc Exception was unhandled?

[dylan]

How to correct the error when odbc Exception was unhandled?

Private Function search(ByVal username As String) As Boolean
        ' Try
        Dim Sql As String
        Sql = "Select * from login where UserName='" & username & "'"
        Dim objdataAdapter As New OdbcDataAdapter(Sql, objconn)
        Dim objDataSet As New DataSet
        objdataAdapter.Fill(objDataSet, ("Login"))
        Dim objdataview As DataView
        objdataview = New DataView(objDataSet.Tables("Login"))
        If objdataview.Count > 0 Then
            Return True
        Else
            Return False
        End If
        'Catch ex As Exception
        '  MsgBox(ex.Message)
        ' End Try
    End Function
 
End Class

[PsychoCoder]

Why not start with giving more information about what's going wrong with the code you've provided

[Frinavale]

You have commented out the code that will handle the exception and display the message.

Could you please explain what error you are seeing? There are several different odbc exceptions.

It is good practice to only catch the exceptions that you can deal with.

-Frinny

[tsanalista]

Show Message Error brother....