How to read rows with specific value from csv file

Question

I have a sorted csv file. How to read just rows with ordered value and write them to datagridview.For example read just rows where value of Age is 22. the file looks like:

ID Name Surname Age Salary
1  John Asben   33  1000
2  Adam Smith   22  1200
3  Amanda J     22  2000
4  George Villis 36  2300

Just to be crystal clear, we will NOT write your code for you. So, that leads me to ask, [what have you tried](http://mattgemmell.com/2008/12/08/what-have-you-tried/)? — Brian, May 28 '13 at 20:57
Why not read the whole file, map it to a class and do the filtering there? — simple-thomas, May 28 '13 at 20:58
I have tryedDataRow[] foundRows; foundRows = dataSet1.Tables["Customers"].Select("Age Like 'A%'"); — bali katravella, May 29 '13 at 20:18

score 1 · Answer 1 · edited May 23 '17 at 12:18

1

About reading CSV files in .NET: Reading a CSV file in .NET?

Depending on the CSV parser type and the classes you'll get the CSV data in, you could apply a filter while parsing, apply a filter on the parsed data or add a View filter to the grid. I'm sure there are also other methods.

edited May 23 '17 at 12:18

Community

1
1

answered May 28 '13 at 21:02

Hauke P.

2,583
1
18
40

How to read rows with specific value from csv file

1 Answers1