How can I put "updated by" and "date updated" in three different milestone columns of a GridView when they are updated

I've got a GridView with columns for entering the Date of three different "milestones" of customers. (It colors the background of the date cell if the cell is empty AND has passed a calculated date, but that's not relevant to my question)

For each of the three milestones there is a column for "* Date", "* Updated Date", and "* Updated By" with corresponding columns in the database.

How would I update the appropriate "* Updated Date" and "* Updated BY" columns in the database when one of the milestone dates are entered in the GridView.

Desired Process: User clicks "Edit" on the row for a customer and enters a date into one of the three milestones and then clicks "Update." Done. GridView displays the new date, and the staff's login name and today's date.

I have a sub in the VB below, called ESUpdatedBy(), but I don't know how to trigger that when the "Employability Skills Date" is entered. There needs to be subs for "Work Experience Date" and "Placement Services Date" for when those two dates are entered.

Yes, that's correct. A staff will enter a date into one of the three milestone columns and the UpdatedBy and DateUpdated will be automatic. I've already grabbed the Logged in username.

Where I need the help is with determining which cell was modified and putting the updated by and date updated information into the correct cells.

I know how to do an UpdatedBy on the record level, but in this application I need to do it at the column level. Which GridView column was updated? The three milestone dates each have their own "updated by" column.

Yes, my table structure is as you described. One table and a column for each milestone and each UpdatedBy field.
I need the code specific to referencing a specific cell in the GridView so when that date is updated I can update the appropriate "updated by" column. If you haven't dealt with it, you may not be able to tell me the specific code for the GridView. I'm not experienced enough to translate general technique into the code.

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

It looks like that would determine the row/record that was being updated. How would it determine which of the three milestones were being updated?

The three milestones.... Oh, crap! I just noticed my original post. I did not past the code I intended to in either code block. My apologies. Just for clarity let me post the correct markup and code here below... (I need to switch computers)

As I am speaking without the background, I would think a single subrouting can do the trick by checking which column is being updated to correctly update the other two in the same step
i.e. the check on which subroutine to call, would be the mechanism by which you can differentiate which sets of columns to update.

What I posted in the original question was just the SQL statement to update the table I'm working with. Doh! Sorry about that. You did give me the correct information, despite me not giving you good reference information. Thank you for you great patience. ;-)

I don't think you really need the markup and code at this point. But I wanted to include it because I thought I had already. I can't edit the original to fix it.

The subroutine you posted looks spot on for specifying one particular cell, but I'm still not too clear on how to determine which of the three dates are entered and then updating it's corresponding "updated by" column.

A publishing tool, a Version Control System, or a Collaboration Platform! These can be some of the defining words for the two very famous web-hosting Git repositories: Bitbucket and Github. Git is widely used amongst the programmers and developers f…

The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…