Sub OnEvent(ByVal sender As Object, ByVal e As MonitorEventArgs)
If e.TracePoint = MonitorTracePoint.BeforeEvent Then
Console.WriteLine("Description: " & e.Description)
Console.WriteLine(" Extra info: " & e.ExtraInfo)
End If
End Sub
<MTAThread()> _
Sub Main()
Dim myConn As MySqlConnection = New MySqlConnection( _
"User Id=root;Host=localhost;Database=Test;")
Dim myMonitor As MySqlMonitor = New MySqlMonitor
AddHandler myMonitor.TraceEvent, AddressOf OnEvent
myMonitor.IsActive = True
Dim myCommand As MySqlCommand = New MySqlCommand("select count(*) from Test.Dept", myConn)
myConn.Open()
Console.WriteLine(myCommand.ExecuteScalar())
myConn.Close()
RemoveHandler myMonitor.TraceEvent, AddressOf OnEvent
Console.ReadLine()
End Sub