Why does the returned DataTable has readonly columns in FileHelpers

Question

I am wondering why filehelpers return readonly columns.

I had a huge problem with them not updating values and could not figure out why. Now I have to have another loop to go through all the columns and change them to be not readonly.

Is there a way I can tell Filehelpers to not do this? So I don't have to waste time going through all of it again?

Aloysia

datatable.column[0].readonly = false fixes the problem – Jeramey

Answer 1

The FileHelpers class RecordOperations.CreateEmptyDataTable() method is responsible for this and it is not virtual.

I think the reason might be that it is similar to using a normal DataReader via DataTable.Load(IReader) which would also create readonly rows.

However, it is easy to fix by going through the columns instead of the rows:

foreach (DataColumn col in dt.Columns) 
    col.ReadOnly = false;

Inside

Ya I know I can go through them all and make them non readonly but was wondering if there was an option or something that would save me from having to iterate over them just to do this. – Aloysia