Using sql server. Data returned:
smith, joe 1 10
smith, joe 2 5
smith, joe 3 6
smith, joe 4 1
zin, sally 1 7
zin, sally 3 9
zin, sally 4 6
How to display:
Name Jan Feb Mar Apr
Smith, joe 10 5 6 1
zin, sally 7 0 9 6
Can a gridview be used? Datalist?