Read data from CSV File

Question

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.

Thavaselvan P · Answer

bool isheader = true ; var reader = new StreamReader(File.OpenRead(@ test.csv )); List headers = new List(); while (!reader.EndOfStream) { var line = reader.ReadLine(); var values = line.Split( '' ); if (isheader){isheader = false ; headers = values.ToList(); } else { int i=0; for (i = 0; i { Console.Write( string .Format( {0} = {1};  headers[i] values[i])); } Console.WriteLine(); }