How to populate a GridView column with current user on row delete

I’m having some trouble figuring this out. Hopefully someone on here can tell me what I’m doing wrong. I am trying to populate a “userName” column in a Gridview with the current logged in user when that user deletes a row. My end goal is to populate that “userName” column in a database with the user that deleted the row. I want to know who made a change and log that user in the “userName” column of the database table “userEntry”.

Here’s what I have. I created a sample database (sampleDB) and inside the database I created a simple table, “userEntry”. See sample db script below.

USE sampleDB;
GO

CREATE TABLE userEntry(
    id INT IDENTITY
    , someText VARCHAR(20)
    , userName VARCHAR(20)
    );
GO

INSERT INTO userEntry(someText, userName)
VALUES('Hello', 'John')
, ('Ohla', 'Sam');
GO

SELECT *
FROM userEntry;
GO

Next, I created a simple ASP.NET Web Application (.NET Framework) called “getUser1”. Then I added a GridView and a SQL connection string to link to the GridView to the database table. Here is the code I am using in the ASP.NET Web Application.

Default.aspx Page:

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="getUser1._Default" %>




   

       
                           
                              
               
               
               
               
                
                    
                        
                    
                
                
                
                
           
       

       
   

Default.aspx.cs Page:

using System;
using System.Web.UI;
using System.Security.Principal;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

namespace getUser1
{
    public partial class _Default : Page
    {
        

        public void Page_Load(object sender, EventArgs e)
        {
            
        }
        
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            // string strCurrentUser = WindowsIdentity.GetCurrent().Name;
            string strcurrentUser = WindowsIdentity.GetCurrent().Name;
            e.NewValues["userName"] = strcurrentUser;

        }

        //SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ConnectionString);

        protected void GridView1_RowDelete(object sender, GridViewDeleteEventArgs e)
        {
            //con.Open();
            //SqlCommand cmd = con.CreateCommand();
            //cmd.CommandType = CommandType.Text;
            //cmd.CommandText = "insert into userEntry VALUES('" + e.Values["id"] + "', '" + e.Values["someText"] + "', '" + WindowsIdentity.GetCurrent().Name + "')";
                //cmd.CommandText = "insert into userEntry.[userName] VALUES('" + WindowsIdentity.GetCurrent().Name + "')";
            //cmd.ExecuteNonQuery();
            //con.Close();

        }

        protected void GridView1_RowDeleted(object sender, GridViewDeleteEventArgs e)
        {
            
            //if (e.Values["userName"] != null)
            //{
            //    string strdeleteUser = WindowsIdentity.GetCurrent().Name;
            //    e.Values["userName"] = strdeleteUser;
            //}
            //else
            //{
            //    string strnewUser = WindowsIdentity.GetCurrent().Name;
            //    e.Values["userName"] = strnewUser;
            //}

        }        
    }
}

So, the sections that are commented out in the “Default.aspx.cs” page are some of the variants I have tried along with adding the "if (!IsPostBack)" section to the code behind for the "Default.aspx.cs" page. But it doesn't seem to be working. Obviously I have no idea how to get the current user name in the “userName” column when a GridView row is deleted by that user.

In short, when someone deletes a row, I need that current user name to populate the “userName” column on that row just before it deletes the row.

Is this even possible? I wonder because I can get this to work on the “edit” function but then, the delete function is not an edit function in regards to editing a row but it is an edit function in regards to the GridView.

Any help would be greatly appreciated. Thank you.