有兴趣的进来讨论下，我只能做出单表的转换。多表的该用什么方法，具体该怎么做？
初学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");
}
}
}
[返回] 中文XML论坛 - 专业的XML技术讨论区 →
版务区 → 『 建议或意见 』 → XML与SQL之间的相互转换（c#）？[求助]
(订阅本版)
2009/3/17 16:43:00
新浪微博
XML与SQL之间的相互转换（c#）？[求助]
