public static ListSetRepairsXML()
{
Listlist = new List ();
string RepairsXMLPath = ConfigurationManager.AppSettings["RespairsXMLPath"];
if (!File.Exists(RepairsXMLPath))//如果文件不存在,则创建
{
string strfinename = RepairsXMLPath;
XmlTextWriter xmlWriter = new XmlTextWriter(strfinename, Encoding.Default);
xmlWriter.Formatting = Formatting.Indented;
xmlWriter.WriteStartDocument();
xmlWriter.WriteStartElement("Employees");
xmlWriter.Close();
return list;
}
XmlDocument doc = new XmlDocument();
doc.Load(RepairsXMLPath); //加载Xml文件
XmlElement rootElem = doc.DocumentElement; //获取根节点
XmlNodeList personNodes = rootElem.GetElementsByTagName("Node"); //获取Employees子节点集合
foreach (XmlNode node in personNodes)
{
StudentRepairsMassage student = new StudentRepairsMassage();
XmlElement xml = (XmlElement)node;
XmlNodeList xml1 = xml.ChildNodes;
student.title = xml1.Item(0).InnerText;
student.id = xml1.Item(1).InnerText;
student.address = xml1.Item(2).InnerText;
student.article = xml1.Item(3).InnerText;
student.message = xml1.Item(4).InnerText;
list.Add(student);
}
return list;
}
}
public class StudentRepairsMassage
{
public string title { get; set; }
public string id { get; set; }
public string address { get; set; }
public string article { get; set; }
public string message { get; set; }
}
这是读取xml的,写入sql就用先ADO.NET,然后sql写入,不知道就直接动软吧
xml文件中的节点有没有Attribute?