XmlDocument XmlDoc=new XmlDocument();
XmlDoc.Load(@"E:\test.xml");string XPath="/Options/Option[@name='R25']";
XmlNode node=XmlDoc.DocumentElement.SelectSingleNode(XPath);
//1:返回有多少个Table
Console.WriteLine(node.ChildNodes.Count.ToString());
//2:返回每个Table的tableName
foreach(XmlNode TableNode in node.ChildNodes)
{ Console.WriteLine("---------------------"); Console.WriteLine(TableNode.Attributes["tableName"].Value);
//3:返回每个Table的columnName数组
foreach(XmlNode ColumnNode in TableNode.ChildNodes)
{
Console.WriteLine(ColumnNode.Attributes["columnName"].Value);
}
}
XmlDoc.Load(@"E:\test.xml");string XPath="/Options/Option[@name='R25']";
XmlNode node=XmlDoc.DocumentElement.SelectSingleNode(XPath);
//1:返回有多少个Table
Console.WriteLine(node.ChildNodes.Count.ToString());
//2:返回每个Table的tableName
foreach(XmlNode TableNode in node.ChildNodes)
{ Console.WriteLine("---------------------"); Console.WriteLine(TableNode.Attributes["tableName"].Value);
//3:返回每个Table的columnName数组
foreach(XmlNode ColumnNode in TableNode.ChildNodes)
{
Console.WriteLine(ColumnNode.Attributes["columnName"].Value);
}
}
FileStream file = new FileStream(Server.MapPath("XMLFile1.xml"),FileMode.Open,FileAccess.Read);
DataSet ds = new DataSet();
ds.ReadXml(file);