When I exporting datagridview to CSV ,Date format is changed like 9/17/2017 12:00:00 AM in CSV file,I want to trim it as 2017-9-17 .Please Help me
Dim headers = (From header As DataGridViewColumn In purchaseorderDGV.Columns.Cast(Of DataGridViewColumn)() _
Select header.HeaderText).ToArray
Dim rows = From row As DataGridViewRow In purchaseorderDGV.Rows.Cast(Of DataGridViewRow)() _
Where Not row.IsNewRow
Select Case Array.ConvertAll(row.Cells.Cast(Of DataGridViewCell).ToArray, Function(c) If(c.Value IsNot Nothing, c.Value.ToString, ""))
End Select
Using sw As New IO.StreamWriter("csv.txt")
sw.WriteLine(String.Join(",", headers))
For Each r In rows
sw.WriteLine(String.Join(",", r))
Next
End Using
Process.Start("csv.txt")