数据库导出到xml中

 using (SqlConnection sqlCnn = new SqlConnection(str))
        {
            
            using (SqlCommand sqlCmm = sqlCnn.CreateCommand())
            {
                sqlCmm.CommandText = "select title,year,price,author,gender,age from book";
                SqlDataAdapter sda = new SqlDataAdapter(sqlCmm);
                DataSet ds = new DataSet();
                sda.Fill(ds);
                DataTable dt = ds.Tables[0];
                XElement xmlbookstore = new XElement("bookstore");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                   
                    XElement xmlbook = new XElement("book");
                    XElement xmltitle = new XElement("title", dt.Rows[i]["title"].ToString());
                    XElement xmlauthor = new XElement("author", dt.Rows[i]["author"].ToString());
                    xmlauthor.SetAttributeValue("gender", dt.Rows[i]["gender"].ToString());
                    xmlauthor.SetAttributeValue("age", dt.Rows[i]["age"].ToString());
                    XElement xmlyear = new XElement("year", dt.Rows[i]["year"].ToString());
                    XElement xmlprice = new XElement("price", dt.Rows[i]["price"].ToString());
                    xmlbook.Add(xmltitle);
                    xmlbook.Add(xmlauthor);
                    xmlbook.Add(xmlyear);
                    xmlbook.Add(xmlprice);
                    xmlbookstore.Add(xmlbook);
                   
                    
                }
                //Response.Write(xmlbookstore.ToString());
                FileStream Stream = File.OpenWrite(Server.MapPath("book1.xml"));
                StreamWriter writer = new StreamWriter(Stream);
                writer.WriteLine(xmlbookstore);
                writer.Flush();
                Stream.Dispose();

                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('导出成功')</script>");

            }
        }
    }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值