Read XML file

[Alan T]

This is my xml file content:

<?xml version="1.0"?>
<server>
<mssqlChicago >
<host>www.chica goserver.com</host>
<user>manager A</user>
<password>ceoma n</password>
<db>dbCEO</db>
</mssqlChicago>
<mssqlLA>
<host>www.LAser ver.com</host>
<user>manager B</user>
<password>lam an </password>
<db>dbLAWork</db>
</mssqlLA>
</server>

Any sample code to read these 2 nodes from the xml file?

[dursun caglar]

Hi there is a solution reading xml file to add dataset (i think u want
that)

private XmlDocument myDoc = new XmlDocument();
private DataSet myDs;

//Using XmlElement you can access
//host ,user etc. values
//just write myElemet.GetAtt ribute("host"); or whatever u want to take
private XmlElement myElemet;
private void LoadDataGrid()
{
myDs = new DataSet();
myDs.ReadXml("m yXML.xml");
dataGrid1.DataS ource = myDs.Tables[0];
}
private void LoadXML(){
myDoc.Load("you r_file.xml");
}
private void Form1_Load(obje ct sender, System.EventArg s e){
LoadDataGrid();
LoadXML();
}
Alan T yazdi:

This is my xml file content:

<?xml version="1.0"?>
<server>
<mssqlChicago >
<host>www.chica goserver.com</host>
<user>manager A</user>
<password>ceoma n</password>
<db>dbCEO</db>
</mssqlChicago>
<mssqlLA>
<host>www.LAser ver.com</host>
<user>manager B</user>
<password>lam an </password>
<db>dbLAWork</db>
</mssqlLA>
</server>

Any sample code to read these 2 nodes from the xml file?

[Tiago Salgado]

Try something like this:

XmlDocument xdoc = new XmlDocument();
xdoc.Load(Appli cation.StartupP ath + "\\xml.xml" );
XmlNodeList nodes = xdoc.SelectNode s("server");

foreach(XmlNode node in nodes)
{
//print node["mssqlChica go"].ChildNodes["host"].InnerText)
//print node["mssqlChica go"].ChildNodes["user"].InnerText)
//print
node["mssqlChica go"].ChildNodes["password"].InnerText)
//print node["mssqlChica go"].ChildNodes["db"].InnerText)
}
--

Tiago Salgado

http://weblogs.pontonetpt.com/tiagosalgado
http://www.foruns.org
http://www.portugal-a-programar.org
http://www.revista-programar.info

"Alan T" <al************ *@yahoo.com.auw rote in message
news:ON******** ******@TK2MSFTN GP04.phx.gbl...

This is my xml file content:

<?xml version="1.0"?>
<server>
<mssqlChicago >
<host>www.chica goserver.com</host>
<user>manager A</user>
<password>ceoma n</password>
<db>dbCEO</db>
</mssqlChicago>
<mssqlLA>
<host>www.LAser ver.com</host>
<user>manager B</user>
<password>lam an </password>
<db>dbLAWork</db>
</mssqlLA>
</server>

Any sample code to read these 2 nodes from the xml file?

[j1mb0jay]

You could also get by tag name if you really wanted.

JJ