C# Transaction Log

Question

I want to be able to log any transaction made to the dataset. So when a user insert, delete, or update etc.... I want to be able to log info.
My question is can someone point me in the right direction of taking the best of approach of designing a good transaction log. At the moment
I have creat a table in the dataset call transaction log. So when a user delete, insert or updates a specific row. I log it in the table.
Can someone point me to a great article of some sort

David Smith · Answer

1.What do you mean when you say write triggers? 2.What do you mean when the button event raises? Can you point me to an example of a tranaction log so that i can reference. What are the minimum fields you think I need in my transaction log data table?

Jiteendra Sampathirao · Answer

Hi Better to write the triggers when these insert delete or update happens.. And one more way is implement the functionality when insert update delete button events raises.