Hello all! So in my app, I have 5 columns, firstname,lastname,membership,accountid, and date.
Once a members card has been scanned, the app figures out if that member is in my sql table or not. If he/she is, it will update their 'date' column in my dgv. If he/she is not, the app will add them to my sql table and redraw my dgv to reflect my updated sql table.
Does anyone know how to pull a specific datetime value from sql table and compare it with the current datetime in C#? I should also better rephrase that, I need HELP with pulling that specific members datetime column value, not so much comparing. I know how to compare datetime values(i.e. TimeSpan) An important thing to add is in the beginning, when the member scans their card, their accountID # will be in my textbox1. And I assigned txtbox1.text to my var called newString. I need to grab that specific members specific datetime column value if he/she is already in my dgv for comparing to current time. Thanks.