how to change xml node property by c# code

[ronlahav]

Dear all

i Wonder how can i edit a node property (in C# not by hand :) )

i have the follwing XMl file (hibernate.cfg. xml)

[html]<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhib ernate-configuration-2.0" >
<session-factory name="NHibernat e.Test">
<!-- properties -->
<property name="connectio n.provider">NHi bernate.Connect ion.DriverConne ctionProvider</property>
<property name="connectio n.driver_class" >NHibernate.Dri ver.OracleDataC lientDriver</property>
<property name="connectio n.connection_st ring">User ID=th;password= manager;Data Source=th02;Per sist Security Info=False</property>
<property name="show_sql" >true</property>
<property name="dialect"> NHibernate.Dial ect.Oracle9Dial ect</property>
<property name="use_outer _join">true</property>
<property name="query.sub stitutions">tru e 1, false 0, yes 'Y', no 'N'</property>
<!-- mapping files -->
<mapping assembly="Pla.P er"/>
<mapping assembly="Int.P er"/>
<mapping assembly="Pen.M ap"/>

</session-factory>
</hibernate-configuration>[/html]



i want to change dynamically the connection.conn ection_string string property

thanks alot

ron

NOTE: Please add code or html tags to samples. Thanks, moderator.

[dorinbogdan]

Welcome to TheScripts TSDN...

You may use XMLDocument class.
See these links:
Manipulate XML data with XPath and XmlDocument
and
Modify XML Data by Using DOM in .NET Framework

You need to use SelectSingleNod e() method and to update the InnerText property of the selected XmlNode. Then call the Save() method.

I hope to succeed. Otherwise, let us know.

[ronlahav]

OK
for note this is the code which i wrote

XmlDocument xmlDoc = new XmlDocument();
 
xmlDoc.Load("hibernate.cfg.xml");
 
XmlNamespaceManager nm = new XmlNamespaceManager(xmlDoc.NameTable);
 
nm.AddNamespace("HC", "urn:nhibernate-configuration-2.0");
 
XmlNode node = xmlDoc.SelectSingleNode("//HC:session-factory[@name='NHibernate.Test']/HC:Property[@name='connection.connection_string']",nm);
 
node.InnerText = "New Value";
 
xmlDoc.Save("hibernate.cfg.xml");

but i have all the time node = null that means that something in the Xpath Query is incorrect
Ron

Welcome to TheScripts TSDN...

You may use XMLDocument class.
See these links:
Manipulate XML data with XPath and XmlDocument
and
Modify XML Data by Using DOM in .NET Framework

You need to use SelectSingleNod e() method and to update the InnerText property of the selected XmlNode. Then call the Save() method.

I hope to succeed. Otherwise, let us know.

[dorinbogdan]

use property, not Property, to look like this:

xmlDoc.SelectSingleNode("//HC:session-factory[@name='NHibernate.Test']/HC:property[@name='connection.connection_string']",nm);
 

[ronlahav]

Wow - you are amazing - how could i resolve this problem????!?!! ? (you cant debug Xpath)
i will recommand you to be an XML MVP :)

use property, not Property, to look like this:

xmlDoc.SelectSingleNode("//HC:session-factory[@name='NHibernate.Test']/HC:property[@name='connection.connection_string']",nm);
 

[dorinbogdan]

Thanks,
You're welcome.
God bless you.
Dorin.