SQL query for ASP.NET page with C #

0

On my client's site, I have a SQL query that brings the readiness result of multiple collaborators. However, for the moment I can only translate the result of the query into a GridView:

SQL CONSULTATION

SELECT codigoAvaliacao, codigoColaborador, nomeColaborador, nivelProntidao 
FROM TableAvaliacoes

RESULTS EXAMPLE

codigoAvaliacao | codigoColaborador | nomeColaborador | nivelProntidao
--------------- | ----------------- | --------------- | --------------
1               | 1                 | Fulano          | 90
2               | 3                 | João            | 75
3               | 4                 | Ciclano         | 83,5
4               | 6                 | Beltrano        | 44,44
5               | 10                | Silva           | 68,11

My idea was to bring the result of this query in another way, associating it with a figure called NineBox. It puts the names in the squares depending on the level of readiness. Here is an example of the figure as I found it on the internet:

There,fornow,IcouldonlyputtheHTMLcodeofthetablewiththepropercolors:

<table><tr><tdwidth="200" height="200" style="color: black; background-color: yellow"><center id="names1"></center></td>
        <td width="200" height="200" style="color: black; background-color: rgb(151,195,82)"><center id="names2"></center></td>
        <td width="200" height="200" style="color: white; background-color: rgb(12,133,54)"><center id="names3"></center></td>
    </tr>
    <tr>
        <td width="200" height="200" style="color: black; background-color: rgb(245,154,73)"><center id="names4"></center></td>
        <td width="200" height="200" style="color: black; background-color: yellow"><center id="names5"></center></td>
        <td width="200" height="200" style="color: black; background-color: rgb(151,195,82)"><center id="names6"></center></td>
    </tr>
    <tr>
        <td width="200" height="200" style="color: white; background-color: red"><center id="names7"></center></td>
        <td width="200" height="200" style="color: black; background-color: rgb(245,154,73)"><center id="names8"></center></td>
        <td width="200" height="200" style="color: black; background-color: yellow"><center id="names9"></center></td>
    </tr>
</table>

What I would need then from this SQL query would be created another and something like that (assuming the results were the image names instead of the result example), with the names of each square separated by the tab:

QUADRADO | NOMES
-------- | -----
1        | Francisco
2        | NULL
3        | Vera
4        | NULL
5        | Alice<br>Alexandre<br>Marcos<br>Madalena
6        | Ângela<br>José 
7        | Maria
8        | João<br>Pedro
9        | Benedito<br>Carla<br>David

What do I put as an SQL query for this case?

    
asked by anonymous 18.01.2017 / 18:08

0 answers