将dataset中的数据写入xml中

using System.Data;
using System.Xml;
using System.Text;
using System.Data.SqlClient;     

string connString = "data source=.（主机名.代表本地）;database=WebStation（数据库名）; integrated security=true（身份验证方式，此处为windows身份验证）";

        SqlConnection conn = new SqlConnection(connString);
        string cmdString = "select * from Songs（表名）";//select 语句对表Songs的查询
        SqlCommand cmd = new SqlCommand(cmdString, conn);
        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        try
        {
            conn.Open();
            adapter.Fill(ds);
            ds.WriteXml(Server.MapPath("~/UserBlog/XML/addAlbum.xml"));//物理路径（xml地位置）
            cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
        finally
        {
            ds.Dispose();
            conn.Close();   //释放资源
            cmd.Dispose();
        }