Meghana M

Meghana M

  • 1.6k
  • 175
  • 23.2k

how to add timestamp for csv file using C#

Mar 13 2023 8:53 PM

code:

string path=@"c:\file"; 

try{

command.CommandText = "dbo.SpSample";
                command.CommandType = CommandType.StoredProcedure;
                dataAdapter = new SqlDataAdapter(command.CommandText, connect);
                dataAdapter.Fill(dataSet, "dbo.SpSample");
                DataTable t2 = dataSet.Tables["dbo.SpSample"];

                string csv2 = string.Empty;

                foreach (DataColumn column in t2.Columns)
                {
                    csv2 += column.ColumnName + ',';
                }
                csv2 += "\r\n";
                foreach (DataRow row in t2.Rows)
                {
                    foreach (DataColumn column in t2.Columns)
                    {
                        csv2 += row[column.ColumnName].ToString().Replace(",", ";") + ',';
                    }
                    csv2 += "\r\n";
                }
                File.WriteAllText(exportPath + DateTime.Now + "Sample1.csv", csv2);

}

catch (Exception e){}

code is working fine but if i add timestamp in file.writealltext method getting error 

timeformat(11/1/2023 12:00) should be like this


Answers (2)