read multiple csv data in c#

Hi, i have question

How to write the code for read multiple csv file in a folder and display it in console ?

For right now, i can only do read one file for example:

string path = (@"C:\ipub\root\Book1.csv");
string[] lines = System.IO.File.ReadAllLines(path);

foreach (string line in lines)
{
    Console.WriteLine(line);
    string[] columns = line.Split(',');

      foreach (string column in columns)
      {
        Console.WriteLine("Kandungan : " + column);
        }
}

please help me, thank you

im using visual studio 2019,c#

2 Replies

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

Jenith Thakkar6y ago
Accepted answer
Hi

foreach (string path in Directory.EnumerateFiles(@"C:\ipub\root", "*.csv"))
{
string[] lines = System.IO.File.ReadAllLines(path);

foreach (string line in lines)
{
Console.WriteLine(line);
string[] columns = line.Split(',');
foreach (string column in columns)
{
Console.WriteLine("Kandungan : " + column);
}
}
}

you can do it in this way

If it works then accept it
6y ago
Thank you so much Jenith, it works, really appreciate your help