On occasions I recall that I might have had to set the datagridview.datasource = null first and then set the datasource again to cause an update.
If you have had bad experiences with it please let us know in a comment below and we will investigate it further.
The left columns would back date themselves automatically.
Yes, it's possible, but it requires writing a script to achieve it.
I have a python script pulling the applicants submission information from an email which updates the database.
The problem that I am running into is that within the database I have the applicants primary email set to no duplicates, thus not allowing the same person to apply for many different jobs as the python script is trying to create a new record within the database causing an error.