Asp.net gridview multiple insert and update

See more:

C#

ASP.NET

In my Asp.net C# web form, I have many controls and Gridview to get input from user.

I have only one save button, it is used for Insert or Update(Sql Stored Procedure used for Insert/update).

I had add new row button for gridview to get 'n' number of rows as input.

I want Gridview in edit mode if it has rows, User can Update details, Add new row, delete row using delete button and it should be updated in table only if user click save button which is outside of Gridview.

What I have tried:

Now I can Insert or Update with gridview onRowCommand and Inbuild edit option, and user click save button it saves text box and other control values.

At present User Can Insert or Update or Delete in Gridview using Gridview in-build Edit/Delete option. In this case it reflects immediately in Table without using Save button, but I don't want this method.

How can I do gridview modification should reflect in table only after user click Save Button.