troubleshooting Question

Windows Services....Please need help!!!!

Avatar of udir
udir asked on
C#
10 Comments1 Solution899 ViewsLast Modified:
Hi,
I need to do a Service which will read a table lets say at 24:00 every 24hrs, and if a new row has added
(maybe with a date+time field in the table which the service can use in order to compare with the last time the service has read the table?....)  then a message will apear.

I wrote :
    public partial class Service1 : ServiceBase
    {
        public string res;
        OleDbConnection accesscon;
          protected override void OnStart(string[] args)
        {
             string con = @"provider=Microsoft.JET.OLEDB.4.0; data source = C:\Inetpub\wwwroot\Test.mdb";
            OleDbConnection accesscon = new OleDbConnection(con);
            accesscon.Open();
        }
        protected override void OnCustomCommand(int command)
        {
            base.OnCustomCommand(command);
            OleDbCommand maxnumCom = new OleDbCommand("select Max(DateAdd),Max(TimeAdd) from    
                                                                                                                                tblUsers", accesscon);
            maxnumCom.CommandType = CommandType.Text;
             res = Convert.ToString(maxnumCom.ExecuteScalar());
            if (res != null)
            {
                Console.WriteLine("Max Value is:" + res);
            }            
         }
    }

1) nothing happaned!! where should i see the message???(Windows Services is new topic for me)
2) how can i deal with the - "if a new row is added" show a message? (and maybe compare between date and time field??

Thanks in advance...
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros