C#

DaveyM69 wrote:

If it doesn't matter then it doesn't matter!

        protected override void
        OnStart
        (
            string[] args
        )
        {
# if DEBUG
            System.Threading.Thread.Sleep ( 60000 ) ;
# endif        
            this.oktoproceed = true ;

            base.OnStart ( args ) ;

            if ( this.when != null )
            {            
                this.when.Start() ;
            }
            
            LogMessage ( this.ServiceName + " started" ) ;
            
            return ;
        }

SqlDataAdapter SQL_Adapter;
     DataTable dtReport1 = new DataTable();
     string SQL_Command = "SQL STATEMENT GOES HERE"
     //if (cklbxColumns.Items.Count != 0)
     //{
         SQL_Command += "'" + strExecutive + "', '" + strToolClass + "'";
     //}

     try
     {
         using (SQL_Conn = new SqlConnection(WhatIsTheSQLConnectionString))
         {
             if (SQL_Conn.State != ConnectionState.Open)
             {
                 SQL_Conn.Open();
             }
             else
             {
                 SQL_Conn.Close();
                 SQL_Conn.Open();
             }

             //using (SQL_Adapter = new SqlDataAdapter("SQL STATEMENT GOES HERE", SQL_Conn))
             using (SQL_Adapter = new SqlDataAdapter(SQL_Command, SQL_Conn))
             {
                 // Use DataAdapter to fill DataTable

                 SQL_Adapter.Fill(dtReport1);
                 // 4
                 // Render data onto the screen
                 // dgvReport = DataGridViewer
                 dgvReport.DataSource = dtReport1;
                 //dgvReport.DataMember = "dtToolStatusboardReport";
                 dgvReport.Refresh();
                 gbToolStatusBoard.Refresh();
                 //ActiveForm.Refresh();
             }
             SQL_Adapter.Dispose();
         }
         SQL_Conn.Close();
     }
     catch
     { return; }