Loading

Read data from CSV File

Abdul Basit

Dear sir,

I want to read data from csv file by using c# console appliation. if user enter word like politics and the result searched as poltics and how many time word politics used.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Thavaselvan Palanivel8y ago
1. bool isheader = true;
2. var reader = new StreamReader(File.OpenRead(@"test.csv"));
3. List headers = new List();
4. while (!reader.EndOfStream)
5. {
6. var line = reader.ReadLine();
7. var values = line.Split(',');
8. if (isheader){isheader = false;
9. headers = values.ToList();
10. }
11. else
12. {
13. int i=0;
14. for (i = 0; i < values.Length; i++)
15. {
16. Console.Write(string.Format("{0} = {1};", headers[i], values[i]));
17. }
18. Console.WriteLine();
19. }