C#

try{
  // code here
}
catch(Exception ex){
  //Note that ex, in contrary of your example is initialized as the Exception type.
  //Your code would work in javascript for example, but in C# you need to always define the type of a variable
  // the very least you need to do is LOG the error somewhere.  Note that Exception is a general class,
  //you can also catch specific Exception like IndexOutOfBoundsException, OutOfMemoryException, ...
  //You can use multiple catch blocks if you wich and handle logging, user information, ... accordingly
  //But I believe that if you catch you should at the very least catch the Exception
}
finally{
  //Mostly the finally block is used the handle things that must be done even if the catch block was called.
  //eg.  A rollback against the database, close a database connection or close a file handle.
}

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\InterSystems Cache ODBC]
"Driver"="C:\\CacheSys\\bin\\CacheODBC.dll"
"Setup"="C:\\CacheSys\\bin\\CacheODBC.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="02.10"
"ConnectFunctions"="YYN"
"APILevel"="1"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"InterSystems Cache ODBC"="Installed"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\CABMATE1]
"Driver"="C:\\CacheSys\\bin\\CacheODBC.dll"
"Protocol"="TCP"
"Host"="xx.xx.xx.xx"
"Port"="xxxx"
"Namespace"="CABMATE"
"UID"="xxxxxxx"
"Password"="xxx"
"Description"="CabMate on TTCAB1"
"Query Timeout"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\CABMATE2]
"Driver"="C:\\CacheSys\\bin\\CacheODBC.dll"
"Protocol"="TCP"
"Host"="xx.xx.xx.xx"
"Port"="xxxx"
"Namespace"="CABMATE"
"UID"="xxxxxxx"
"Password"="xxx"
"Description"="CabMate on TTCAB2"
"Query Timeout"="0"

CCodeNewbie wrote:

2
The TotalProcessorTime works when run as a Console App under a local admin
account so why does it error as a Windows service? Do I need to pre-format the
request/return value? I am afraid I don't know (yet) how to remove the tick
count from a built-in property as all I am really doing is taking this
http://msdn.microsoft.com/en-us/library/system.diagnostics.process.totalprocessortime.aspx
and writing it into a service.

{
DateTime Tstamp = DateTime.Now;
Process[] processlist = Process.GetProcesses();
foreach (Process p in processlist)
{
if (p.ProcessName == "Idle")
    {
    SqlConnection myconn = new SqlConnection("User id = a; password = b; server = c database = e connection timeout=30");
    SqlCommand insp = new SqlCommand("INSERT INTO dbo.tbconn(Tstamp, SysID, PID, PName, PMem) VALUES (@Tstamp, @SysID, @PID, @PName, @PMem)", myconn);
    
    insp.Parameters.Add("@Tstamp", SqlDbType.DateTime);
    insp.Parameters.Add("@SysID", SqlDbType.Int);
    insp.Parameters.Add("@PID", SqlDbType.Int);
    insp.Parameters.Add("@PName", SqlDbType.NVarChar, 50);
    insp.Parameters.Add("@PMem", SqlDbType.Int);
    
    insp.Parameters["@Tstamp"].Value = Tstamp;
    insp.Parameters["@SysID"].Value = 100;
    insp.Parameters["@PID"].Value = p.Id;
    insp.Parameters["@PName"].Value = p.ProcessName;
    insp.Parameters["@PMem"].Value = p.WorkingSet64 / 1024;

    myconn.Open();
    insp.ExecuteNonQuery();
    myconn.Close();
    }

if (p.ProcessName == "System")
    {
        SqlConnection myconn = new SqlConnection("User id = a; password = b; server = c database = e connection timeout=30");
    SqlCommand insp = new SqlCommand("INSERT INTO dbo.tbconn(Tstamp, SysID, PID, PName, PCPU, PMem) VALUES (@Tstamp, @SysID, @PID,@PName, @PCPU, @PMem)", myconn);
    insp.Parameters.Add("@Tstamp", SqlDbType.DateTime);
    insp.Parameters.Add("@SysID", SqlDbType.Int);
    insp.Parameters.Add("@PID", SqlDbType.Int);
    insp.Parameters.Add("@PName", SqlDbType.NVarChar, 50);
    insp.Parameters.Add("@PCPU", SqlDbType.Int);
    insp.Parameters.Add("@PMem", SqlDbType.Int);
    
    insp.Parameters["@Tstamp"].Value = Tstamp;
    insp.Parameters["@SysID"].Value = 100;
    insp.Parameters["@PID"].Value = p.Id;
    insp.Parameters["@PName"].Value = p.ProcessName;
    insp.Parameters["@PCPU"].Value = p.TotalProcessorTime.TotalMilliseconds/ 1000;
    insp.Parameters["@PMem"].Value = p.WorkingSet64/1024;
    
    myconn.Open();
    insp.ExecuteNonQuery();
    myconn.Close();
    }

else
    {
    SqlConnection myconn = new SqlConnection("User id = a; password = b; server = c database = e connection timeout=30");
    SqlCommand insp = new SqlCommand("INSERT INTO dbo.tbconn(Tstamp, SysID, PID, PName, PStart, PExe, PCPU, PMem) VALUES (@Tstamp, @SysID, @PID, @PName, @PStart, @PExe, @PCPU, @PMem)", myconn);
    
    insp.Parameters.Add("@Tstamp", SqlDbType.DateTime);
    insp.Parameters.Add("@SysID", SqlDbType.Int);
    insp.Parameters.Add("@PID", SqlDbType.Int);
    insp.Parameters.Add("@PName", SqlDbType.NVarChar, 50);
    insp.Parameters.Add("@PStart", SqlDbType.DateTime);
    insp.Parameters.Add("@PExe", SqlDbType.NVarChar, -1);
    insp.Parameters.Add("@PCPU", SqlDbType.Int);
    insp.Parameters.Add("@PMem", SqlDbType.Int);
    
    insp.Parameters["@Tstamp"].Value = Tstamp;
    insp.Parameters["@SysID"].Value = 100;
    insp.Parameters["@PID"].Value = p.Id;
    insp.Parameters["@PName"].Value = p.ProcessName;
    insp.Parameters["@PStart"].Value = p.StartTime;
    insp.Parameters["@PExe"].Value = p.MainModule.FileName;
    insp.Parameters["@PCPU"].Value = p.TotalProcessorTime.TotalMilliseconds / 1000;
    insp.Parameters["@PMem"].Value = p.WorkingSet64/1024;
    
    myconn.Open();
    insp.ExecuteNonQuery();
    myconn.Close();
    }
}
}

@Html.DropDownListFor(model => model.Result, new SelectList(Model.Result.OrderBy(item => item.Enhet), "EnhetID", "Enhet"), "ALL")
.GroupBy(x => x.Enhet)
.Select(x => x.First());