asp.net SQL数据库导入到XML

来源:互联网 发布:淘宝图片下载器 编辑:程序博客网 时间:2024/05/19 19:59

SqlConnection conn = new SqlConnection("server=.;database=DbXml;uid=sa;pwd=sa");

protected void btnXML_Click(object sender, EventArgs e)
    {
        
       string xml = "select title,content,creattime from tb_test";
        conn.Open();
        SqlCommand cmd = new SqlCommand(xml,conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
       ds.WriteXml(Server.MapPath("XML3.xml"));
        conn.Close();
        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('导入成功')</script>");

  }

原创粉丝点击