User Profile

doubtful1 · Jun 3 '15, 01:12 PM

I want to add header for my .csv file.Code snippet is here.The problem is.my code only prints first heading on all columns.
Can you please help whats wrong.It only prints DeviceIdent in all columns.I want to see all columns in proper heading.

Code:

string fileLocation = @"C:\Data\Test.csv";

          
             if (!File.Exists(fileLocation))
                  {
                       File.Create(fileLocation).Close();

...

doubtful1 · Jun 2 '15, 12:24 PM

Hi,
i have program that retrieves data from database and writes to a .csv using c#.The test.csv has 7 columns.How to export data to specific ordinal columns only .I need to update only colums2,3,5and 6.

here's snippet code:

Code:

            using (SqlConnection con1 = new SqlConnection(ConnectionString))
            {
                con1.Open();
                SqlDataAdapter da =

...

User Profile

Profile Sidebar

add header for .csv

c# program to export data to .csv on specfic column only