How to create schedule program in c#

[meenus]

Hi

I want to execute some collection of SQL statements in SQL Server 2005DataBase with time condition based ,So i need to create the Schedule Program in c# ,could you explain the Schedule concepts or send example programs.

[dannystommen]

You could create a Windows Service that has a timer running.

Take a look here to create a Windows Service

[Shuja Ali]

Or maybe you could write a simple Console Application and schedule it using the Task Scheduler.

[meenus]

thank you

[rliq]

if you use a Windows Service with a Timer, do not drag a Timer control onto the design service, but rather use the System.Threading.Timer class... eg to help get you started....

using System;
using System.ServiceProcess;
using System.Threading;

namespace MyProject
{
    public partial class TestService : ServiceBase
    {
        private Timer _timer;  // System.Threading.Timer

        public TestService()
        {
            InitializeComponent();
        }

        protected override void OnStart(String[] args)
        {
            Int32 interval = 20000;
            object state = null;  // put something in here if your Tick callback needs it
			
            try
            {
                // third parameter of 0 means start immediately
                _timer = new Timer(new TimerCallback(OnTick), state, 0, interval);
            }
            catch (Exception ex)
            {
                // uh oh
            }
        }

        protected override void OnStop()
        {
            _timer.Change(Timeout.Infinite, Timeout.Infinite);
        }

        private void OnTick(object state)
        {
            // react to the Tick
        }
    }
}