How can I get SQL Date and time into statusstrip with timeer control
Recommended Answers
Jump to Postuse
select getdate()on SQL and executescalar to get the value.
Assign the value to a var and use it in statusstrip or wherever.
I'm not sure what you are doing with the timer control though.PS: Why does it has to be the SQL date/time and not the …
All 4 Replies
adam_k
239
Master Poster
use select getdate() on SQL and executescalar to get the value.
Assign the value to a var and use it in statusstrip or wherever.
I'm not sure what you are doing with the timer control though.
PS: Why does it has to be the SQL date/time and not the system running the code? Reading it from SQL will be way slower than locally. If you are planning on using the timer to refresh it - by reading it again - then it's gonna be way slow.
adnysam
0
Newbie Poster
If I use select getdate() with timer, appear an error.
I want to place this software on 4-5 pcs with one server and want that statusstrip shows only Server Pcs date & time instead of local datetime. that the reasonwhile I use this.
adam_k
239
Master Poster
Please show your code. It's way easier than guessing what you've done wrong.
adnysam
0
Newbie Poster
Thanks Adam_K
I have got the code.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.