troubleshooting Question

VB.Net - DataGridView update LastUpdated field in SQL Table

Avatar of Jimbo99999
Jimbo99999Flag for United States of America asked on
Visual Basic.NET
5 Comments2 Solutions702 ViewsLast Modified:
Good Day Experts!

I am shopping for assitance with a new task in my project that I do not understand hot to achieve it in VB.net.  I have a DataGridView that presents the User with SQL table data.  The User updates the data ans hits the <Update> button and the updates are written back to the SQL table.

My new task is in that SQL table I need to update the [LAST UPDATED] field when a change is made to a record.  

So far I have gone down this path:
    1)Put [LAST UPDATED] in my DataGridView so it can be in the dataTable that gets pulled
       down from db so I can send changes to it back to the database
    2)So, now have to figure out how to get the current date/time stamp into the
       DataGridView Last Update column when changes to the record in the DataGridView
       is made?
    3)When I run the UpdateCommand then it gets updated back to the database?

Am I on the right track? If, so what do I do next?

Thanks,
jimbo99999
ASKER CERTIFIED SOLUTION
adriankohws

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros