数据库表格转换XML

// 采用DataSet中的WriteXml方法可以把数据库表格直接转成XML文件。
XmlDocument doc = new XmlDocument();
DataSet dataSet = new DataSet(“Books”);
using (SqlConnection conn = new SqlConnection(GetConnectionString()))
using (SqlCommand cmd = new SqlCommand(“SELECT * FROM Books”, conn))
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
    adapter.Fill(dataSet);
}

StringBuilder sb = new StringBuilder();
using (StringWriter sw = new StringWriter(sb))
{
    dataSet.WriteXml(sw);
}

Console.WriteLine(sb.ToString());