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? — Brian
– Brian, Commented May 28, 2013 at 20:57
Why not read the whole file, map it to a class and do the filtering there? — simple-thomas
– simple-thomas, Commented May 28, 2013 at 20:58
I have tryedDataRow[] foundRows; foundRows = dataSet1.Tables["Customers"].Select("Age Like 'A%'"); — bali katravella
– bali katravella, Commented May 29, 2013 at 20:18

Community · Accepted Answer · 2017-05-23 12:18:52Z

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, 2017 at 12:18

CommunityBot

11 silver badge

answered May 28, 2013 at 21:02

Hauke P.

2,8531 gold badge23 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read rows with specific value from csv file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related