September 6, 2008 01:03pm pdt

1. naspinski 52,450
2. Fernando... 44,300
3. CarlVerret 17,064
4. sjturner2 14,250
5. Ceiled 12,500
6. CMYScott 5,750
7. TheLearn... 5,172
8. Praesidium 4,664
9. GreenGho... 4,150
10. VBRocks 4,000
11. emoreau 3,050
12. gardavis 3,000
12. Dhaest 3,000
14. ZachSmith 2,600
15. boag2000 2,500
15. mark_wills 2,500
17. IndianOcean 2,000
17. vb_jonas 2,000
17. SwissKnife 2,000
17. vs1784 2,000
17. dstanley9 2,000
17. burakiewicz 2,000
17. primeMov... 2,000
17. JimFive 2,000
17. AaronNance 2,000
17. p_davis 2,000
17. REA_AN... 2,000
17. renjurdevan 2,000
17. cottsak 2,000
17. ad5qa 2,000
17. irps20001 2,000
17. Koocurrent 2,000
17. Rahu_ket... 2,000
17. ajitha75 2,000
17. Smart_Man 2,000

1. naspinski 52,450
2. Fernando... 44,300
3. sjturner2 20,250
4. CarlVerret 17,064
5. Ceiled 12,500
6. CMYScott 5,750
7. TheLearn... 5,172
8. Praesidium 4,664
9. GreenGho... 4,150
10. VBRocks 4,000
11. emoreau 3,050
12. gardavis 3,000
12. Dhaest 3,000
14. ZachSmith 2,600
15. mark_wills 2,500
15. boag2000 2,500
17. IndianOcean 2,000
17. Koocurrent 2,000
17. ajitha75 2,000
17. Rahu_ket... 2,000
17. p_davis 2,000
17. michtsoi 2,000
17. primeMov... 2,000
17. renjurdevan 2,000
17. ad5qa 2,000
17. SwissKnife 2,000
17. SteveH_UK 2,000
17. cottsak 2,000
17. vb_jonas 2,000
17. vs1784 2,000
17. dstanley9 2,000
17. burakiewicz 2,000
17. JimFive 2,000
17. AaronNance 2,000
17. REA_AN... 2,000
17. Smart_Man 2,000
17. irps20001 2,000

03.29.2008 at 05:49PM PDT, ID: 23280133

	[x] Attachment Details

LINQ Count rows in dataset with conditions

Asked by rdytmire in Language Integrated Query - LINQ, C# Programming Language

Tags: c#

Ok.. I've tried all the examples on MSDN and other sites but nothing seems to work.

I want to query a data table and find out how MANY rows match the selection criteria. using LINQ to dataset and c# /.net 3.5. How would I modify the query to return an int count.

Wrapping the whole select in a (...) refuses to work as it states the row type has no Count method.

var recordCount = from c in qADCMainDatabase.terrain_type_vs_unit_type_details.AsEnumerable()
where ((c.terrain_type_name == terrainType) &
(c.section_name == sectionName) &
(c.unit_type_name == unitTypeName))
select c;
Start Free Trial

Keywords: LINQ Count rows in dataset with condit…

	Title
1	VB.NET ADO.NET DataSet
2	DataSet Select
3	Display data from Dataset using conditi…
4	Dataset null or Clear
5	DataSet and DataGrid please tell me th…
6	Populating a dataset with a stored proc…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

LINQ Count rows in dataset with conditions

Asked by rdytmire in Language Integrated Query - LINQ, C# Programming Language

Tags: c#

About this solution