xml创建
string sql = "select rentid from lesseeRent "; DataTable dt= MDGL.DBUtility.SQLServerHelper.GetDataTable(CommandType.Text,sql); //创建一个xml文档 XmlDocument xmlDoc = new XmlDocument(); //声明,一个节点 XmlNode xmlNode = xmlDoc.CreateNode(XmlNodeType.XmlDeclaration,"",""); xmlDoc.AppendChild(xmlNode); //注释 XmlComment xmlComment = xmlDoc.CreateComment("rentID列表"); xmlDoc.AppendChild(xmlComment); //创建根元素 XmlElement xmlEle = xmlDoc.CreateElement("rentIDList"); xmlDoc.AppendChild(xmlEle); //创建子元素 XmlElement xmlEle2; foreach(DataRow dr in dt.Rows) { xmlEle2 = xmlDoc.CreateElement("rentID"); XmlText xmlText = xmlDoc.CreateTextNode(dr["rentID"].ToString()); xmlEle2.AppendChild(xmlText);//子元素添加文本内容 xmlEle.AppendChild(xmlEle2);//父元素添加子元素 } xmlDoc.Save("D:\\b.xml");//xml文档存储
//写xml string sql = "select rentid from lesseeRent "; DataTable dt= MDGL.DBUtility.SQLServerHelper.GetDataTable(CommandType.Text,sql); //创建一个xml文档 XmlDocument xmlDoc = new XmlDocument(); StringBuilder str = new StringBuilder(); str.Append("<?xml version=\"1.0\" ?>"); str.Append("<rentList>"); foreach (DataRow dr in dt.Rows) { str.Append("<rentID>"); str.Append(dr["rentID"].ToString()); str.Append("</rentID>"); } str.Append("</rentList>"); xmlDoc.LoadXml(str.ToString()); xmlDoc.Save("D:\\a.xml");