Getting Maximum value of 6 numbers

[John Yatla]

Here is how I've done it.

intMAX = Math.Max(Math.Max(Math.Max(dr("NAQty"),
dr("CurrentNotRequiredYetQty")), Math.Max(dr("OutstandingQty"),
dr("SavedQty"))), Math.Max(dr("UnapprovedQty"), dr("UpdatedQty")))

Is there a better way?

[Chris Hyde]

John Yatla wrote:

Here is how I've done it.

intMAX = Math.Max(Math.Max(Math.Max(dr("NAQty"),
dr("CurrentNotRequiredYetQty")), Math.Max(dr("OutstandingQty"),
dr("SavedQty"))), Math.Max(dr("UnapprovedQty"), dr("UpdatedQty")))

Is there a better way?

I am not sure of performance metrics, but you could just put the numbers
into an array, and then use the Array.Sort method.

The highest number will then be in the LAST index position of the array
(index 5 for a 6 item array);

HTH...

Chris

[Lowell Heddings]

Alternatively, since you are obviously pulling these numbers from a
database, you could do the sort in the database.

The array method would probably work best though.

Lowell

Chris Hyde wrote:

John Yatla wrote:

Here is how I've done it.

intMAX = Math.Max(Math.Max(Math.Max(dr("NAQty"),
dr("CurrentNotRequiredYetQty")), Math.Max(dr("OutstandingQty"),
dr("SavedQty"))), Math.Max(dr("UnapprovedQty"), dr("UpdatedQty")))

Is there a better way?

I am not sure of performance metrics, but you could just put the numbers
into an array, and then use the Array.Sort method.

The highest number will then be in the LAST index position of the array
(index 5 for a 6 item array);

HTH...

Chris

[weichung[MCSD,MCDBA]]

I think the way you are using will be faster if comparing with the Array
techniques, but obviously the code looks untidy. :)

weichung
"Chris Hyde" <ch*****@nodirecwayspam.com> wrote in message
news:u7**************@TK2MSFTNGP12.phx.gbl...

John Yatla wrote:

Here is how I've done it.

intMAX = Math.Max(Math.Max(Math.Max(dr("NAQty"),
dr("CurrentNotRequiredYetQty")), Math.Max(dr("OutstandingQty"),
dr("SavedQty"))), Math.Max(dr("UnapprovedQty"), dr("UpdatedQty")))

Is there a better way?

I am not sure of performance metrics, but you could just put the numbers
into an array, and then use the Array.Sort method.

The highest number will then be in the LAST index position of the array
(index 5 for a 6 item array);

HTH...

Chris