CSV header with period character C# datatable

Question

0.00/5 (No votes)

See more:

Hi all,

I am trying to parse CSV file to a datatable using this code:

C#

//create the "database" connection string
      string connString = "Provider=Microsoft.Jet.OLEDB.4.0;"
        + "Data Source=\"" + dir + "\\\";"
        + "Extended Properties=\"text;HDR=Yes;FMT=Delimited\"";
      //create the database query
      string query = "SELECT * FROM " + file;
      //create a DataTable to hold the query results
      DataTable dTable = new DataTable();
      //create an OleDbDataAdapter to execute the query
      OleDbDataAdapter dAdapter =
         new OleDbDataAdapter(query, connString);
      try
      {
        //fill the DataTable
        dAdapter.Fill(dTable);
      }
      catch (InvalidOperationException /*e*/)
      { }

First line of the CSV file is defined as a header. There is a column named "Time Point 0.5(s)" in the header. When parsing it to the datatable, the column appeared as "Time Point 0#5(s)". The "." character becomes "#" character. This does not happen if the row is not header. How can I solve this problem?

Regards,

Posted 6-Aug-11 13:57pm

Anh Chu

Add a Solution

2 solutions

Solution 2

Hi,

Thank you for your reply. I did read those articles before, however, I would love to know the reason behind this problem, why "." character becomes "#" character as if it is in header row. While in the data row, it is fine.

Thanks,

Posted 6-Aug-11 15:47pm

Anh Chu

Comments

Wonde Tadesse 6-Aug-11 22:14pm

Answer updated.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wonde Tadesse · Accepted Answer · 2011-08-06T15:33:00

Have a look at this [^]blog. This is other way converting CSV into datatable. It might solve your problem. In addition to this you can try the this[^] CSV parser.

[EDITED]

This because, if you want try to bind your DataTable with such column it might throw exception due to (.) period character. For example if you try to bind the converted CSV records to DataBinder with Eval Method, it will throw exception. So to minimize such exception DataTable will convert the Column Name to other special character. See this[^] link for further.