Can someone answer this for me?

Posted by Dcurvez on Stack Overflow See other posts from Stack Overflow or by Dcurvez
Published on 2010-04-29T21:25:45Z Indexed on 2010/04/29 21:27 UTC
Read the original article Hit count: 146

Filed under:
|
|

okay I am totally stuck.

I have been getting some help off and on throughout this project and am anxious to get this problem solved so I can continue on with the rest of this project.

I have a gridview that is set to save to a file, and has the option to import into excel. I keep getting an error of this:

Invalid cast exception was unhandled. At least one element in the source array could not be cast down to the destination array type.

Can anyone tell me in layman easy to understand what this error is speaking of?

This is the code I am trying to use:

Dim fileName As String = ""
    Dim dlgSave As New SaveFileDialog
    dlgSave.Filter = "Text files (*.txt)|*.txt|CSV Files (*.csv)|*.csv"
    dlgSave.AddExtension = True
    dlgSave.DefaultExt = "txt"
    If dlgSave.ShowDialog = Windows.Forms.DialogResult.OK Then
        fileName = dlgSave.FileName
        SaveToFile(fileName)
    End If
End Sub
Private Sub SaveToFile(ByVal fileName As String)
    If DataGridView1.RowCount > 0 AndAlso DataGridView1.Rows(0).Cells(0) IsNot Nothing Then
        Dim stream As New System.IO.FileStream(fileName, IO.FileMode.Append, IO.FileAccess.Write)
        Dim sw As New System.IO.StreamWriter(stream)
        For Each row As DataGridViewRow In DataGridView1.Rows
            Dim arrLine(9) As String
            Dim line As String
            **row.Cells.CopyTo(arrLine, 0)**
            line = arrLine(0)
            line &= ";" & arrLine(1)
            line &= ";" & arrLine(2)
            line &= ";" & arrLine(3)
            line &= ";" & arrLine(4)
            line &= ";" & arrLine(5)
            line &= ";" & arrLine(6)
            line &= ";" & arrLine(7)
            line &= ";" & arrLine(8)
            sw.WriteLine(line)
        Next
        sw.Flush()
        sw.Close()

    End If

I bolded the line where it shows in debug, and I really dont see what all the fuss is about LOL

© Stack Overflow or respective owner

Related posts about visual

Related posts about studio