473,883 Members | 1,730 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

group by in dataview

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 best way to do it?
Currently, I am sorting them and reading each row and comparing
current row's col1 and col2 with previous row's col1 and col2 and
keeping the total in an arraylist. But this is very slow; I am pretty
new to C#, any help is appreciated.

Thanks.
Nov 15 '05 #1
4 25021
Hello,

Unfortunately, you have said nothing about the source of the data. If this
is some kind of database, it would be much better to perform the grouping by
using the database means, such as 'GROUP BY' SQL clause.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"luke" <lu*****@yahoo. com> wrote in message
news:87******** *************** ***@posting.goo gle.com...
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 best way to do it?
Currently, I am sorting them and reading each row and comparing
current row's col1 and col2 with previous row's col1 and col2 and
keeping the total in an arraylist. But this is very slow; I am pretty
new to C#, any help is appreciated.

Thanks.


Nov 15 '05 #2
Hi luke,

AFAIK this is the only way.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"luke" <lu*****@yahoo. com> wrote in message
news:87******** *************** ***@posting.goo gle.com...
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 best way to do it?
Currently, I am sorting them and reading each row and comparing
current row's col1 and col2 with previous row's col1 and col2 and
keeping the total in an arraylist. But this is very slow; I am pretty
new to C#, any help is appreciated.

Thanks.

Nov 15 '05 #3
I am rading in filenames from a folder and filling a table out of
their parsed name. Eg, abcde.txt would be put into table where 'a' is
a column, so as b,c,d and e. Now, I need to know how many files that
match columna and columnc exist and get their total. I hope I am being
clear ...

Thanks.
"Dmitriy Lapshin [C# / .NET MVP]" <x-****@no-spam-please.hotpop.c om> wrote in message news:<uo******* *******@TK2MSFT NGP09.phx.gbl>. ..
Hello,

Unfortunately, you have said nothing about the source of the data. If this
is some kind of database, it would be much better to perform the grouping by
using the database means, such as 'GROUP BY' SQL clause.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"luke" <lu*****@yahoo. com> wrote in message
news:87******** *************** ***@posting.goo gle.com...
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 best way to do it?
Currently, I am sorting them and reading each row and comparing
current row's col1 and col2 with previous row's col1 and col2 and
keeping the total in an arraylist. But this is very slow; I am pretty
new to C#, any help is appreciated.

Thanks.

Nov 15 '05 #4
Luke,
I hope I am being
clear ... Not really, are you saying you are parsing each position of the name into a
distinct DataTable column? You do realize that file names can be upto 256
characters so you would need 256 columns?

I would consider defining "parent" tables for your grouping (one for each
grouping), then as I am adding rows to the first DataTable, update the
"parent" datatable with new values. I would also define relationships
between these datatables, so I could use the DataRow.GetChil dRows method...

DataTables:
G1 : c1
G2 : c1, c2
G3 : c1, c2, c3

D : c1, c2, c3, c4

c1, c2, c3 & c4 are columns, while G1, G2, & G3 are my grouping tables, & D
is your existing DataTable.

Hope this helps
Jay

"luke" <lu*****@yahoo. com> wrote in message
news:87******** *************** **@posting.goog le.com... I am rading in filenames from a folder and filling a table out of
their parsed name. Eg, abcde.txt would be put into table where 'a' is
a column, so as b,c,d and e. Now, I need to know how many files that
match columna and columnc exist and get their total. I hope I am being
clear ...

Thanks.
"Dmitriy Lapshin [C# / .NET MVP]" <x-****@no-spam-please.hotpop.c om> wrote

in message news:<uo******* *******@TK2MSFT NGP09.phx.gbl>. ..
Hello,

Unfortunately, you have said nothing about the source of the data. If this is some kind of database, it would be much better to perform the grouping by using the database means, such as 'GROUP BY' SQL clause.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"luke" <lu*****@yahoo. com> wrote in message
news:87******** *************** ***@posting.goo gle.com...
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 best way to do it?
Currently, I am sorting them and reading each row and comparing
current row's col1 and col2 with previous row's col1 and col2 and
keeping the total in an arraylist. But this is very slow; I am pretty
new to C#, any help is appreciated.

Thanks.

Nov 15 '05 #5

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

Similar topics

0
1591
by: RPI_alum | last post by:
I've been experiencing some frustrating behavior that I believe may be a MS bug in the Framework. Has anyone else experienced this, know a better way to resolve it, or if it is an actual MS bug *) I have a DataSet containing 2 tables, A and B *) There is a 1-to-1 relation between the tables with table A being the parent. (ABrel *) A DataView is created on table A to allow filtering of the result se *) 2 Text Boxes are created and Bound...
5
14299
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 know how to do grouping in XML. I have a dataset table which i would like to supposedly run the following sql statement on: Select UserID from tblAccounts
2
3317
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 the selected lie item at which case I would pop up a separate dialog box to do so, in the debugging code, the dataview.count would return 0. I get a error message because I tried to get values out of a dataview that holds 0 items. Does anyone...
1
1766
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: Begin -- General
36
4496
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 dataview with a count = 0. Can someone explain why and how I might work around this problem? Here is the code for my function: Public Shared Function GetViewFromRS(ByVal pRS As ADODB.Recordset) _ As DataView
13
2125
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 the confusion......... I thought that the DataView is the view from the dataset, but it seems that the dataview has the records that are in the datagrid, because everytime I search for a record that I know is NOT in the dataset, it finds it. I...
5
3969
by: enceladus311 | last post by:
I'm trying to find a way to keep from having to fill a DataView after every PostBack to a page. Basically, the design is that I have a DataView that I fill, which I then set as the DataSource to a DataGrid on my page. This works well, however, like I said, I would like to keep from having to fill the DataView on each PostBack. So, naturally, what I did was checked whether or not the request was a PostBack by checking the IsPostBack...
2
1627
by: frostbb | last post by:
The following code works great in C# Net 1.0 & Net 1.1 apps ... doesn't work for Net 2.0 apps. Cannot get pDg.IsSelected(i) to toggle to 'true' for 'highlighted' rows in a DataGrid control. private int CountSelectedDataGridRows(DataGrid pDg) { int i = 0;
0
2158
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 am displaying the dataview. All rows in dataview are displayed in the sequence as they appear in dataview. i.e. there is direct mapping between dataview rows and UI rows. I have subscribed ColumnChanged event of the datatable on which dataview is...
0
9781
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10734
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10407
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9567
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7960
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7114
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5982
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4211
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3230
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.