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");
            
        }
    }
}