Exporting a datagridview to .csv

[jamesd0142]

Hey how do i go about exporting the contents of a datagridview to a .csv file.

can any point me in the right way?

Thanks

[debasisdas]

How you are polulating the datagrid ?

[jamesd0142]

Private Sub Write(ByVal header As String)
        Dim objStreamWriter As IO.StreamWriter
 
        'Pass the file path and the file name to the StreamWriter
        'constructor.
        'make sure this is a path that you have permissions to save in
 
        objStreamWriter = New IO.StreamWriter(txtPath.Text)
        'Write text.
 
        Dim Str As String
        Dim i As Integer
        Dim j As Integer
 
        Dim headertext = header
        objStreamWriter.WriteLine(headertext)
        For i = 0 To (Me.DGV1.Rows.Count - 2)
            For j = 0 To (Me.DGV1.Columns.Count - 1)
                'this IF statement stops it from adding a comma after
                'the last field
                If j = (Me.DGV1.Columns.Count - 1) Then
                    Str = (Me.DGV1.Rows(i).Cells(j).Value.ToString)
                Else
                    Str = (Me.DGV1.Rows(i).Cells(j).Value.ToString & ",")    '(Me.DGV1.Rows(i).Cells(j).Text.ToString & ",")
                End If
                objStreamWriter.Write(Str)
            Next
            objStreamWriter.WriteLine()
        Next
        'Close the file.
        objStreamWriter.Close()
    End Sub
 

thats the solution i have used... thanks