XML Dataset (ASP.net)

[levyuk]

Hi,

I have a number of questions.

How do I add a new entry to my xml file?
Can I search an XML file for an entry?
This is my current xml file

[size=2][color=#0000ff]<?[/color][/size][size=2][color=#800000]xml[/color][/size][size=2][color=#0000ff] [/color][/size][size=2][color=#ff0000]version[/color][/size][size=2][color=#0000ff]=[/color][/size][size=2]"[/size][size=2][color=#0000ff]1.0[/color][/size][size=2]"[/size][size=2][color=#0000ff] [/color][/size][size=2][color=#ff0000]standalone[/color][/size][size=2][color=#0000ff]=[/color][/size][size=2]"[/size][size=2][color=#0000ff]yes[/color][/size][size=2]"[/size][size=2][color=#0000ff]?>

<[/color][/size][size=2][color=#800000]Customers[/color][/size][size=2][color=#0000ff]>

<[/color][/size][size=2][color=#800000]Customer[/color][/size][size=2][color=#0000ff]>

<[/color][/size][size=2][color=#800000]id[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]1[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]id[/color][/size][size=2][color=#0000ff]>

<[/color][/size][size=2][color=#800000]name[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]Jonathan[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]name[/color][/size][size=2][color=#0000ff]>

<[/color][/size][size=2][color=#800000]age[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]23[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]age[/color][/size][size=2][color=#0000ff]>

</[/color][/size][size=2][color=#800000]Customer[/color][/size][size=2][color=#0000ff]>

<[/color][/size][size=2][color=#800000]Customer[/color][/size][size=2][color=#0000ff]>

<[/color][/size][size=2][color=#800000]id[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]2[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]id[/color][/size][size=2][color=#0000ff]>

<[/color][/size][size=2][color=#800000]name[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]Kate[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]name[/color][/size][size=2][color=#0000ff]>

<[/color][/size][size=2][color=#800000]age[/color][/size][size=2][color=#0000ff]>[/color][/size][size=2]20[/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]age[/color][/size][size=2][color=#0000ff]>

</[/color][/size][size=2][color=#800000]Customer[/color][/size][size=2][color=#0000ff]>

</[/color][/size][size=2][color=#800000]Customers[/color][/size][size=2][color=#0000ff]>

[/color][/size]

And my current code

[size=2][/size][size=2][color=#0000ff]Protected[/color][/size][size=2] [/size][size=2][color=#0000ff]Sub[/color][/size][size=2] Button1_Click([/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] sender [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Object[/color][/size][size=2], [/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] e [/size][size=2][color=#0000ff]As[/color][/size][size=2] System.EventArgs) [/size][size=2][color=#0000ff]Handles[/color][/size][size=2] Button1.Click

[/size][size=2][color=#0000ff]Dim[/color][/size][size=2] ds [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]New[/color][/size][size=2] DataSet

ds.ReadXml(Server.MapPath([/size][size=2][color=#800000]"XMLFile.xml"[/color][/size][size=2]))

Response.Write(ds.Tables(0).Rows(1).Item([/size][size=2][color=#800000]"name"[/color][/size][size=2]))

Response.Write([/size][size=2][color=#800000]" "[/color][/size][size=2] & ds.Tables(0).Rows(1).Item([/size][size=2][color=#800000]"age"[/color][/size][size=2]))

ds.WriteXml(Server.MapPath([/size][size=2][color=#800000]"XMLFile.xml"[/color][/size][size=2]))

[/size][size=2][color=#0000ff]End[/color][/size][size=2] [/size][size=2][color=#0000ff]Sub

[/color][/size]

How can I select the row that I want based on the id that is entered?
Also how could I add to this XML file. For instance if i had 3 textboxes, id, name, age. How could I then add them to the end of the xml file?
Thanks

 

[jmcilhinney]

Once your data is in a DataSet you don't need to worry about the XML. You select a row in a table using DataRowCollection.Find() and you add a new row to your DataTable/DataSet that will then be reflected in the XML file after you call WriteXml.