在C#中将SqlDataReader列值转换为json字符串

using System.Data.SqlClient;

// ...

string connectionString = "Your_Connection_String";
string query = "SELECT Column1, Column2, Column3 FROM YourTable";

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

    using (SqlCommand command = new SqlCommand(query, connection))
    {
        using (SqlDataReader reader = command.ExecuteReader())
        {
            // 读取SqlDataReader中的列值并进行处理
        }
    }
}

var jsonObject = new
{
    Column1 = reader["Column1"],
    Column2 = reader["Column2"],
    Column3 = reader["Column3"]
};

string jsonString = JsonConvert.SerializeObject(jsonObject);