How to set interval timer of windows service using SQL server database?

Question

0.00/5 (No votes)

See more:

I have a windows service which runs every 30 seconds. But after installing, I may want it to run every 2mins or 30mins. So I want the service to collect the interval timer (Start time too. I don't really need to set start time but it would be helpful to know) from the SQL server database. I don't want to set it using app.config, but it would be my last option if I didn't get the solution for this.

I know this logically, so i would prefer if you could help me on how to code it.
Any link on this type of project would also be appreciated.

What I have tried:

I know connection string

C#

con = new SqlConnection("server=servername; database=databasename;uid=username; password=password");

What i don't know is how to assign only last updated value to a variable.
For example If I query like this

C#

string sQuery = "Select IntervalTime from Intervals"

It would give all IntervalTime vales in the table. But I want only last inserted value to be assigned.

Posted 9-May-18 19:31pm

Member 13714562

Updated 9-May-18 20:37pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2018-05-09T19:57:00

Solution 2

If I understand the question correctly, the problem is in fetching the data from the database. If that's correct, there are quite a few articles with different kinds of examples covering different kinds of situations. For example, have a look at Properly executing database operations[^]. What comes to the connection string, you can store it in app.config or any place it feels reasonable.

Posted 9-May-18 19:57pm

Wendelius

Comments

Member 13714562 10-May-18 2:38am

I couldn't find the solution from your link. Also, I have updated my question.

Wendelius 10-May-18 3:02am

Ok, so the problem is fetching the latest value. Try a query like

Select TOP(1) IntervalTime from Intervals ORDER BY IntervalTime DESC

Member 13714562 10-May-18 3:30am

I think this might work. Will check and see. Thank you.

Christian Graus · Answer 2 · 2018-05-09T19:35:00

Solution 1

app.config can have a connection string. You'll need to make a SQL call to get the value you want to use for your timer

Posted 9-May-18 19:35pm

Christian Graus

Comments

Member 13714562 10-May-18 1:39am

Can you show it using code. How to read the interval time in the table and set it to variable?