export to CSV from datagridview with date format

Question

i want to save the datagridview data to CSV but dont know the idea to chang the date format from 2022/03/07 00:00 to
2022/03/07.

 private void button7_Click(object sender, EventArgs e)
    {

    try
         {
             string csv = string.Empty;
             string HeaderText = string.Empty;
            foreach (DataGridViewColumn column in tableDataGridView.Columns)
                {
                    csv += column.HeaderText + ',';

                }
                csv += "\r\n";
                foreach (DataGridViewRow row in tableDataGridView.Rows)
                {
                   foreach (DataGridViewCell cell in row.Cells)
                       {
                           if (cell.Value != null)

                            {

          csv += cell.Value.ToString()/*.TrimEnd(',')*//*.Replace(",", ";") */+ /*','*/",";


                        }

                    }
                    csv += "\r\n";
                }


                string folderPath = "C:\\CSV\\";
                if (!Directory.Exists(folderPath))
                {
                    Directory.CreateDirectory(folderPath);
                }

                {


                 File.WriteAllText(folderPath + DateTime.Now.ToString("yyyyMMdd_HH-mm-ss") + ".csv", csv, Encoding.UTF8);


                    textBox3.Text = "保存しました";
                    textBox3.BackColor = Color.Green;
                }
            }

Answer 1

@denesh neupane , based on my test, I suggest that you don't use 2022/03/07 the format in the path. Becuase windows limit that the file name can not contain the / character.
You could check it manually as the following:

If you still want to use datetime formart to name the path, I suggest that you could use the following code:

File.WriteAllText(folderPath + DateTime.Now.ToString("yyyy-MM-dd") + ".csv", csv, Encoding.UTF8);  

Like the following pic:

---

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.