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 7453
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |