Reading CSV file data into a DataTable using C#.Net

Today we will try reading a CSV file data into a DataTable using C#.Net.

The CSV file contains the data in the following format:-

1) The first row contains the column names

2) The data delimiter(separator) is Comma (",") for the columns.

The "CustomerDetails.csv" is placed in the Bin directory of the project


//initialising a StreamReader type variable and will pass the file location

StreamReader oStreamReader = new StreamReader("CustomerDetails.csv");

DataTable oDataTable = null;

int RowCount = 0;

string[] ColumnNames = null;

string[] oStreamDataValues=null;

//using while loop read the stream data till end

while (!oStreamReader.EndOfStream)

{

  String oStreamRowData = oStreamReader.ReadLine().Trim();

  if (oStreamRowData.Length > 0)

  {

    oStreamDataValues = oStreamRowData.Split(',');

    //Bcoz the first row contains column names, we will poluate 

    //the column name by

    //reading the first row and RowCount-0 will be true only once

    if (RowCount == 0)

    {

      RowCount = 1;

      ColumnNames = oStreamRowData.Split(',');

      oDataTable = new DataTable();

      //using foreach looping through all the column names

      foreach (string csvcolumn in ColumnNames)

      {

       DataColumn oDataColumn = new DataColumn(csvcolumn.ToUpper(), typeof(string));

      //setting the default value of empty.string to newly created column

      oDataColumn.DefaultValue = string.Empty;

      //adding the newly created column to the table

      oDataTable.Columns.Add(oDataColumn);

     }

    }

    else

    {

      //creates a new DataRow with the same schema as of the oDataTable            

      DataRow oDataRow = oDataTable.NewRow();

      //using foreach looping through all the column names

      for (int i = 0; i < ColumnNames.Length; i++)

      {

        oDataRow[ColumnNames[i]] = oStreamDataValues[i] == null ? string.Empty : oStreamDataValues[i].ToString();

      }

     

      //adding the newly created row with data to the oDataTable       

      oDataTable.Rows.Add(oDataRow);

    }

  }

}

//close the oStreamReader object

oStreamReader.Close();

//release all the resources used by the oStreamReader object

oStreamReader.Dispose();

//Looping through all the rows in the Datatable

foreach (DataRow oDataRow in oDataTable.Rows)

{

  string RowValues=string.Empty;

  //Looping through all the columns in a row

  foreach (string csvcolumn in ColumnNames)

  {

    //concatenating the values for display purpose

    RowValues += csvcolumn + "=" + oDataRow[csvcolumn].ToString()+";  ";

  }

  //Displaying the result on the console window

  Console.WriteLine(RowValues);

}

Happy Coding.......