How to open and read .csv file and store as array

Question

Hello I am new to C#  how can I open and read .csv file and store it as an array in Console application using c#. thanks .

Rajeesh Menoth · Answer

Hi using System . IO ; static void Main ( string [] args ) { var reader = new StreamReader ( File . OpenRead ( @C:	est.csv )); List listA = new List (); List listB = new List (); while (! reader . EndOfStream ) { var line = reader . ReadLine (); var values = line . Split ( ';' ); listA . Add ( values [ 0 ]); listB . Add ( values [ 1 ]); } } Reference : http://stackoverflow.com/questions/5282999/reading-csv-file-and-storing-values-into-an-array

solya merto · Answer

Thanks Rajeesh . I did like that but the .csv file I want to open have 36 columns  I need something like loop statement  how can I use loop statement .