Last post Oct 11, 2011 08:16 PM by techman23
Oct 11, 2011 02:31 PM|techman23|LINK
I have designed a website using visual webdeveloper 2008 express along with vb code and sql server 2008 express for the backend database.
Its an online project using asp.net 3.5
I have a problem which is that there are three users who login to the website and work on the same database table adding,editing and deleting records.
How can i track which user edited,deleted and added a specific record at what date and time ?
Oct 11, 2011 04:06 PM|Primillo|LINK
You going to have to sql to store the event (delete, update, insert), store the user that fire that event.
Oct 11, 2011 04:17 PM|nitinpan|LINK
You can try the following steps:
1. Add two Columns
ModifyDate (DateTime) with default value GetDate()
2. Add the extra parameter to your INSERT and UPDATE operations for these fields
3. You can get the user name of the logged in user in an ASP.Net page using -
Oct 11, 2011 08:16 PM|techman23|LINK
thanks a lot man, you saved me a lot of reading and searching time, but i will implement it and surely get back to this thread for your assistance.