How do I get added rows from datagridview to XML file and load it again

Question

0.00/5 (No votes)

See more:

I have a DataGridView, which have manually added columns (meaning entered via DataGridView and not code), I want to know how I can simply save added rows from textboxes to XML files by a button, so they can save and load when the user opens the application again.

This is what my form is looking like for reference (if it helps):
General Task List - Album on Imgur[^]

Thanks!

What I have tried:

The code below is what I used to add the textbox/combobox properties to the table it self.

VB

Private Sub btnAddTask_Click(sender As Object, e As EventArgs) Handles btnAddTask.Click
    ' PURPOSE: To add a New Task to the General Task List
    ' INPUTS: Task Name (as text), Task Tags (as text), Priority Level (as Integer), Due Date (as Date), Helpful Link (as text), Note Entry (as text)
    ' OUTPUTS: Present entered properties on dataGVGeneral
    'Adds the Task Properties into new row in dataGVGeneral
    Dim dgvGeneralRow As Object() = New Object() {Nothing, txtTaskName.Text, txtTaskTags.Text, cmbPriority.SelectedItem.ToString(), dateDUE.Value.ToShortDateString(), txtLink.Text, txtNoteEntry.Text}
    dataGVGeneral.Rows.Add(dgvGeneralRow)
    txtTaskName.Text = ""
    txtTaskTags.Text = ""
    txtLink.Text = ""
    txtNoteEntry.Text = ""
End Sub

Posted 21-Jul-20 14:12pm

Shaheer Rizwan

Updated 21-Jul-20 15:36pm

Patrice T

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Answer 1 · 2020-07-21T15:36:00

Quote:
how I can simply save

well, I guess it depends on your definition of 'simply' doesn't it ?

My definition of 'simply' would be using a datatable and the methods it already has ...

'Setup, somewhere, maybe Init
'Create backing data-table
Dim dt As New DataTable("Src")
dt.Columns.Add("task", GetType(String))
dt.Columns.Add("tags", GetType(String))
dt.Columns.Add("priority", GetType(Integer))
' .. and so forth
'Add datatable as datagridview's data source
'Assuming datagridview's name is dgv (original, not)
dgv.DataSource = dt;
'

'As part of Save Event from button click or such
Dim file = "c:\somedirectory\someotherdirectory\tasks.xml"
dt.WriteXml(file, XmlWriteMode.WriteSchema)


'Maybe as part of Form Load event/Setup
'Assuming dt and file defined 
dt.ReadXml(file

But your definition of 'Simple' may vary - the 'Setup/Init' section I've demonstrated could be combined with the 'maybe as part of Form Load event/Setup' obviously - my intent is more to make you aware of the methods the DataTable Class provides, rather than a 're-invent the wheel' approach