469,643 Members | 1,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

Query dataset/datatable

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
Nov 19 '05 #1
3 4984
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
.

Nov 19 '05 #2
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
.

Nov 19 '05 #3
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
>
>
>.
>

.

Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Job Lot | last post: by
4 posts views Thread by Jim in Arizona | last post: by
1 post views Thread by Chris Thunell | last post: by
8 posts views Thread by Jim in Arizona | last post: by
2 posts views Thread by =?Utf-8?B?Q2hyaXM=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.