Why does the returned DataTable has readonly columns in FileHelpers

c# .net filehelpers
chobo2 picture chobo2 · Feb 9, 2012 · Viewed 18.4k times · Source

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?

Answer

shamp00 picture shamp00 · Feb 12, 2012

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;

Related questions

How to use a dynamic CSV delimiter with FileHelpers?

Question: I need to read a CSV file. I use the FileHelpers library to achieve this. The problem is I need a dynamic delimiter (user defined), meaning anything can be delimiter (Comma, semicolon, tab, newline, but also anything else). The …

Read More
How to make an HTTP POST web request

Canonical How can I make an HTTP request and send some data using the POST method? I can do a GET request, but I have no idea of how to make a POST request.

Read More
How can I convert String to Int?

I have a TextBoxD1.Text and I want to convert it to an int to store it in a database. How can I do this?

Read More