Berikut Struktur penulisan dari try catch di VB .NET:
Try
' Do something in here that
' might raise an error.
Catch
' Handle exceptions that occur within
' the Try block, here.
Finally
' Perform cleanup code in here.
End Try
End Sub
Contoh penggunaan error handling:
Sub ReadTable()
Dim connection As SqlConnection
Try
connection = New SqlConnection("connection_string")
connection.Open()
Dim command As SqlCommand = connection.CreateCommand
command.CommandText = "SELECT NamaField FROM NamaTabel"
Dim reader As SqlDataReader = command.ExecuteReader
While reader.Read
'code menggunakan reader(0).ToString
End While
reader.Close()
command.Dispose()
Catch ex As Exception
'menampilkan error
MsgBox(ex.Message)
Finally
'code yang akan selalu dieksekusi
connection.Close()
End Try
End Sub
Dim connection As SqlConnection
Try
connection = New SqlConnection("connection_string")
connection.Open()
Dim command As SqlCommand = connection.CreateCommand
command.CommandText = "SELECT NamaField FROM NamaTabel"
Dim reader As SqlDataReader = command.ExecuteReader
While reader.Read
'code menggunakan reader(0).ToString
End While
reader.Close()
command.Dispose()
Catch ex As Exception
'menampilkan error
MsgBox(ex.Message)
Finally
'code yang akan selalu dieksekusi
connection.Close()
End Try
End Sub
Contoh lainnya adalah input/output error (IO), system memory error,
database error dan lain-lain yang memang memerlukan peng-handle-an khusus agar
error-error seperti ini tidak menyebabkan program kita ikut error. Sama seperti pemrograman yang lain, handling exception/error dalam C# bisa
digunakan TRY/CATCH. Kesimpulannya untuk menghindari error kita dapat menggunakan TRY dan CATCH.
Cukup sekian postingan dari saya tentang Exception Handling di Visual Basic .NET
Tidak ada komentar:
Posting Komentar