Solved

How to make log of Error messages in my application.

Posted on 2011-09-14
12
288 Views
Last Modified: 2012-05-12
Dear Experts, I have make application using vb.net 2005 and sqlserver 2008, I wan to make a log of all error messages in one of the table. how can i do this please suggest.
0
Comment
Question by:mahmood66
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 3
12 Comments
 
LVL 12

Expert Comment

by:viralypatel
ID: 36535426
Use Log4net ... this is a standard logging tool used in many organizations (at least those where I've already worked) ... and it is east to use and well documented.

Link - Log4net
0
 
LVL 17

Expert Comment

by:nepaluz
ID: 36535472
enclose your code in Try ...  Catch and log any errors trapped there to a log file,e.g
Try
   'your code here
Catch ex As Exception
    Dim LogFile = "C:\MyLog.txt"
       If Not File.Exists(LogFile) Then
           File.WriteAllText(LogFile, String.Join(", ", {TimeOfDay, ex.Message}) & VbCrLF)
       Else
           File.AppendAllText(LogFile, String.Join(", ", {TimeOfDay, ex.Message}) & VbCrLF)
       End If
End Try

Open in new window

0
 

Author Comment

by:mahmood66
ID: 36535909
thanx for support,  is there any way where i can make log  developer given  messages also where he used  MsgBox Command to display some of the message for the front end user.
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 17

Expert Comment

by:nepaluz
ID: 36535946
just call the MessageBox.Show() inside the try catch with the error message.
0
 

Author Comment

by:mahmood66
ID: 36542107
dear nepaluz: which file i must imports for this code.
and i am using vb.net not C#, so kindly give me code in vb.net syntax.
0
 
LVL 17

Accepted Solution

by:
nepaluz earned 500 total points
ID: 36542251
from my code above, you only have to add the MessageBox.Show(), e.g
Try
   'your code here
Catch ex As Exception
    Dim LogFile = "C:\MyLog.txt"
       If Not File.Exists(LogFile) Then
           File.WriteAllText(LogFile, String.Join(", ", {TimeOfDay, ex.Message}) & VbCrLF)
       Else
           File.AppendAllText(LogFile, String.Join(", ", {TimeOfDay, ex.Message}) & VbCrLF)
       End If
       MessageBox.Show(ex.Message.ToString)
End Try

Open in new window

0
 

Author Comment

by:mahmood66
ID: 36555455
done, I am testing it, i will confirm you back.
0
 

Author Comment

by:mahmood66
ID: 36572824
I've requested that this question be closed as follows:

Accepted answer: 0 points for mahmood66's comment http:/Q_27307247.html#36555455
Assisted answer: 500 points for nepaluz's comment http:/Q_27307247.html#36542251

for the following reason:

its done.
0
 

Author Comment

by:mahmood66
ID: 36572825
I wan to make log in the SQL table and your solution is creatign it in the Text file
0
 

Author Comment

by:mahmood66
ID: 36572833
I've requested that this question be closed as follows:

Accepted answer: 0 points for mahmood66's comment http:/Q_27307247.html#36555455
Assisted answer: 250 points for nepaluz's comment http:/Q_27307247.html#36535472
Assisted answer: 250 points for nepaluz's comment http:/Q_27307247.html#36542251

for the following reason:

the log is creating but in Text file. I want to make it into SQL table. which now I will import it into sql. thanks anyway
0
 

Author Comment

by:mahmood66
ID: 36572834
I want to make log in the SQL table and your solution is creatign it in the Text file
0
 

Author Closing Comment

by:mahmood66
ID: 36572840
Thanks. log is creating now. I will import that text file into the SQL table now.

thanks anyway
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question