将ExecuteReader转换为XML HTTP响应

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

public class DatabaseQuery
{
    public string ConvertDataReaderToXmlResponse()
    {
        string connectionString = "YourConnectionString";
        string query = "YourQuery";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    // 创建XmlDocument对象
                    XmlDocument xmlDoc = new XmlDocument();

                    // 创建根节点
                    XmlElement rootElement = xmlDoc.CreateElement("Result");
                    xmlDoc.AppendChild(rootElement);

                    // 遍历DataReader对象，将查询结果转换为XML节点
                    while (reader.Read())
                    {
                        // 创建子节点
                        XmlElement rowElement = xmlDoc.CreateElement("Row");
                        rootElement.AppendChild(rowElement);

                        // 将查询结果的每一列转换为XML元素
                        for (int i = 0; i < reader.FieldCount; i++)
                        {
                            string columnName = reader.GetName(i);
                            object columnValue = reader.GetValue(i);

                            XmlElement columnElement = xmlDoc.CreateElement(columnName);
                            columnElement.InnerText = columnValue.ToString();
                            rowElement.AppendChild(columnElement);
                        }
                    }

                    // 将XmlDocument对象保存为XML字符串
                    string xmlString = xmlDoc.OuterXml;

                    // 创建HTTP响应对象
                    System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
                    response.ContentType = "text/xml";

                    // 发送XML字符串作为响应的正文内容
                    response.Write(xmlString);
                    response.End();
                }
            }
        }

        return string.Empty;
    }
}