//create the table
DataTable dt = new DataTable("Import");
dt.Columns.Add("col1", typeof(string));
dt.Columns.Add("col2", typeof(string));
dt.Columns.Add("col3", typeof(string));
 
//read the data
using (StreamReader sr = new StreamReader(filepath))
{
    int i = 0;
    while (!sr.EndOfStream)
    {
        //skip the header
        while (i < 1)
        {
            sr.ReadLine();
            i++;
        }
 
        string[] text = sr.ReadLine().Split(',');
        DataRow dr = dt.NewRow();
        dr["col1"] = text[0];
        dr["col2"] = text[1];
        dr["col3"] = text[2];
 
        dt.Rows.Add(dr);
    }
}

public static DataTable ParseCSV(string filePath)
{
    if (!File.Exists(filePath))
    {
        return null;
    }
 
    string fileName = Path.GetFileName(filePath);
    string dirName = Path.GetDirectoryName(filePath);
 
    //connection string 
    string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source="" + dirName + "\";" + "Extended Properties="text;HDR=No;FMT=Delimited"";
    string query = "SELECT * FROM " + fileName;
 
    DataTable dt = new DataTable();
    OleDbDataAdapter adapter = new OleDbDataAdapter(query, connString);
 
    try
    { 
        adapter.Fill(dt);
    }
    catch (InvalidOperationException)
    { }
 
    adapter.Dispose();
 
    return dt;
}