XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(Server.MapPath("CNCity.xml"));
XmlNodeList nodeList = xmlDoc.SelectSingleNode("resources").ChildNodes;//获取resources节点的所有子节点
DataTable dts = null;
foreach (XmlNode xn in nodeList)
{
XmlElement xe = (XmlElement)xn;
if (xe.Name == "province")
{
XmlNodeList nls = xe.ChildNodes;
foreach (XmlNode xn1 in nls)
{
XmlElement xe2 = (XmlElement)xn1;//转换类型
string cityName = xe2.InnerText; //获取节点名称
//将DataTable 的表结构 数据复制到另外一个DataTable 中
DataTable d = bcn.GetCNByNowWeaNull(cityName);
if (dts == null)//累计复制时需要判断
{
dts = d.Clone();
}
if (d.Rows.Count > 0)
{
DataRow dr = d.Rows[0];
dts.ImportRow(dr);
}
}
}
}