Using Max and Sum on a Dataset - Possible?

[Anil Gupte]

What is wrong with this?
Dim strFindMax As String = "max(ProfileID)"

Dim drFindMax As DataRow() = DSet.Tables("Profiles").Select(strFindMax)

I get an error saying strFindMax does not evaluate to a Boolean. What I
really want to do is
Dim intFindMax As Integer = DSet.Tables("Profiles").Select(strFindMax)

Same thing wth Sum. Any ideas on how I can do this, or if there is any
other way?

Thanx,
--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv

[Patrice]

It seems you confuse the Select and Compute methods
(http://msdn.microsoft.com/en-us/libr...compute.aspx.)...

--
Patrice

"Anil Gupte" <an*******@icinema.coma écrit dans le message de groupe de
discussion : uM**************@TK2MSFTNGP03.phx.gbl...

What is wrong with this?
Dim strFindMax As String = "max(ProfileID)"

Dim drFindMax As DataRow() = DSet.Tables("Profiles").Select(strFindMax)

I get an error saying strFindMax does not evaluate to a Boolean. What I
really want to do is
Dim intFindMax As Integer = DSet.Tables("Profiles").Select(strFindMax)

Same thing wth Sum. Any ideas on how I can do this, or if there is any
other way?

Thanx,
--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv

[Anil Gupte]

Ah Thanx! In regular SQL, you use Select Max(FiledName) so I just thought
it would work. Thanx a lot for your help.

--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv
"Patrice" <http://www.chez.com/scribe/wrote in message
news:05**********************************@microsof t.com...

It seems you confuse the Select and Compute methods
(http://msdn.microsoft.com/en-us/libr...compute.aspx.)...

--
Patrice

"Anil Gupte" <an*******@icinema.coma écrit dans le message de groupe de
discussion : uM**************@TK2MSFTNGP03.phx.gbl...

>What is wrong with this?
Dim strFindMax As String = "max(ProfileID)"

Dim drFindMax As DataRow() = DSet.Tables("Profiles").Select(strFindMax)

I get an error saying strFindMax does not evaluate to a Boolean. What I
really want to do is
Dim intFindMax As Integer = DSet.Tables("Profiles").Select(strFindMax)

Same thing wth Sum. Any ideas on how I can do this, or if there is any
other way?

Thanx,
--
Anil Gupte
www.keeninc.net
www.icinema.com
www.wizo.tv