CsvReader : How to go to the beginning

[sylvaincaillot]

I need to do extract the headers of a csv and then load this csv into a datatable and I am struggle with how the memory objects are allocated:
Initially, I have tried

using (StreamReader reader = new StreamReader(filePath, Encoding.UTF8))
using (CsvReader csv1 = new CsvReader(reader, csvConfig))
{
    csv1.Read();
    csv1.ReadHeader();
    string[] headers = csv1.HeaderRecord;   
   if (headers[0].Replace("\0", "").ToUpper() == "TEST")
   {
        using (var dr1 = new CsvDataReader(csv1))
        {
            var dt1 = new DataTable();
            dt1.Load(dr1);
        }    
    }
}

It didn't work for the datatable as the headers row was skipped.

I then tried to add reader1.BaseStream.Position = 0; with no effect.

I then tried to add a distinct CsvReader for the datatable:

using (StreamReader reader1 = new StreamReader(filePath, Encoding.UTF8))            
            using (CsvReader csv1 = new CsvReader(reader1, csvConfig1))
            using (CsvReader csv2 = new CsvReader(reader1, csvConfig1))
            {
                csv1.Read();
                csv1.ReadHeader();

                string[] headers = csv1.HeaderRecord;

                //reader1.BaseStream.Position = 0;
               
                using (var dr1 = new CsvDataReader(csv2))
                {
                    var dt1 = new DataTable();
                    dt1.Load(dr1);       
                }               
            }

Then I got weird result with CSV1 containing 9 columns while dt1 only contains 4 columns. So again some memory allocations problems.
The only way it works is by adding a distinct StreamReader for the datatable like:

using (StreamReader reader1 = new StreamReader(filePath, Encoding.UTF8))
            using (StreamReader reader2 = new StreamReader(filePath, Encoding.UTF8))
            using (CsvReader csv1 = new CsvReader(reader1, csvConfig1))
            using (CsvReader csv2 = new CsvReader(reader2, csvConfig1))
            {
                csv1.Read();
                csv1.ReadHeader();

                string[] headers = csv1.HeaderRecord;

                //reader1.BaseStream.Position = 0;
               
                using (var dr1 = new CsvDataReader(csv2))
                {
                    var dt1 = new DataTable();
                    dt1.Load(dr1);       
                }               
            }

It looks quite counter-productive and memory consuming for such a simple need.

How can I make sure that I go at the beginning of my CsvHeader before filling my datatable?

[vasagle-gleblu]

Have you tried reader.BaseStream.Seek(0, SeekOrigin.Begin); or reader.BaseStream.Position = 0 ?