Interesting DataSet/DataTable question

[Sahil Malik [MVP]]

Friend of mine asked me this, I'll try look at this later in the evening,
but hey feel free to take a stab --

lets say I have a table(table1) that looks like

Region,State,count
--------------------
West,CA,10
West,AZ,20
East,NY,30
East,NJ,40

Using SQL query
-------------------
select region,sum(count)
from table1
group by region

output will be ..
----------------
West,30
East,70

Instead of using abpve query, Assuming "Select * from table1" is fed into a
dataset/datatable, I want to see a recordset view like this ...
West,30
East,70


Is there a direct way of doing it ?(this can be done if i manually remove
state column from column collection and then add up counts for Region column
and dynamically generate a recordet like this .. but i was wondering if
there is a direct way of doing it ??)

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Guest]

You could create a DataTable with a Region column and a Expression column of
psuedo-code "Child.Sum(Count)" assuming you also set up the relation to it.
Is that what you are getting at?

-- John Papa
http://codebetter.com/blogs/john.papa

 

[Val Mazur \(MVP\)]

Hi,

There is no direct way to do this, but you could create a helper class, like
described in next KB article

http://support.microsoft.com/default.aspx?scid=kb;en-us;325685

 

[Sahil Malik [MVP]]

Neat !!!



- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/