asp.net连接数据库操作xml文件(读、写)

最新推荐文章于 2013-04-12 17:18:00 发布

原创最新推荐文章于 2013-04-12 17:18:00 发布 · 512 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #数据库 #xml #string #sql #rss

本文介绍两种方法实现ASP.NET中从数据库提取数据并生成XML文件，同时展示了如何读取XML文件并将数据插入到数据库的过程。

asp.net中从数据库中取数据生成xml文件
方法一：
DB db = new DB();
        string sql = "select name,sex,age,hobby from stuinfo";
        DataTable dt = db.Select(sql);
        XmlDocument xmldoc = new XmlDocument();
        XmlElement rss = xmldoc.CreateElement("rss");
        rss.SetAttribute("Version", "1.0");
        XmlElement school = xmldoc.CreateElement("School");
        XmlElement grade = xmldoc.CreateElement("Grade");
        XmlElement[] student = new XmlElement[dt.Rows.Count];
        XmlElement[] name = new XmlElement[dt.Rows.Count];
        XmlElement[] sex = new XmlElement[dt.Rows.Count];
        XmlElement[] age = new XmlElement[dt.Rows.Count];
        XmlElement[] hobby = new XmlElement[dt.Rows.Count];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            student[i] = xmldoc.CreateElement("Student");
            name[i] = xmldoc.CreateElement("Name");
            sex[i] = xmldoc.CreateElement("Sex");
            age[i] = xmldoc.CreateElement("Age");
            hobby[i] = xmldoc.CreateElement("Hobby");
            name[i].InnerText = dt.Rows[i]["name"].ToString();
            sex[i].InnerText = dt.Rows[i]["sex"].ToString();
            age[i].InnerText = dt.Rows[i]["age"].ToString();
            hobby[i].InnerText = dt.Rows[i]["hobby"].ToString();
            student[i].AppendChild(name[i]);
            student[i].AppendChild(sex[i]);
            student[i].AppendChild(age[i]);
            student[i].AppendChild(hobby[i]);
            grade.AppendChild(student[i]);
            school.AppendChild(grade);
            rss.AppendChild(school);
            xmldoc.AppendChild(rss);
        }
        xmldoc.Save("D:/StuInfo.xml");

方法二：
DB db = new DB();
        string sql = "select name,sex,age from stuinfo";
        DataTable dt = db.Select(sql);
        dt.TableName = "Student";
        dt.WriteXml("D:/StuInfo.xml");

asp.net中将xml文件里面的数据往数据库中添加
stu.xml文件的内容如下：

操作方法：
int res = 0;
        DB db = new DB();
        XmlDocument xd = new XmlDocument();
        xd.Load("D:/stu.xml");
        XmlNodeList xn = xd.SelectNodes("rss/School/Grade/Student");
        string name;
        string sex;
        int age;
        string hobby;
        for (int i = 0; i < xn.Count; i++)
        {
            name = xn[i].SelectSingleNode("Name").InnerText;
            sex = xn[i].SelectSingleNode("Sex").InnerText;
            age = Convert.ToInt32(xn[i].SelectSingleNode("Age").InnerText);
            hobby = xn[i].SelectSingleNode("Hobby").InnerText;
            string sql = string.Format("insert into stuinfo values('{0}','{1}',{2},'{3}')", name, sex, age, hobby);
            res = db.ExecuteUpdate(sql);
        }
        if (res > 0)
        {
            Response.Write("<script>alert('添加成功！');</script>");
        }
        else
        {
            Response.Write("<script>alert('添加失败！');</script>");
        }