c# - Track the user that changed/updated a row in database table - sql server -

i need make column whenever user on network updates row through listview in asp.net web page, can find , store in column 1 row. have example of this?

one way this, use sql change tracking. take @ msdn sql change tracking

here excerpt describe change tracking capable of;

what rows have changed user table? fact row has changed required, not how many times row has changed or values of intermediate changes. latest data can obtained directly table being tracked. has row changed?b fact row has changed , information change must available , recorded @ time change made in same transaction.

to enable on sql server 2014 need run following snippet;

alter database adventureworks2012 set change_tracking = on (change_retention = 2 days, auto_cleanup = on)