How to delete a specific Element/node based on attrribute value??
In the below example, i need to delete Node NAME whose ID=3 ??
How do i delete it?
Ex:
<Data>
<Name id="1"></Name>
<Name id="2"></Name>
<Name id="3"></Name>
<Name id="4"></Name>
</Data>
Thanks
Vinay
-- http://pathidotnet.blogspot.com
=====
vInAypAtHi
o__
---_,>/'_------
(_) \(_)
--------------- 6 1310
It all depends on what you want to delete it FROM. XML is, after all,
extensible, and it can be used in a large variety of ways. There are a large
variety of classes for working with XM:L, and they have quite a bit in
common, and quite a bit different. So a little context would help.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.
"vinay" <vi***@discussions.microsoft.com> wrote in message
news:76**********************************@microsof t.com... How to delete a specific Element/node based on attrribute value?? In the below example, i need to delete Node NAME whose ID=3 ?? How do i delete it?
Ex: <Data> <Name id="1"></Name> <Name id="2"></Name> <Name id="3"></Name> <Name id="4"></Name> </Data>
Thanks Vinay
-- http://pathidotnet.blogspot.com ===== vInAypAtHi o__ ---_,>/'_------ (_) \(_) ---------------
Can you give some snippet?
I am trying to use .NET XML namespace classes.
I have an XMLNodeList based on "/Data/Name"
I am looping thru Name elements..
-- http://pathidotnet.blogspot.com
=====
vInAypAtHi
o__
---_,>/'_------
(_) \(_)
---------------
"Kevin Spencer" wrote: It all depends on what you want to delete it FROM. XML is, after all, extensible, and it can be used in a large variety of ways. There are a large variety of classes for working with XM:L, and they have quite a bit in common, and quite a bit different. So a little context would help.
-- HTH,
Kevin Spencer Microsoft MVP ..Net Developer Ambiguity has a certain quality to it.
"vinay" <vi***@discussions.microsoft.com> wrote in message news:76**********************************@microsof t.com... How to delete a specific Element/node based on attrribute value?? In the below example, i need to delete Node NAME whose ID=3 ?? How do i delete it?
Ex: <Data> <Name id="1"></Name> <Name id="2"></Name> <Name id="3"></Name> <Name id="4"></Name> </Data>
Thanks Vinay
-- http://pathidotnet.blogspot.com ===== vInAypAtHi o__ ---_,>/'_------ (_) \(_) ---------------
use an xpath query to find the element, then remove it.
XmlNode node = doc.DocumentElement.SelectSingleNode('//Name[@id=3]");
node.ParentNode.RemoveChild(node);
-- bruce (sqlwork.com)
"vinay" <vi***@discussions.microsoft.com> wrote in message
news:76**********************************@microsof t.com... How to delete a specific Element/node based on attrribute value?? In the below example, i need to delete Node NAME whose ID=3 ?? How do i delete it?
Ex: <Data> <Name id="1"></Name> <Name id="2"></Name> <Name id="3"></Name> <Name id="4"></Name> </Data>
Thanks Vinay
-- http://pathidotnet.blogspot.com ===== vInAypAtHi o__ ---_,>/'_------ (_) \(_) ---------------
Bruce
Thats works great !!
I have one more Q
I am getting this XML some other source.
I am not sure the attribute values are Lower case or Upper case??
when i do the xPath query, it is looking for exact match.
How to avoid the case sensitive problem??
Thanks
Vinay
-- http://pathidotnet.blogspot.com
=====
vInAypAtHi
o__
---_,>/'_------
(_) \(_)
---------------
"Bruce Barker" wrote: use an xpath query to find the element, then remove it.
XmlNode node = doc.DocumentElement.SelectSingleNode('//Name[@id=3]"); node.ParentNode.RemoveChild(node);
-- bruce (sqlwork.com)
"vinay" <vi***@discussions.microsoft.com> wrote in message news:76**********************************@microsof t.com... How to delete a specific Element/node based on attrribute value?? In the below example, i need to delete Node NAME whose ID=3 ?? How do i delete it?
Ex: <Data> <Name id="1"></Name> <Name id="2"></Name> <Name id="3"></Name> <Name id="4"></Name> </Data>
Thanks Vinay
-- http://pathidotnet.blogspot.com ===== vInAypAtHi o__ ---_,>/'_------ (_) \(_) ---------------
XmlNode node = doc.DocumentElement;
for (int i = 0; i < node.ChildNodes.Count; i++)
{
if (node.ChildNodes[i].Attributes.Count > 0)
{
XmlNode n = node.ChildNodes[i];
for (ii = 0; ii < n.Attributes.Count; ii++)
if (n.Attributes[ii].Name.ToLower() == "id" &&
n.Attributes[ii].Value == "3")
{
node.ParentNode.RemoveChild(n);
break;
}
}
}
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.
"vinay" <vi***@discussions.microsoft.com> wrote in message
news:BF**********************************@microsof t.com... Bruce
Thats works great !!
I have one more Q
I am getting this XML some other source. I am not sure the attribute values are Lower case or Upper case??
when i do the xPath query, it is looking for exact match.
How to avoid the case sensitive problem??
Thanks Vinay
-- http://pathidotnet.blogspot.com ===== vInAypAtHi o__ ---_,>/'_------ (_) \(_) ---------------
"Bruce Barker" wrote:
use an xpath query to find the element, then remove it.
XmlNode node = doc.DocumentElement.SelectSingleNode('//Name[@id=3]"); node.ParentNode.RemoveChild(node);
-- bruce (sqlwork.com)
"vinay" <vi***@discussions.microsoft.com> wrote in message news:76**********************************@microsof t.com... > How to delete a specific Element/node based on attrribute value?? > In the below example, i need to delete Node NAME whose ID=3 ?? > How do i delete it? > > Ex: > <Data> > <Name id="1"></Name> > <Name id="2"></Name> > <Name id="3"></Name> > <Name id="4"></Name> > </Data> > > Thanks > Vinay > > -- > http://pathidotnet.blogspot.com > ===== > vInAypAtHi > o__ > ---_,>/'_------ > (_) \(_) > ---------------
You can also look at this sample at:- http://aspnet.4guysfromrolla.com/articles/112603-1.aspx
Hope that helps
Patrick
"vinay" <vi***@discussions.microsoft.com> wrote in message
news:76**********************************@microsof t.com... How to delete a specific Element/node based on attrribute value?? In the below example, i need to delete Node NAME whose ID=3 ?? How do i delete it?
Ex: <Data> <Name id="1"></Name> <Name id="2"></Name> <Name id="3"></Name> <Name id="4"></Name> </Data>
Thanks Vinay
-- http://pathidotnet.blogspot.com ===== vInAypAtHi o__ ---_,>/'_------ (_) \(_) --------------- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: William C. White |
last post by:
Does anyone know of a way to use PHP /w Authorize.net AIM without using
cURL? Our website is hosted on a shared drive and the webhost company
doesn't installed additional software (such as cURL)...
|
by: Albert Ahtenberg |
last post by:
Hello,
I don't know if it is only me but I was sure that header("Location:url")
redirects the browser instantly to URL, or at least stops the execution of
the code. But appearantely it continues...
|
by: James |
last post by:
Hi,
I have a form with 2 fields.
'A'
'B'
The user completes one of the fields and the form is submitted.
On the results page I want to run a query, but this will change
subject to which...
|
by: Ollivier Robert |
last post by:
Hello,
I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9
system. The link succeeds but everytime I try to run php, I get a SEGV from
inside the libcnltsh.so library.
...
|
by: Richard Galli |
last post by:
I want viewers to compare state laws on a single subject.
Imagine a three-column table with a drop-down box on the top. A viewer
selects a state from the list, and that state's text fills the...
|
by: Albert Ahtenberg |
last post by:
Hello,
I have two questions.
1. When the user presses the back button and returns to a form he filled
the form is reseted. How do I leave there the values he inserted?
2. When the...
|
by: inderjit S Gabrie |
last post by:
Hi all
Here is the scenerio ...is it possibly to do this...
i am getting valid course dates output on to a web which i have designed
....all is okay so far , look at the following web url
...
|
by: Jack |
last post by:
Hi All,
What is the PHP equivilent of Oracle bind variables in a SQL statement, e.g.
select x from y where z=:parameter
Which in asp/jsp would be followed by some statements to bind a value...
|
by: Sandwick |
last post by:
I am trying to change the size of a drawing so they are all 3x3.
the script below is what i was trying to use to cut it in half ... I
get errors.
I can display the normal picture but not the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |