I am using vb.net 2003 with asp.net 1.1 and need to write some exception handing code. Could someone please tell me the correct order of the Try/Catch/Finally/End Try Block within the below code. I will need to use exception handing for many data connections and want to do this correctly. Thank-you very much for your assistance.
AdjConn = New OdbcConnection(System.Configuration.ConfigurationSettings.AppSettings("ConnectionString"))
reinsclientcode = "0"
Dim adjsql As String = "Select claims.code, claims.adjuster from claims where claims.code=""" & ClaimNo & """"
Dim adjcmd As New OdbcCommand(adjsql, AdjConn)
Dim adjReader As OdbcDataReader = adjcmd.ExecuteReader(CommandBehavior.CloseConnection)
Catch ex as Exception
If adjReader.HasRows Then
ClientCode = Trim(adjReader.Item(1)).ToString()