using System;
using System.Data;
using System.IO;

namespace ConsoleApplication1
{
    public class Program
    {
        static void Main(string[] args)
        {
            DataSet myDataSet = GetMyCSVFileData();
            foreach (DataColumn MyDataColumn in myDataSet.Tables["MyDataTable"].Columns)
            {
                Console.Write("{0,-20}", MyDataColumn.ColumnName);
            }
            Console.WriteLine();

            foreach (DataRow MyDataRow in myDataSet.Tables["MyDataTable"].Rows)
            {
                foreach (DataColumn c in myDataSet.Tables["MyDataTable"].Columns)
                {
                    Console.Write("{0,-20}", MyDataRow[c]);
                }
                Console.WriteLine();
            }
        }

        private static DataSet GetMyCSVFileData()
        {
            string MystringLine;
            string[] MystringArray;
            char[] charArray = new char[] { ',' };
            DataSet MyDataSet = new DataSet();
            DataTable MyDataTable = MyDataSet.Tables.Add("TheData");
            FileStream MyFileStrema = new FileStream("Mycsvfile.txt", FileMode.Open);
            StreamReader MyStreamReader = new StreamReader(MyFileStrema);

            MystringLine = MyStreamReader.ReadLine();

            MystringArray = MystringLine.Split(charArray);

            for (int i = 0; i <= MystringArray.GetUpperBound(0); i++)
            {
                MyDataTable.Columns.Add(MystringArray[i].Trim());
            }

            MystringLine = MyStreamReader.ReadLine();
            while (MystringLine != null)
            {
                MystringArray = MystringLine.Split(charArray);
                DataRow dr = MyDataTable.NewRow();
                for (int i = 0; i <= MystringArray.GetUpperBound(0); i++)
                {
                    dr[i] = MystringArray[i].Trim();
                }
                MyDataTable.Rows.Add(dr);
                MystringLine = MyStreamReader.ReadLine();
            }
            MyStreamReader.Close();
            return MyDataSet;
        }
    }
}