ExamGuru IT/.Net Guru : Group By Substitute and DataView on microsoft.public.dotnet.languages.vb

.NETGURU

Group By Substitute and DataView

Messages

Related Types

This message was discovered on microsoft.public.dotnet.languages.vb.

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

Reply to this message...

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"

"Andreas Håkansson" <Click here to reveal e-mail address> skrev i meddelandet
news:%23Cz2e$Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

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

"Andreas Håkansson" <Click here to reveal e-mail address> wrote in message
news:%Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

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" <Click here to reveal e-mail address> wrote in message
news:%23Cz2e$Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

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" <Click here to reveal e-mail address> wrote in message
news:%23Cz2e$Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

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 =/

"B-Dog" <Click here to reveal e-mail address> skrev i meddelandet
news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

Andreas Håkansson

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

//Andreas

"Andreas Håkansson" <Click here to reveal e-mail address> skrev i meddelandet
news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

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

"Andreas Håkansson" <Click here to reveal e-mail address> wrote in message
news:%23$Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

	System.Data.DataTable
	System.Web.UI.WebControls.DataGrid
	System.Windows.Forms.DataGrid

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification