void tick_Tick2(object sender, EventArgs e) { statusEx = new MEMORYSTATUSEX(); statusEx.setValues(); val1 = statusEx.dwMemoryLoad.ToString(); val2 = statusEx.convertToBytes(statusEx.ullTotalPhys).ToString("0.00"); val3 = statusEx.convertToBytes(statusEx.ullAvailPhys).ToString("0.00"); val4 = statusEx.convertToBytes(statusEx.ullTotalPageFile).ToString("0.00"); val5 = statusEx.convertToBytes(statusEx.ullAvailPageFile).ToString("0.00"); val6 = statusEx.convertToBytes(statusEx.ullTotalVirtual).ToString("0.00"); val7 = statusEx.convertToBytes(statusEx.ullAvailVirtual).ToString("0.00"); try { myConnection.Open(); string query = "INSERT INTO SystemMemoryInfo(AgentID,PercentageOfMemoryInUse,TotalPhysicalMemory,TotalAvailablePhysicalMemory,CurrentCommittedMemory,MaxAmountCommittableMemory,TotalVirtualMemory,VirtualMemoryAvailable)" + "VALUES(1,'" + val1 + "','" + val2 + "','" + val3 + "','" + val4 + "','" + val5 + "','" + val6 + "','" + val7 + "')"; SqlCommand insertQuery = new SqlCommand(query, myConnection); insertQuery.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine("cannot open SQL connection " + ex); } myConnection.Close(); }
private void SystemMemoryInfo_Load(object sender, EventArgs e) { statusEx = new MEMORYSTATUSEX(); statusEx.setValues(); ram_percentage.Text = statusEx.dwMemoryLoad.ToString(); ram_totalPhysical.Text = statusEx.convertToBytes(statusEx.ullTotalPhys).ToString("0.00" + " MB"); ram_availPhysical.Text = statusEx.convertToBytes(statusEx.ullAvailPhys).ToString("0.00" + " MB"); ram_totalPage.Text = statusEx.convertToBytes(statusEx.ullTotalPageFile).ToString("0.00" + " MB"); ram_availPage.Text = statusEx.convertToBytes(statusEx.ullAvailPageFile).ToString("0.00" + " MB"); ram_totalVirtual.Text = statusEx.convertToBytes(statusEx.ullTotalVirtual).ToString("0.00" + " MB"); ram_availVirtual.Text = statusEx.convertToBytes(statusEx.ullAvailVirtual).ToString("0.00" + " MB"); }