以文本方式查看主题

-  中文XML论坛 - 专业的XML技术讨论区  (http://bbs.xml.org.cn/index.asp)
--  『 建议或意见 』  (http://bbs.xml.org.cn/list.asp?boardid=20)
----  XML与SQL之间的相互转换(c#)?[求助]  (http://bbs.xml.org.cn/dispbbs.asp?boardid=20&rootid=&id=73164)


--  作者:lhs0217
--  发布时间:3/17/2009 4:43:00 PM

--  XML与SQL之间的相互转换(c#)?[求助]
有兴趣的进来讨论下,我只能做出单表的转换。多表的该用什么方法,具体该怎么做?
初学c#。。。
单表转换我做的代码如下:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Data;
using System.Xml;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace DBtoXML
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“bookOrderDataSet.Books”中。您可以根据需要移动或移除它。
            this.booksTableAdapter.Fill(this.bookOrderDataSet.Books);

        }

        private void btnRE_Click(object sender, EventArgs e)
        {
            //创建到数据库的连接,并读取数据
            SqlConnection ConBook = new
               SqlConnection("Server=localhost;Database=BookOrder;UID=sa;PWD=");
            SqlDataAdapter dadBook = new SqlDataAdapter("Select *From Books", ConBook);
            DataSet dstBook = new DataSet();
            dadBook.Fill(dstBook, "Books");

            DataTable dtblBook = dstBook.Tables["Books"];

            XmlDocument xdoc = new XmlDocument();
            //创建并添加XML文档声明;
            //<?xml version="1.0" encoding="utf-8" ?>
            XmlDeclaration xdexl = xdoc.CreateXmlDeclaration("1.0", "utf-8", "yes");
            //xdoc.AppendChild(xdecl);
            //创建并添加文档的根元素books
            XmlElement xe_books = xdoc.CreateElement("books");
            xdoc.AppendChild(xe_books);

            //读取数据库中每一行的信息并加入到XML文档中
            for (int i = 0; i < dtblBook.Rows.Count; i++)
            {
                XmlElement xe_book = xdoc.CreateElement("Book");

                //添加book的子元素bookID
                XmlElement xe_bookID = xdoc.CreateElement("bookID");
                xe_bookID.InnerText = dtblBook.Rows[i]["BookID"].ToString();
                xe_book.AppendChild(xe_bookID);

                //添加book的子元素bookISIN
                XmlElement xe_bookISBN = xdoc.CreateElement("bookISBN");
                xe_bookISBN.InnerText = dtblBook.Rows[i]["BookISBN"].ToString();
                xe_book.AppendChild(xe_bookISBN);

                //添加book的子元素bookName
                XmlElement xe_bookName = xdoc.CreateElement("bookName");
                xe_bookName.InnerText = dtblBook.Rows[i]["BookName"].ToString();
                xe_book.AppendChild(xe_bookName);

                //添加book的子元素bookCategory
                XmlElement xe_bookCategory = xdoc.CreateElement("bookCategory");
                xe_bookCategory.InnerText = dtblBook.Rows[i]["BookCategory"].ToString();
                xe_book.AppendChild(xe_bookCategory);

                //添加book的子元素bookAuthor
                XmlElement xe_bookAuthor = xdoc.CreateElement("bookAuthor");
                xe_bookAuthor.InnerText = dtblBook.Rows[i]["BookAuthor"].ToString();
                xe_book.AppendChild(xe_bookAuthor);

                //添加book的子元素bookPrice
                XmlElement xe_bookPrice = xdoc.CreateElement("bookPrice");
                xe_bookPrice.InnerText = dtblBook.Rows[i]["BookPrice"].ToString();
                xe_book.AppendChild(xe_bookPrice);

                //添加book的子元素bookPublisher
                XmlElement xe_bookPublisher = xdoc.CreateElement("bookPublisher");
                xe_bookPublisher.InnerText = dtblBook.Rows[i]["BookPublisher"].ToString();
                xe_book.AppendChild(xe_bookPublisher);

                //将book元素添加为文档元素books的子元素
                xdoc.DocumentElement.AppendChild(xe_book);
            }

            SaveFileDialog SaveFile = new SaveFileDialog();
            SaveFile.InitialDirectory = "D:\\";
            SaveFile.Filter = "XML Files (*.xml)|*.xml";
            SaveFile.FilterIndex = 1;

            // 如果文件名非空则保存
            if (SaveFile.ShowDialog() == DialogResult.OK && SaveFile.FileName != "")
            {
                XmlDocument doc = new XmlDocument();
                doc.LoadXml(xdoc.OuterXml);
                doc.Save(SaveFile.FileName);
                tbxXML.Text = xdoc.OuterXml;          
           }
            
           //xdoc.Save(@"E:\DBtoXML\books.xml");
            
        }
    }
}


W 3 C h i n a ( since 2003 ) 旗 下 站 点
苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》
46.875ms