how can I add a new column to an existing csv file using asp.net c#

Question

0.00/5 (No votes)

See more:

There is an existing csv file, with few columns and corresponding rows. a new column containing newly generated unique IDs(pulled from SQL Server) have to be added as the last column.

I used AppendAllText method of String builder. But it wont append the column at the end instead it will add the new column and its contents below the existing data.

Please help me with this.
Thank you.

Posted 13-Aug-14 23:32pm

Happy_soul

Updated 13-Aug-14 23:36pm

v2

Add a Solution

Comments

superselector 14-Aug-14 6:54am

Would Suggest you to
1. export the csv file to DataTable
2. create a new datatable with only one column ID and add the values
3. Merge the datatables
4. Import the newly created datatable to csv file

Happy_soul 14-Aug-14 7:35am

Thank you for response!
Yes m using the same logic,but i m not finding the proper code.
if i merge the old datatable with new one, m facing two problems :
1. the new column wont append properly in the datatable
2. if any columns are having date then automatically end up getting timestamps while they are posted in csv file. i don want timestamps
Can u please send me the code to merge the column in datatable with existing CSV.

1 solution

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)

Gihan Liyanage · Answer 1 · 2014-08-14T00:56:00

Solution 1

See whether You have the answer on this link

http://forums.asp.net/t/1979251.aspx?Add+new+column+in+existing+CSV+file+using+C+[^]

Or you can use code project article

C# CSV Reader and Writer[^]

Posted 14-Aug-14 0:56am

Gihan Liyanage

Comments

Happy_soul 14-Aug-14 7:36am

Thank you for responding!
I have checked those links. it was not useful. :(