Query dataset/datatable

[DaveF]

I have a dataset with an unknown amount of fields. The user can choose a
nuber of numeric fields in that datatable. I am making a chart out of those
fields. I need to know the minimum and maximun values of the highest value
of the selected fields. Is there a way to query that dataset/datatable to
get these values. If so, can you give me an example?

--
Dave

[Elton Wang]

I suppose you want to know count of columns in data table:
dataTbl.Columns.Count

Elton

el********@hotmail.com

-----Original Message-----
I have a dataset with an unknown amount of fields. The user can choose anuber of numeric fields in that datatable. I am making a chart out of thosefields. I need to know the minimum and maximun values of the highest valueof the selected fields. Is there a way to query that dataset/datatable toget these values. If so, can you give me an example?

--
Dave
.

[DaveF]

No. example....

col1 col2 col3 col4 col5
5 8 9 1 1
6 7 4 20 8
23 33 9 5 9
The user wants to see col1 , col2, and col4 in a one chart. I need to know
the max and min value between those 3 columns. So the minimum value of all 3
columns combined is 1 and the maximum value is 33
--
Dave

"Elton Wang" <an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

I suppose you want to know count of columns in data table:
dataTbl.Columns.Count

Elton

el********@hotmail.com

-----Original Message-----
I have a dataset with an unknown amount of fields. The

user can choose a

nuber of numeric fields in that datatable. I am making a

chart out of those

fields. I need to know the minimum and maximun values of

the highest value

of the selected fields. Is there a way to query that

dataset/datatable to

get these values. If so, can you give me an example?

--
Dave
.

[Elton Wang]

In that case you can use
table.Compute("Max(columnName)","");
and
table.Compute("Min(columnName)","");
find out max value and min value for each column, then
compare them.

Elton

-----Original Message-----
No. example....

col1 col2 col3 col4 col5
5 8 9 1 1
6 7 4 20 8
23 33 9 5 9
The user wants to see col1 , col2, and col4 in a one chart. I need to knowthe max and min value between those 3 columns. So the minimum value of all 3columns combined is 1 and the maximum value is 33
--
Dave

"Elton Wang" <an*******@discussions.microsoft.com> wrote in messagenews:08****************************@phx.gbl...

I suppose you want to know count of columns in data table: dataTbl.Columns.Count

Elton

el********@hotmail.com

>-----Original Message-----
>I have a dataset with an unknown amount of fields. The

user can choose a

>nuber of numeric fields in that datatable. I am making

a chart out of those

>fields. I need to know the minimum and maximun values

of the highest value

>of the selected fields. Is there a way to query that

dataset/datatable to

>get these values. If so, can you give me an example?
>
>--
>
>
>Dave
>
>
>.
>

.