1,105,644 Community Members

Save Datagridview contents

Member Avatar
Huntondoom
Light Poster
47 posts since Jul 2010
Reputation Points: -4 [?]
Q&As Helped to Solve: 5 [?]
Skill Endorsements: 0 [?]
 
0
 

hey,
I have tried many methods to save my datagridview contents to a file
but with no luck
does anybody have a good method for xml to datagridview, datagridview to Xml,
or any other methods to read/write a datagridview

Member Avatar
ÜnLoCo
Light Poster
40 posts since Dec 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 8 [?]
Skill Endorsements: 0 [?]
 
0
 

i did it once and it worked fine
i remember i did row1:cell;cell;cell|row2:cell;cell;cell ...
you can choose any other delimiter
than use the split method to reload the text into the dgrid.

Member Avatar
Huntondoom
Light Poster
47 posts since Jul 2010
Reputation Points: -4 [?]
Q&As Helped to Solve: 5 [?]
Skill Endorsements: 0 [?]
 
0
 

oh so for each row you create a line (of string),
thnx!

ps: I created this with the information for saving:

Dim content As String
        For I As Integer = 0 To DataGridView1.Rows.Count
            For J As Integer = 0 To DataGridView1.ColumnCount
                content = content & ";" & DataGridView1.Rows(I).Cells(J).Value.ToString
            Next
            content = content & vbCrLf
        Next
Member Avatar
ÜnLoCo
Light Poster
40 posts since Dec 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 8 [?]
Skill Endorsements: 0 [?]
 
0
 

use for each .. it's better i think
note: be careful with the delimiters .. only use chars you don't use in the cell contents like "#" or "|" or maybe "^"

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: