Manage Records - Keep History Of Changes

I am wanting to develop an application where there is a business requirement to keep a track of all changes made, so every time a record is edited, it is saved as a new record. So far, I have a Search form to list my Entities in a GridView. When I have identified the Entity I want to edit, I click on that record, and it takes me to a DetailsView form, with all fields of the record. Every record is identified as having an Entity key (ent_key), Sequence (seq_key) and Current key (cur_key). When I edit and save the Entity with say, ent_key =1000, seq_key =3, cur_key =1 and make any changes, then two things should happen:

1. the existing record (without edits) should be amended to be: ent_key =1000, seq_key =3, cur_key =0 (this 0 indicates that it is no longer current)

2. a new record including edits should be inserted to the database as having: ent_key =1000, seq_key =4, cur_key =1

The problems: In my DetailsView form, in Update mode I cannot update the seq_key, and when I use Insert mode, all the fields are blank so this is not helpful to the end user. (FYI - The data is stored in a SQL Server database, and I have set up a table adapter to retrieve the records. Am developing in C#)I would like to utilize stored procs where possible to resolve this issue. Would you experts please help me with some ideas (incl coding and examples if poss) to resolve this issue? Am reasonably new to this development, and I don't know what I don't know.