利用datatable 简单的xml读写
string str = "select top 5 * from AD where adType='轮换'";
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnectionStringCdsh, CommandType.Text, str);
XmlDocument doc = new XmlDocument();
doc.Load(Server.MapPath("../web/xml/viewerData.xml"));
XmlNode slectNode=doc.SelectSingleNode("viewer");
foreach (XmlNode node in slectNode.SelectNodes("item"))
{
slectNode.RemoveChild(node);//移除子节点
}
//重新读取数据写入xml
foreach (DataRow row in ds.Tables[0].Rows)
{
XmlElement e1 = doc.CreateElement("item");
e1.SetAttribute("title",row[1].ToString());
e1.SetAttribute("img","../"+row[3].ToString());
e1.SetAttribute("url", row[2].ToString());
e1.SetAttribute("target", "_blank");
slectNode.AppendChild(e1);
}
doc.Save(Server.MapPath("../web/xml/viewerData.xml"));
轮换广告的xml格式