Create a log file in c#?

Question

0.00/5 (No votes)

See more:

:confused:I want to create a logfile so that all events caused by the user to store items on a database are recorded. For instance:

Total records created
Number of records deleted
Date Changes
User Name
Table id

Please help me to create this file in C#.

[edit]Subject, tidy and rephrase - OriginalGriff[/edit]

Posted 20-Nov-10 22:00pm

kimiya_63

Updated 20-Nov-10 22:09pm

OriginalGriff

v2

Add a Solution

Comments

Sandeep Mewara 21-Nov-10 4:02am

Wel, what kind of logging we are talking of here?
Text file? Event Viewer? 3rd party log support?

6 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2010-11-20T22:15:00

You need to decide what you are going to do with the database, and with the log file - if you are storing info on every action the user takes with the database, then the log file is quickly going to get bigger than the database itself!
You also need to decide why you are going to store this info - is it for an audit trail? Who is going to view it?
Additionally, where are you going to store the log? If it is on the users local machine, then you will have permissions issues, and log deletion issues. If it is on your server, then you have the problem of multiple user access, and a LOT of bandwidth use.
You may find the best thing to do is to add the log as a database table, or as a separate database.
Have a think, and look at Google - see what others have done.

Ed Guzman · Answer 2 · 2010-11-21T03:16:00

Because you did not specify what kind of user, I assume this is any user that changes the database entities.
In this case such log file already exists: it is called data log file :-)
Any database has it together with a data file. You don't need to re-invent a wheel.
If you are talking about an application user, then you have to decide what you want to log, write log procedure, and call it in the procedures which are involved in changing your database.
You must be more specific when you define the question.

Good luck.

Abhinav S · Answer 3 · 2010-11-21T05:56:00

Solution 3

Have a look at log4net - http://www.codeproject.com/KB/aspnet/log4net.aspx[^].

Posted 21-Nov-10 5:56am

Abhinav S

susindar_Siemens · Answer 4 · 2010-11-25T02:55:00

XML

You can use the Trace Switches that traces each and every action that performed in an application.To Trace that your action acquired in your application.
Use The Following Link --><a href="http://msdn.microsoft.com/en-us/library/system.diagnostics.trace(VS.71).aspx">a href="http://msdn.microsoft.com/en-us/library/system.diagnostics.trace(VS.</a>[<a href="http://msdn.microsoft.com/en-us/library/system.diagnostics.trace(VS.71).aspx" target="_blank" title="New Window">^</a>]

johannesnestler · Answer 5 · 2010-11-25T03:36:00

Solution 5

maybe your database has a build in logging feature? ;P

Posted 25-Nov-10 3:36am

johannesnestler

luisvaldez · Answer 6 · 2010-11-25T04:15:00

Solution 6

Yeap... the builtin logging feature sounds like the best idea to me too...

Posted 25-Nov-10 4:15am

luisvaldez