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