Search:   Namespaces Discussions .NET v1.1 Feedback

Group By Substitute and DataView Messages   Related Types This message was discovered on microsoft.public.dotnet.languages.vb. Post a new message to this list... 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 Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com