ASP.NET - Keep previous text and modify text with column name

Hello All,

I have a table like "tblEmp" and in my table i have some column like "Id","Name"

let inser some data in my table as 1, "Ashok"
If any user change this records as 1,"Ashok Kumar" in place of "Ashok"

So finally we have to show data as -

Column Name- [Name] "Ashok" chnaged from "Ashok Kumar" with modifiedby


So how we show ColumnName, previous Text and ModifyText?

Please suggest?

Most developers would create a tblEmpHistory and make a complete copy of the record each time a change occurs.  Often times, this is done with an INSERT or UPDATE trigger.