How to write to\delete from XML file from textboxes in asp.net

sachi vasishta

Hi All,

I have a following XML file(auto.xml)

Pending Fault found on
Repaired Fault on
// the value entered in textboxes should be written here

in aspx page I have 2 textboxes and a button. Suppose I enter 'Checking fault on' in first textbox and 'Already checked' in second textbox and click on the add button, then the first value should be added as the third node value and the second textbox value should be added as the attribute value.

i.e., the xml file should look like this

Pending Fault found on
Repaired Fault on
Checking Fault on

And also how to delete that node from XML ? i.e., if I click on delete button then that node should be removed from the XML file.

Thanks,
Sachi

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
OK, this code should remove the node which is displayed:

XElement auto = XElement.Load("auto4.xml");
XElement findNode = (from node in auto.Element("fault").Elements("text") where node.Value == text1 && node.Attribute("selectedvalue").Value == text2 select node).FirstOrDefault();
if (findNode != null)
{
findNode.Remove();
auto.Save("auto4.xml");
textBox1.Text = "";
textBox2.Text = "";
}

However, editing is tricky because, after you've edited it, you won't be able to find which node has been updated!

What you could do is to have two buttons, Edit and Commit. When the Edit button is pressed, you enter edit mode and get the node which is currently displayed as we did for deletion above.

When the Commit button is pressed, you exit edit mode and commit the changes to that node.

An alternative approach would be to arrange matters so that you always have a reference to whichever node is currently displayed though I don't know whether this would be feasible in the context of your application.
0
sachi vasishta15y ago
Thanks Vulpes.

Yes, 'selectedvalue' is a single word.

coming to the second part , my UI will display the node and its attribute value like below.(node and its attribute value will be shown in textboxes)

node1value        node1attributevalue        editbutton        deletebutton
node2value        node2attributevalue        editbutton        deletebutton
node3value        node3attributevalue        editbutton        deletebutton

example:
Pending fault found on        Pending fault        editbutton        delbutton

now if I click on delete button then that node(in my sample xml file, the first node under fault element) info should be removed from the UI as well as from the XML file, and if I edit one of the textboxes or both and click on edit button ,then the edited value should appear in UI as well as in XML file of that particular node.
0
Sam Hobbs15y ago
Where is the XML file? Is it in the server or the client?

Note that there are many ways to read and write XML.
0
Vulpes15y ago
Assuming that the attribute should be 'selectedvalue' (i.e. no space between words), then the code to do the first part would be:

XElement auto = XElement.Load("auto.xml");
XElement fault = auto.Element("fault");
XElement text = new XElement("text", new XAttribute("selectedvalue", TextBox2.Text), Text.Box1.Text);
fault.Add(text);
auto.Save("auto.xml"); // if you want to save immediately to disk

Regarding the second part, how do you know which node should be removed? Will it always be the last one added?
0