Visual Basic Discussion Boards

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

Johnkokk29-Dec-09 20:04

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

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

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

#realJSOP

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.

.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

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

Johnkokk30-Dec-09 23:59

Johnkokk

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.

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

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

Johnkokk

29-Dec-09 21:23

Yeah that gave my brain a start.
Solved.Thanks

CPU Percentage for each running process [modified]

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

Re: CPU Percentage for each running process

#realJSOP29-Dec-09 8:10

#realJSOP

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.

Re: CPU Percentage for each running process

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)

Re: CPU Percentage for each running process

#realJSOP29-Dec-09 23:31

#realJSOP

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.

Re: CPU Percentage for each running process

Luc Pattyn30-Dec-09 1:08

Luc Pattyn

30-Dec-09 1:08

John Simmons / outlaw programmer wrote:
I think I remember seing somewhere

maybe in this article: Timer surprises, and how to avoid them[^]

Smile | :)

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

Merry Christmas and a Happy New Year to all.

installer program

mehrnoosh28-Dec-09 19:38

mehrnoosh

28-Dec-09 19:38

what is the best Lateral program for make installer that is better and more Supple???

M.Alizadeh

Re: installer program

dan!sh 28-Dec-09 19:40

dan!sh

28-Dec-09 19:40

.Net lets you create set up and deployment projects for your application. You can also read about ClickOnce deployement in case it suites your application.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: installer program

εїзεїзεїз28-Dec-09 20:47

εїзεїзεїз

28-Dec-09 20:47

.Net setup and Deployment /Click Once is the best and you can also use Install shield but will prefer

.Net setup

Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

How To Insert Bulk datas in a DataSet Into Table...

shamsubava28-Dec-09 19:25

shamsubava

28-Dec-09 19:25

Dear All

Anybody explain, i have two defrend databse (Foxpro,Sql). i have two table in defrend databse thats are same manner.One table all datas pick one DataSet , now i want simply to insert this Datset to Other Databse Table.
i want Only without Useing Loops. is it Possible...?

Kindly reply Me...
Thanx For advance

Re: How To Insert Bulk datas in a DataSet Into Table...

dan!sh 28-Dec-09 19:36

dan!sh

28-Dec-09 19:36

SSIS would have been a good choice here. Although you can also do this using the SqlBulkCopy class in case you are inserting data into the SQL database.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: How To Insert Bulk datas in a DataSet Into Table...

shamsubava28-Dec-09 19:44

shamsubava

28-Dec-09 19:44

thanx for Your Valuable Information.

Dear frnd is it Posiible to Accssdatabase table also..?
supose i have one dataset thats insert into AccssDatabase..is it possible...

Kindly reply me

Re: How To Insert Bulk datas in a DataSet Into Table...

dan!sh 28-Dec-09 19:48

dan!sh

28-Dec-09 19:48

I guess you would connect to the access table through OleDb which does not provides a BulkCopy class. So, your best bet, IMO, would be to have a stored procedure or a bulk insert SQl statement which will take in the array of values or the datatable itself as a parameter and perform the insert.

Since I have not used Access, I am not sure writing such stored procedure in it is possible or not. But I am sure google will help with that.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: How To Insert Bulk datas in a DataSet Into Table...

shamsubava28-Dec-09 20:12

shamsubava

28-Dec-09 20:12

thanx for your valuable information...

if u get any solution pls foraward me...

shamsubava@gmail.com

Changing System Short Date Format

εїзεїзεїз28-Dec-09 19:23

εїзεїзεїз

28-Dec-09 19:23

Thanks in Advance

I want to change System Short Date Format to "dd-MM-yyyy" , Already Goggled and tried even on CP but all in vain , i tried this code but its not working even

Dim reg As RegistryKey
        reg = Registry.Users.OpenSubKey("S-1-5-21-1757981266-861567501-682003330-500\Control Panel\International", True)
        If Convert.ToString(reg).Trim = String.Empty Then
            MsgBox("Invalid")
        Else
            reg.SetValue("sShortDate", "dd/MM/yyyy")
            reg.SetValue("sLongDate", "dd/MM/yyyy")
        End If

Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

Re: Changing System Short Date Format

dan!sh 28-Dec-09 19:39

dan!sh

28-Dec-09 19:39

Check this[^] article. Might help.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: Changing System Short Date Format

εїзεїзεїз28-Dec-09 20:20

εїзεїзεїз

28-Dec-09 20:20

its in VB6

Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

Re: Changing System Short Date Format

dan!sh 28-Dec-09 20:47

dan!sh

28-Dec-09 20:47

Yes. But all it does is to call some methods in kernel32. You can do the same through .Net as well.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: Changing System Short Date Format

Abhinav S28-Dec-09 20:02

Abhinav S

28-Dec-09 20:02

S0FTDEV wrote:
dd-MM-yyyy

Just to make sure that this is just a typo, you are trying to set your date format to dd-MM-yyyy, but your code sets it to dd/MM/yyyy.

There are only 10 types of people in this world — those who understand binary, and those who don't.

Re: Changing System Short Date Format

εїзεїзεїз28-Dec-09 20:06

εїзεїзεїз

28-Dec-09 20:06

"dd-MM-yyyy" is not the problem actually it changes the Registry value to "dd/MM/yyyy" or "dd-MM-yyyy" but in regional settings the date format still remains the same

Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.