Databases
StackOverflow2013
Postsdbo
PORemove nodes and child nodes from an XmlDocument Object based on attribute match
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORemove nodes and child nodes from an XmlDocument Object based on attribute match
    primarykey
    data
    text
    <p>I have an xml file with Hierarchical data I am loading that into XmlDocument object all is well until now, what I want to do now is remove all nodes and child nodes except the one that have an attribute of </p> <blockquote> <p>AssetSysID="6288"</p> </blockquote> <p>I am unsure of how to achieve this task any help is appreciated. Code for binding data to treeview:</p> <pre><code> XmlDataSource xDS = new XmlDataSource(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc = WTLIB.WTDAL.Legacy.DataTools.AssetList_XML(rcmbAssetType.SelectedValue); if (xmlDoc != null) { #region Grid Filters if (Request.QueryString["grid"] == null) { // Grid launched from Asset Screen if (Request.QueryString["AssetSysID"] == null) hdnGridAssetSysID.Value = "AssetSysID=" + "6288"; // Request.QueryString["AssetSysID"]; LoadGridData(xmlDoc); } #endregion xDS.Data = xmlDoc.InnerXml; xDS.XPath = "/xml/AMASM"; xDS.EnableCaching = false; // bind to treeview rtrvAMASM.Visible = true; rtrvAMASM.DataSource = xDS; rtrvAMASM.DataBind(); } else { rtrvAMASM.Visible = false; } } else { xDS = null; xmlDoc = null; rtrvAMASM.Visible = false; } </code></pre> <p>Xml:</p> <pre><code>&lt;xml&gt; &lt;AMASM AssetSysID="6288" Asset_ID="786387126" FROMLR="0.0000" Assets="786387126,(Facilities) , ( to ) Big tower-to-,Facilities"&gt; &lt;AMACI ACISysID="10201" PAssetSysID="6288" Features="Sign, On the door" /&gt; &lt;AMACI ACISysID="10115" PAssetSysID="6288" Features="Roof, Roof, NE corner" /&gt; &lt;WMITM ITMSysID="5267" Equipment="220033,Truck #33"&gt; &lt;AMSRQI SRQSysID="40" WorkOrders="E00006," /&gt; &lt;AMSRQI SRQSysID="41" WorkOrders="E00007," /&gt; &lt;AMSRQI SRQSysID="402" WorkOrders="E52,JDTest1" /&gt; &lt;AMSRQI SRQSysID="603" WorkOrders="E0130,Wash" /&gt; &lt;AMSRQI SRQSysID="656" WorkOrders="E0183,Program Error" /&gt; &lt;AMSRQI SRQSysID="712" WorkOrders="E0239,Program Error" /&gt; &lt;AMSRQI SRQSysID="986" WorkOrders="E0293,Testing Single Quote" /&gt; &lt;AMSRQI SRQSysID="1534" WorkOrders="E0295," /&gt; &lt;AMSRQI SRQSysID="1548" WorkOrders="E0296,Testing Extra fields" /&gt; &lt;AMSRQI SRQSysID="1589" WorkOrders="E0299,Testing Extra fields" /&gt; &lt;AMSRQI SRQSysID="1590" WorkOrders="30-2,Testing Extra fields" /&gt; &lt;AMSRQI SRQSysID="2179" WorkOrders="PW12-00011,OilChange2" /&gt; &lt;AMSRQI SRQSysID="2299" WorkOrders="30-3,Testing Extra fields" /&gt; &lt;AMSRQI SRQSysID="2310" WorkOrders="30-4,Testing Extra fields" /&gt; &lt;/WMITM&gt; &lt;AMSRQI SRQSysID="1534" WorkOrders="E0295," /&gt; &lt;AMSRQI SRQSysID="1548" WorkOrders="E0296,Testing Extra fields" /&gt; &lt;AMSRQI SRQSysID="656" WorkOrders="E0183,Program Error" /&gt; &lt;AMSRQI SRQSysID="712" WorkOrders="E0239,Program Error" /&gt; &lt;AMSRQI SRQSysID="1589" WorkOrders="E0299,Testing Extra fields" /&gt; &lt;AMSRQI SRQSysID="1590" WorkOrders="30-2,Testing Extra fields" /&gt; &lt;AMSRQI SRQSysID="2165" WorkOrders="A00506,Test Inser" /&gt; &lt;AMSRQI SRQSysID="2166" WorkOrders="A00507," /&gt; &lt;AMSRQI SRQSysID="2167" WorkOrders="A00508,Test" /&gt; &lt;AMSRQI SRQSysID="2299" WorkOrders="30-3,Testing Extra fields" /&gt; &lt;AMSRQI SRQSysID="2310" WorkOrders="30-4,Testing Extra fields" /&gt; &lt;AMFLI FLISysID="15" Floors="First Floor,Ground Level"&gt; &lt;AMRMI RMISysID="21" Rooms="101,Admin Office"&gt; &lt;AMSRQI SRQSysID="2165" WorkOrders="A00506,Test Inser" /&gt; &lt;AMSRQI SRQSysID="2166" WorkOrders="A00507," /&gt; &lt;AMSRQI SRQSysID="2167" WorkOrders="A00508,Test" /&gt; &lt;/AMRMI&gt; &lt;AMRMI RMISysID="22" Rooms="102,Security Office" /&gt; &lt;AMRMI RMISysID="23" Rooms="103,Men's Washroom" /&gt; &lt;AMRMI RMISysID="24" Rooms="104,Women's Washroom" /&gt; &lt;/AMFLI&gt; &lt;/AMASM&gt; &lt;AMASM AssetSysID="6715" Asset_ID="HFBuild" FROMLR="0.0000" Assets="HFBuild,(Facilities) , High Falls Building,Facilities"&gt; &lt;AMACI ACISysID="10132" PAssetSysID="6715" Features="" /&gt; &lt;AMACI ACISysID="10133" PAssetSysID="6715" Features="" /&gt; &lt;AMACI ACISysID="10134" PAssetSysID="6715" Features="" /&gt; &lt;/AMASM&gt; &lt;AMASM AssetSysID="6750" Asset_ID="F2000" FROMLR="0.0000" Assets="F2000,(Facilities) , Survey,Facilities" /&gt; &lt;/xml&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDeveloper
    1. USDeveloper
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COCan you share your input xml? Is there any requirement about using XmlDocument, rather than say XDocument?
      singulars
      1. PORemove nodes and child nodes from an XmlDocument Object based on attribute match
      1. USRyan Gates
    2. CO@Ryan: basically there is coding after that also(only some times this condition of certain assetsys id applies other times all xml data is needed using this on treeview) so because of that I don't want to touch the flow of the program or change the main object which is binding data to tree view
      singulars
      1. PORemove nodes and child nodes from an XmlDocument Object based on attribute match
      1. USDeveloper
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload