How to handle null or conversion exception while convert byte[] to datatable using csvhelper.

See more:

C#

I am trying to convert byte array values to datatable using csv helper.

When any null values comes means it shows the below error

The conversion cannot be performed.\r\n    Text: 'NULL'\r\n

Once it read

using (TextReader fs = new StreamReader(new MemoryStream(data)))
            {
                lines = new CsvReader(fs, csvConfig).GetRecords<T>().ToList();
            }

not having any records in lines.

How to handle this?

What I have tried:

public static DataTable ReadCSVbyteData<T>(byte[] data, string delimiter, bool hasHeaderRecord, bool hasRowCountEOF)
       {
           List<T> lines;
           var csvConfig = new CsvConfiguration(CultureInfo.InvariantCulture)
           {
               Delimiter = delimiter,
               HasHeaderRecord = hasHeaderRecord,
               MissingFieldFound = null
           };

           using (TextReader fs = new StreamReader(new MemoryStream(data)))
           {
               lines = new CsvReader(fs, csvConfig).GetRecords<T>().ToList();
           }

           if (hasRowCountEOF)
           {
               if (lines.Any())
                   lines.RemoveAt(lines.Count - 1);
           }

           string str = JsonConvert.SerializeObject(lines);

           return JsonConvert.DeserializeObject<DataTable>(str);
       }