Group By Substitute and DataView

[Andreas Håkansson]

Hello,

As far as I've been able to find it is not possible to perform a "Group By"
action
using ADO.NET - however I get an array of objects (like SomeObjects() As
SomeObject) from a 3rd party vendor (webservice) which I use a small
reflection
routine to map to a datatable.. so far so good..

Now I want to display them in a DataGrid byt first I would like to do some
data
manipulation on it, ie. I would like to perform a "Group By Price, Vendor"
kind
of operation...

Any ideas how this can be solved in a good and efficient way? I would have
to say
that the DataTable will never contain more than 50 rows. I have NO option on
making
a SQL Group By myself since I get an array back and have no controll over
it.

//Andreas

 

[One Handed Man \( OHM - Terry Burns \)]

When you say you want them Grouped, in what way do you mean ?, what I am
driving at is do you want a datagrid for example, you display a navigation
where all the groups are expandable ?

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

 

[Andreas Håkansson]

Terry,

No I mean I would like to perform the same operation as a SQL GROUP BY
would do. I.e groups the rows based on one or more columns (two in my case)

basiclly what I have is the same as the result from a "SELECT * FROM xyz"
and I would like to transform it into a "SELECT * FROM xyz GROUP BY a, b"

 

[B-Dog]

I was just fixing to post the same question. I'm looking to do the same
thing. Funny how some people don't read posts very well before posting.

 

[Andreas Håkansson]

B-Dog,

I managed to find this
http://support.microsoft.com/default.aspx?scid=kb;en-us;325685 but I have
not been able to get it to work. It compiles and runs, but doesn't return
any rows =/

 

[Andreas Håkansson]

Got it rolling with the helper class... alternative solutions is still of
intresst!

//Andreas

 

[One Handed Man \( OHM - Terry Burns \)]

Sounds like you sorted it anyway

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

 

[B-Dog]

I have a guy here that said he knows how to do it. I'll get with him then
email you what he shows me. Thanks