Member Avatar for adnysam

How can I get SQL Date and time into statusstrip with timeer control

  • 2 Contributors
  • 4 Replies
  • 162 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by adnysam
Member Avatar for adam_k

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.

Member Avatar for adnysam

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.

Member Avatar for adam_k

Please show your code. It's way easier than guessing what you've done wrong.

Member Avatar for adnysam

Thanks Adam_K

I have got the code.

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.