C#

InitializeComponent();
            //Log off
            SystemEvents.SessionEnding += (s, e) =>
            {
                switch(e.Reason){
                    case SessionEndReasons.Logoff:
                    ComPort.Close();
                    ComPort.Write(new byte[] { 48 }, 0, 1);
                    break;
                    case SessionEndReasons.SystemShutdown:
                    ComPort.Close();
                    ComPort.Write(new byte[] { 48 }, 0, 1);
                    break;
                }
                
            };

Member 10850253 wrote:

ComPort.Close();
ComPort.Write(new byte[] { 48 }, 0, 1);

SystemEvents.SessionEnding += new SessionEndingEventHandler(SystemEvents_SessionEnding);
void SystemEvents_SessionEnding(object sender, SessionEndingEventArgs e)
            {
                if (e.Reason == SessionEndReasons.Logoff)
                {
                 \\Code
                }
            }

double result = 0;
string strSum = "SELECT SUM(Val1 + Val2 + Val3) AS Total FROM myTable WHERE year=@year";
int year;
// User inputs should never be trusted and always tested against validity
if (!int.TryParse(txtyear.Text, out year)) {
   throw new ArgumentException("Entered text is not convertible to a valid integer.");
}
using (OleDbConnection cnn = new OleDbConnection(strcn)) {
   cnn.Open();
   using (OleDbCommand cmd = new OleDbCommand(strSum, cnn)) {
      cmd.Parameters.AddWithValue("@year", year);
      try {
         result = (double)cmd.ExecuteScalar();
      }
      catch (SqlException ex) {
         MessageBox.Show(string.Format("{0}{1}{2}", ex.Message, Environment.NewLine, ex.StackTrace));
      }
   }
}
return result;

Sum.ToString("F30").TrimEnd("0".ToCharArray());

JammoD87 wrote:

1 - What project architecture do people generally use these days and what is
best practice, can you provide me with some examples?

JammoD87 wrote:

2 - If I continue down the ADO.Net route do I create different classes for the
different Stored Procedures that are used?

JammoD87 wrote:

3 - Am I making the right decision using ADO.Net?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]