How to handle errors by outputting to a log file?

[JenHu]

I have a vb.net application, which read the text file line by line and
write into SQL server tables. The text file contains the employees'
bank account number and all other information.

The way I handle the error is stopping process and send an error
message to the screen
Try .......
Catch err As Exception
MsgBox(err.Message)
End Try

However, that stops the process.

I want to output the error message and kick the whole line for this
employee out of the process and output into a log file, then the
process will continue until end of file.

Can someone give me an idea of how to?

Thank you.

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[Crouchie1998]

Dim strErrorFile As String = "C:\ErrorLog.log"

Private Sub LogError(ByVal sError As String, ByVal sFilename As String)
Dim sw As New IO.StreamWriter(sFilename, True)
sw.WriteLine(sError)
sw.Flush()
sw.Close()
End Sub

Try
' Do something
Catch ex As Exception
LogError(ex.ToString, strErrorFile)
End Try

or

Private Sub LogError(ByVal sError As String)
Dim sw As New IO.StreamWriter("C:\ErrorLog.log", True)
sw.WriteLine(sError)
sw.Flush()
sw.Close()
End Sub

with

Try
' Do something
Catch ex As Exception
LogError(ex.ToString)
End Try

I hope this helps

"JenHu" wrote:

I have a vb.net application, which read the text file line by line and
write into SQL server tables. The text file contains the employees'
bank account number and all other information.

The way I handle the error is stopping process and send an error
message to the screen
Try .......
Catch err As Exception
MsgBox(err.Message)
End Try

However, that stops the process.

I want to output the error message and kick the whole line for this
employee out of the process and output into a log file, then the
process will continue until end of file.

Can someone give me an idea of how to?

Thank you.

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[Herfried K. Wagner [MVP]]

"JenHu" <je**********@hotmail-dot-com.no-spam.invalid> schrieb:

I want to output the error message and kick the whole line for this
employee out of the process and output into a log file, then the
process will continue until end of file.

For more evolved solutions, take a look here:

Exception Management Application Block for .NET
<URL:http://msdn.microsoft.com/library/en-us/dnbda/html/emab-rm.asp>

log4net
<URL:http://logging.apache.org/log4net/>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Cor Ligthert]

Herfried,

For more evolved solutions, take a look here:

More than what?

Cor

[Herfried K. Wagner [MVP]]

"Cor Ligthert" <no************@planet.nl> schrieb:

For more evolved solutions, take a look here:

More than what?

More than a simple solution that can be implemented within a few minutes
;-).

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>