How I can use of timer for execute my code in every 2 min

Question

1.00/5 (2 votes)

See more:

Good evening all.........
I am using this for copy a table data from one server to another server in sqlserver 2000.
I want this code execute in every 2 minute because source data updated in every 2 minutes and i need to copy new data in every 2 min. I try many but not sucess any, please help me its urgent, Thank you all.

C#

namespace Test
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            SqlConnection source = new SqlConnection("Server = Rajan;User ID=abc;Password=123;Database=Test");
            SqlConnection destination = new SqlConnection("Server = santosh;User ID=india;Password=12345;Database=Book");

            SqlCommand cmd = new SqlCommand("delete from Book", destination);
            source.Open();
            destination.Open();
            cmd.ExecuteNonQuery();
            cmd = new SqlCommand("select * from Test", source);

            SqlDataReader reader = cmd.ExecuteReader();
            SqlBulkCopy bulkdata = new SqlBulkCopy(destination);
            bulkdata.DestinationTableName = "Book";
            bulkdata.WriteToServer(reader);
            bulkdata.Close();
            destination.Close();
            source.Close();

            InitializeComponent();
        }
    }
}

Posted 17-Jul-13 4:22am

shunuman

Updated 17-Jul-13 5:13am

Mike Meinz

v2

Add a Solution

Comments

[no name] 17-Jul-13 10:26am

Not it is not at all urgent. I do not see where you are using any kind of 2 minute timer here.

3 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)

Valery Possoz · Answer 1 · 2013-07-17T04:35:00

Solution 1

Hello,

use a Timer.

Timer timer = new Timer();
timer.Interval = 12000;
timer.Elapsed += timer_Elapsed;
timer.Start();

and in the timer_Elapsed method put what ever code needs to be executed every 2 minutes:

C#

void timer_Elapsed(object sender, ElapsedEventArgs e)
{
    // your code here.
}

Valery.

Posted 17-Jul-13 4:35am

Valery Possoz

Comments

shunuman 17-Jul-13 11:00am

Thank you for reply....
But it gives a error....
timer_Elapsed
The type or namespace name 'ElapsedEventArgs'.

shunuman 17-Jul-13 11:01am

I am using windows application..

Arpit Shrivastava · Answer 2 · 2013-07-17T04:39:00

Solution 2

You are using Form, so I am guessing your code is in Window Form.

So you can implement a TIMER (Go to TOOLBOX >> Click COMPONENTS >> Drag TIMER to the Form), You have to call your Constructor method to this function:

timer1_Tick(...)

Now right click your timer in Form1.cs [Designer] and select property. Now you have to set the Interval field to 120000 (Remember this interval is in milliseconds) and Set the Enabled field to True.

You are done.

Posted 17-Jul-13 4:39am

Arpit Shrivastava

Updated 17-Jul-13 9:35am

v3

Comments

shunuman 17-Jul-13 11:02am

Yes, I am using windows application.
can you please describe how i can use this code in timer.

Arpit Shrivastava 17-Jul-13 11:19am

You have to create a Event by clicking your timer property and set a Tick event. Now you can put your code or call your constructor in this method timer1_Tick(...)

Mike Meinz 17-Jul-13 11:17am

Arpit, 2000 is 2 seconds not 2 minutes. I suggest setting the Timer interval to 60000 and then in the Tick event count the number of ticks and on the second tick, execute the SQL code and reset the tick count to zero.

Arpit Shrivastava 17-Jul-13 11:23am

Yeah, you are right Mike, but the time should be 120000 = 2 minutes. and Is there any need to reset the timer???

Mike Meinz 17-Jul-13 13:07pm

Yes, 120000 can be used.

I am "old school" so I used 60000 and counted the minutes. The original Timer control had a max Interval value of 65535. I keep forgetting that the shift to a 32-bit version changed that.

I would usually disable the Timer during the time that I was executing the SQL and then re-enable the Timer when the SQL was finished. That way, I didn't risk having the SQL still running when the Timer caused the next execution of the SQL....

shunuman · Answer 3 · 2013-07-24T21:32:00

Solution 3

I have used

while (true)
{
// code

}
in instead of timer and it's working well.

Posted 24-Jul-13 21:32pm

shunuman