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