将从数据库中查询的数据，转换成XML格式

最新推荐文章于 2021-03-10 12:11:49 发布

weixin_30508309

最新推荐文章于 2021-03-10 12:11:49 发布

阅读量2.3k

点赞数

文章标签：数据库 java c/c++

原文链接：http://www.cnblogs.com/fanxiaojun/archive/2012/06/08/2541787.html

版权

string connStr = "Server=178.88.1.121;initial catalog=test;User=sa;password=abc.DB";

        using (SqlConnection conn = new SqlConnection(connStr))
        {
            SqlCommand command = new SqlCommand("select top 4 * from h_emp_mstr", conn);
            conn.Open();
            DataSet ds = new DataSet();
            ds.DataSetName = "employeelist";
            ds.Load(command.ExecuteReader(), LoadOption.OverwriteChanges, "employee");
            Response.ContentType = "text/xml";
            ds.WriteXml(Response.OutputStream);
        }

转载于:https://www.cnblogs.com/fanxiaojun/archive/2012/06/08/2541787.html