473,324 Members | 2,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Group By Substitute and DataView

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
Nov 21 '05 #1
7 7449
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" <an***************@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
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

Nov 21 '05 #2
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" <an***************@nospam.com> skrev i meddelandet
news:%2****************@TK2MSFTNGP10.phx.gbl...
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

Nov 21 '05 #3
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" <an***************@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
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

Nov 21 '05 #4
B-Dog,

I managed to find this
http://support.microsoft.com/default...b;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" <bd***@hotmail.com> skrev i meddelandet
news:OI**************@TK2MSFTNGP14.phx.gbl...
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" <an***************@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
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


Nov 21 '05 #5
Got it rolling with the helper class... alternative solutions is still of
intresst!

//Andreas

"Andreas Håkansson" <an***************@nospam.com> skrev i meddelandet
news:uU**************@TK2MSFTNGP11.phx.gbl...
B-Dog,

I managed to find this
http://support.microsoft.com/default...b;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" <bd***@hotmail.com> skrev i meddelandet
news:OI**************@TK2MSFTNGP14.phx.gbl...
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" <an***************@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
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



Nov 21 '05 #6
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" <an***************@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
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" <an***************@nospam.com> skrev i meddelandet
news:%2****************@TK2MSFTNGP10.phx.gbl...
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


Nov 21 '05 #7
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" <an***************@nospam.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Got it rolling with the helper class... alternative solutions is still of
intresst!

//Andreas

"Andreas Håkansson" <an***************@nospam.com> skrev i meddelandet
news:uU**************@TK2MSFTNGP11.phx.gbl...
B-Dog,

I managed to find this
http://support.microsoft.com/default...b;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" <bd***@hotmail.com> skrev i meddelandet
news:OI**************@TK2MSFTNGP14.phx.gbl...
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" <an***************@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
> 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
>
>



Nov 21 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: DC Gringo | last post by:
I have a series of select queries that use the nesting method but are creating such a huge query that the server can't handle it. The IN section in some cases are so large that I can't even...
4
by: luke | last post by:
Hello, I have a dataview that contains about 300k records with 3 cols (read in from a directory). I need to get the count of rows by col1 and col2 (grouping by col1 and col2). What would be the...
5
by: Amadelle | last post by:
Hi All and thanks in advance, I was wondering what is the best way of grouping data in a dataset. Like using a "Group By" clause in Sql statements. I was thinking of using XML but I don't even...
2
by: Alpha | last post by:
I have a window application. In one of the form, a datagrid has a dataview as its datasource. Initial filtering result would give the datavew 3 items. When I double click on the datagrid to edit...
1
by: Brent Mondoux | last post by:
Hey everyone, I'm trying to find the best non-spaghetti code way to do the equivalent of a ColdFusion CFQUERY GROUP command so that I can display a FAQ with categories as follows: -- Example:...
36
by: kjvt | last post by:
Based on a prior posting, I've written a function to convert a recordset to a dataview. The first call to the function for a given recordset works perfectly, but the second call always returns a...
13
by: Steve | last post by:
I have a form with a dataset and a datagrid. I created a dataview on this dataset. When the user modifies the datagrid, I look up this record in the dataview to make sure it is unique. Here is...
2
by: malice | last post by:
I have been searching the internet for 12+ hours on how to do this. At this point I'm about to give up. I am using VB .Net 2.0 with the enterprise library jan 2006 release. This is my first time...
0
by: Pravin Pujari | last post by:
Hi All, I am using .net framework 1.1 and c#. I have one problem regarding dataview. I have one dataview to which sorting may be applied or may not be applied. I have one UI component where I...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.