Delete empty cells in CSV files

You could alter it so that empty fields would contain DBNull.Value instead of null or an empty string, though we'll need to rejig the code a bit (untested):

private static DataTable GetDataTabletFromCSVFile1(string csv_file_path1)
{
   DataTable table2 = new DataTable("Real");
   try
   {
      using (TextFieldParser csvReader1 = new TextFieldParser(csv_file_path1))
      {
         csvReader1.SetDelimiters(new string[] { "," });
         csvReader1.HasFieldsEnclosedInQuotes = true;
         string[] colFields = csvReader1.ReadFields();
         foreach (string column in colFields)
         {
            DataColumn datecolumn2 = new DataColumn(column);
            datecolumn2.AllowDBNull = true;
            table2.Columns.Add(datecolumn2);
         }
         while (!csvReader1.EndOfData)
         {
            string[] fieldData1 = csvReader1.ReadFields();
            DataRow dr = table2.Rows.Add(fieldData1);
            for (int i = 0; i < fieldData1.Length; i++)
            {
               if (String.IsNullOrEmpty(fieldData1[i])) dr[i] = DBNull.Value;
            }
         }  
      }
   }
   catch (Exception ex)
   {
     MessageBox.Show("Select New File");
     return null;
   }
   return table2;
}