How to Search through an xml file and edit the results

Question

4.00/5 (1 vote)

See more:

Hi
Can anyone help me out with how to search through an xml file and then edit the results, for example here is my how my xml file looks like below :

XML

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<GroupPosts>
  <IndividualPosts>
    <PostID>0</PostID>
    <StudentID>106</StudentID>
    <PostTitle>Math Problems</PostTitle>
    <PostDescription>How Do i study</PostDescription>
  </IndividualPosts>

  <IndividualPosts>
    <PostID>1</PostID>
    <StudentID>0</StudentID>
    <PostTitle>I  have passed</PostTitle>
    <PostDescription>i studied harder</PostDescription>
  </IndividualPosts>

<IndividualPosts>
    <PostID>3</PostID>
    <StudentID>3</StudentID>
    <PostTitle>How to solve math problems</PostTitle>
    <PostDescription>i studied harder</PostDescription>
  </IndividualPosts>


</GroupPosts>

What I want to do is this, search through the file using the postId element, retrieve the results and and the edit those results and save the changes to that file. The searching part i have no problem. But how do I edit the search results and save the changes to that file. Here is my code for searching:

public  void getPost(string grpName, int i)
       {
           XmlReader xmlFile;
           xmlFile = XmlReader.Create("fileName.xml", new XmlReaderSettings());
           DataSet ds = new DataSet();
           DataView dv;
           ds.ReadXml(xmlFile);

           dv = new DataView(ds.Tables[0]);
           dv.Sort = "PostID";
           int index = dv.Find("3");



           listBox1.Items.Add(dv[index]["PostID"].ToString());
           listBox1.Items.Add(dv[index]["StudentID"].ToString());
           listBox1.Items.Add(dv[index]["PostDescription"].ToString());
            listBox1.Items.Add(dv[index]["PostTitle"].ToString());


       }

How do I edit the results save the changes to that same file and how do I go about it, if anyone were to provide me with useful links that might help me I would really appreciate it. Thanks in advance

Posted 11-Apr-13 22:05pm

sijimann

Add a Solution

Comments

Shine Ashraf 12-Apr-13 4:48am

Please try below code after editing the dataset

int index = dv.Find("3");
//Editing
dv[index]["PostTitle"] = "Edited";

//Saving
ds.AcceptChanges();
xmlFile.Close();
ds.WriteXml("fileName.xml");

2 solutions

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)

H.Brydon · Answer 1 · 2013-04-12T06:48:00

You want to transform the xml using xsl/xslt and perform the identity transform on all data except for the data you want to change. Add an xslt rule for the data you want changed and (duh) make the change there.

The identity transform looks like:

XML

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:template match="@*|*|processing-instruction()|comment()">
    <xsl:copy>
      <xsl:apply-templates select="@*|*|text()|processing-instruction()|comment()"/>
    </xsl:copy>
  </xsl:template>
</xsl:stylesheet>

[The only things this transform will not preserve are formatting, white space or CDATA but that does not seem to be an issue for the data you present here.]

Pallavi Waikar · Answer 2 · 2013-04-12T07:02:00

it will be easy using linq try this code before add reference

using System.Xml.Linq;

string xmlFileName = @"fileName.xml";
            XDocument XmlDoc = XDocument.Load(xmlFileName);
            List<XElement> XmlElements = (from fx in XmlDoc.Root.DescendantsAndSelf("IndividualPosts") where (((fx.Element("PostID").Value == "3")) select fx).ToList();
            foreach (XElement gg in XmlElements)
            {
                gg.Element("PostID").Value = "addNewValue1";
                gg.Element("StudentID").Value = "addNewValue2";
                gg.Element("PostDescription").Value = "addNewValue3";
                gg.Element("PostTitle").Value = "addNewValue4";
            }
            XmlDoc.Save(xmlFileName);

also to know xml and linq operation refer following link..
http://www.dotnetcurry.com/ShowArticle.aspx?ID=564[^]

How to Search through an xml file and edit the results

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0