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:nhibernate-configuration-2.0" >
<session-factory name="NHibernate.Test">
<!-- properties -->
<property name="connection.provider">NHibernate.Connection.D riverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.O racleDataClientDriver</property>
<property name="connection.connection_string">User ID=th;password=manager;Data Source=th02;Persist Security Info=False</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.Oracle9Dialect</property>
<property name="use_outer_join">true</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<!-- mapping files -->
<mapping assembly="Pla.Per"/>
<mapping assembly="Int.Per"/>
<mapping assembly="Pen.Map"/>

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



i want to change dynamically the connection.connection_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 SelectSingleNode() 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 SelectSingleNode() 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.