How do i create log files in c# and store it in sql server.

See more:

C#

ASP.NET

SQL

Hello All,

Am building an application, there is a registration form where user enters the data and save it into the database. Well, there is a form field which is called Target Assigned, basically what it does is it assigns the targets to the particular name.

Example: SQL Table

Name  ||  Target Assigned
XYZ   ||  123
ABC   ||  235

Now, at certain times the user assigns a new targets to the particular name.

Name  ||  Target Assigned
XYZ   ||  124
ABC   ||  365

I can easily update the table using SQL commands but here i need a logic where i can save the old target value and name associated along with date and time and should be retrieved at any given point of time by the user.

Basically, it should show all the previously assigned targets with date and time.

Any suggestions, please?
Also, please throw a light on the LOG file creation.

Thanks
Saikrishna

What I have tried:

I have not tried anything since am lacking the logic to create.