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 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
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
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
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
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
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
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 > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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:...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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...
|
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...
| |