report log in winforms

Question

0.00/5 (No votes)

See more:

, +

My lecturer said we should think about a report log that you use on a windows form.
basically what i am asking is if a user uses my winform that is connected to a database and they add, modify or delete from a database i could just have a button to show the "activity" if any in a text box or a .txt file. like a report log

i don't have code yet, if u can help me to get in right direction or an article or code will be helpful

Posted 26-Aug-12 7:14am

RuanSmit

Updated 26-Aug-12 7:27am

v2

Add a Solution

Comments

[no name] 26-Aug-12 13:34pm

You should try something and if you have any problem we are here.

I.explore.code 26-Aug-12 14:07pm

Try exploring the System.IO namespace its a goldmine of File I/O operations in .NET. Basically, what you want is after every operation i.e. Add, Update, Delete, a line that writes to a file the event, date and time.

1 solution

Add a Solution

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

Maciej Los · Answer 1 · 2012-08-26T11:11:00

Solution 1

In my opinion, you need to create an 'user-activity' database. It's simple to do, because it should at least have only one table, like this:

ActivityID - INT (IDENTITY)<br />
UserID - INT  -> user name, id or any other unique value<br />
DatabaseID -> database name, id or any other unique value<br />
TableId -> table name, id or any other unique value<br />
UserActivity - VARCHAR(255)  -> description of user activity<br />
ActivityTime - DateTime<br />

The number of tables or fields depends on your criteria.

Before you save data, save user 'activity'.

Posted 26-Aug-12 11:11am

Maciej Los

Comments

Swinkaran 26-Aug-12 20:42pm

This is fine. May be you create a table in the database(with the fields mentioned by losmac.) and feed each user 'activity' to the database manually. For example, if a new record is added to the table then, Add a new row to the 'activity' table.

losmac, 'datetime' of the event should be there

Maciej Los 27-Aug-12 3:26am

I agree with you, it could be a table in the same database, but my practice "tell me": better way to achieve this is to create a separatly database, especially when you are an admin of many databases. ;)

report log in winforms

1 solution

Solution 1

Add your solution here

Preview 0

report log in winforms

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us