charles怎么导入xml文件_xml的导入和导出

将数据库里的数据导出到xml文件：

string str = ConfigurationManager.ConnectionStrings["sqlcnn"].ConnectionString;

SqlConnectioncon = new SqlConnection(str);

SqlCommandcmd = con.CreateCommand();

con.Open();

cmd.CommandText = "select * from book";

cmd.ExecuteScalar();

SqlDataAdapteradapter =

new SqlDataAdapter(cmd);

DataTabledt = new DataTable();

adapter.Fill(dt);

XElementxmlbookstore =

new XElement("bookstore");

for (int i = 0; i < dt.Rows.Count; i++)

{

XElementxmlbook = new XElement("book");

XElementxmltitle =

new XElement("title", dt.Rows[i]["title"].ToString());

XElementxmlauthor =

new XElement("author", dt.Rows[i]["author"].ToString());

XElementxmlyear