如何从SQL SELECT查询中的c#变量创建jQuery数组

string query = "SELECT column_name FROM table_name WHERE condition";

List<string> resultList = new List<string>();

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(query, connection);
    connection.Open();
    
    SqlDataReader reader = command.ExecuteReader();
    
    while (reader.Read())
    {
        string value = reader.GetString(0); // 根据实际情况获取查询结果的列索引
        resultList.Add(value);
    }
    
    reader.Close();
}

string json = JsonConvert.SerializeObject(resultList);

var array = $.parseJSON(json);

for (var i = 0; i < array.length; i++) {
    console.log(array[i]);
}