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.
SyncMaster170
0
Junior Poster in Training
Recommended Answers
Jump to Postusing keyword is instead of calling Dispose() method.
The same is:SqlConnection sqlConn = new SqlConnection"(connString"); // rest of code.. // on the end you close or dispose IDisposable object: sqlConn.Dispose(); //its EXACTLY thw same as: using (SqlConnection sqlConn = new SqlConnection("connString")) { // rest of code.. …
All 4 Replies
Mitja Bonca
557
Nearly a Posting Maven
SyncMaster170
0
Junior Poster in Training
svilla
17
Junior Poster in Training
Mitja Bonca
557
Nearly a Posting Maven
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.