xml导入导出

来源：互联网发布：js正则截取字符串编辑：程序博客网时间：2024/05/16 05:28

导入

stream stream=file.openread(server.mappath("xml.xml"));

xdocument document=xdocument.load(stream);

using (SqlConnection con=new SqlConnection(str))
        {
            con.Open();
            using (SqlCommand cmd=con.CreateCommand())
            {

foreach(xelement element in document.root.descendants("mail"))

{

                        string receive = item.Element("receivemai").Value;
                    string senders = item.Element("sendermail").Value;
                    string title = item.Element("title").Value;
                    string content = item.Element("content").Value;
                    cmd.CommandText = "insert into mailxml(receivemail,sendermail,title,content) values('"+receive+"','"+senders+"','"+title+"','"+content+"'"+")";
                   cmd.ExecuteNonQuery();
                   stream.Flush();

}

导出

using (SqlConnection con=new SqlConnection(str))
        {
            using (SqlCommand cmd=con.CreateCommand())
            {
                cmd.CommandText = "select * from mailxml";
                con.Open();
               SqlDataReader reader=cmd.ExecuteReader();

XElement xml=new xElement("xml");

XElement mail=new XElement("mail");

sqldatareader reader=cmd.executereader();

while(reader.Read())

{

                         XElement receivemail = new XElement("receivemail", "'"+reader[1].ToString()+"'");
                XElement sendermail = new XElement("sendermail","'"+reader[2].ToString()+"'");
                XElement title = new XElement("title","'"+reader[3].ToString());
                XElement content = new XElement("content","'"+reader[4].ToString()+"'");
                mail.Add(receivemail);
                mail.Add(sendermail);
                mail.Add(title);
                mail.Add(content);

}

xml.Add(mail);

stream stream=file.openWrite("f:\\mail.xml");

streamwrite write=new streamwrite(stream);

write.writeline(xml.tostring());

保持初学者的心态！！！

}