简单的xml读写

利用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格式