Visual Basic

January minus 2 should be November......(a little math and some SQL)

29-Dec-09 23:32

Use WMI. Also, the HD serial number changes every time the disk is formatted.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Johnkokk29-Dec-09 7:42

Re: January minus 2 should be November......(a little math and some SQL)

29-Dec-09 7:42

Ok, i know it sounds ridiculous, but i am stuck here.

I have 2 spineditors.The purpose is to make an SQL statement.
The first(a) spineditor takes values from 1 to 12 and represents the months.
The second(b) spineditor takes values from 1 to 5 and represents the latitude of the value selected in a (the number of months above and below the first spineditor).

For example.
If on (a) i choose 1(JANUARY) and on b 2(which means i want to get 2 months below JANUARY and 2 months above JANUARY), i want the SQL stetement to be "SELECT * from TABLE WHERE (MONTH BETWEEN 11 AND 12) OR (MONTH BETWEEN 1 AND 3)"
In other words i want to select all the months from NOVEMBER to MARCH

I hope you understand what i am saying here Smile | :)

#realJSOP29-Dec-09 8:05

Re: January minus 2 should be November......(a little math and some SQL)

29-Dec-09 8:05

What does the user do if he wants November through February?

And no, you didn't post your actual question - you merely gave us some criteria.

Johnkokk29-Dec-09 20:04

Re: January minus 2 should be November......(a little math and some SQL)

29-Dec-09 20:04

The first spineditor is where you choose the month.The second just tells the programm to broaden the criteria of the month by so many months (spineditor b).

So if he wants just November he chooses 11 on the first spineditor.But if he wants also October and December he will put 1 in the second spineditor

Luc Pattyn30-Dec-09 1:06

Luc Pattyn

30-Dec-09 1:06

sounds like you can only cope with an odd number of months; how about choosing October+November???

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Merry Christmas and a Happy New Year to all.

Re: January minus 2 should be November......(a little math and some SQL)

#realJSOP30-Dec-09 9:49

Re: January minus 2 should be November......(a little math and some SQL)

30-Dec-09 9:49

You didn't answer my question. Your sql query is going to break if the user selects November and anything larger than 2 for the month span.

Johnkokk30-Dec-09 23:59

Re: January minus 2 should be November......(a little math and some SQL)

30-Dec-09 23:59

Why will it break ?

With the solution i currently have, if the user puts 11(November) and 2 for the span, i get the following numbers, after a little math :

9,10,11,12,1

Then i just make an SQL like "WHERE MONTH IN (9,10,11,12,1)"

It actually works now.

darkelv29-Dec-09 8:13

darkelv

29-Dec-09 8:13

Find out the months that you want to select, from your example, -1, 0, 1, 2, 3. Then check for lower and upper boundaries, add or minus 12 accordingly. So in your example they would be 11, 12, 1, 2, 3.

Then Select Where Month In (11, 12, 1, 2, 3).

Re: January minus 2 should be November......(a little math and some SQL)

Johnkokk29-Dec-09 21:23

CPU Percentage for each running process [modified]

29-Dec-09 21:23

Yeah that gave my brain a start.
Solved.Thanks

Daniel Riek29-Dec-09 5:38

Daniel Riek

29-Dec-09 5:38

I am creating an application that will get the CPU utilization for each process similar to the TaskManager. I have created the listing below. When the procedure prints out to a console window the CPU percent is always zero. When I debug the code and step through the code line by line the procedure prints the correct CPU percentage. Why does running the code does not work? While stepping through the code works? Thanks for any help.

Dim poc() As Process = Process.GetProcesses()
Dim PCounter As New PerformanceCounter
PCounter.CategoryName = "Process"
PCounter.CounterName = "% Processor Time"

For i As Integer = 0 To poc.Length - 1
    If poc(i).ProcessName.ToString <> "system" Or poc(i).ProcessName.ToString <> "idle" Or poc(i).ProcessName.ToString <> "svchost" Then
        Try
            'PCounter.InstanceName = "_Total"
            PCounter.InstanceName = poc(i).ProcessName
            Console.WriteLine(PCounter.NextValue.ToString & " " & poc(i).ProcessName & " " & poc(i).MainModule.FileName & " " & poc(i).MainWindowTitle)
        Catch ex As Exception
            'Console.WriteLine(poc(i).ProcessName.ToString & " " & ex.Message)
        End Try
    End If
Next

modified on Tuesday, December 29, 2009 11:52 AM

#realJSOP29-Dec-09 8:10

29-Dec-09 8:10

Maybe because it takes time to step through the code, and in that time, the processes have an opportunity to accumulate some data, as opposed to writing it immediately to the console.

Try writing it to the console once per second.

Daniel Riek29-Dec-09 8:32

Daniel Riek

29-Dec-09 8:32

Thanks for the direction. I put a Sleep method in the code

dblCPU = PCounter.NextValue.ToString
Sleep(1)
dblCPU = PCounter.NextValue.ToString



Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

#realJSOP29-Dec-09 23:31

29-Dec-09 23:31

Ummm, the Threading.Thread object has a Sleep method in it. Also, I think I remember seing somewhere that setting anything less that 25 millsecs results in a sleep period of 25 millisecs.

Lastly, if someone helps you here and provides the right answer (or a good one) vote the answer as a good answer.