|
________________________________________________________________________
| ID | 이름 | 학기 | 성적 |
________________________________________________________________________
| 001 | 홍길동 | 1 | a |
________________________________________________________________________
| 001 | 홍길동 | 2 | b |
________________________________________________________________________
| 001 | 홍길동 | 3 | c |
________________________________________________________________________
| 001 | 홍길동 | 4 | d |
________________________________________________________________________
| 002 | 영구 | 1 | a |
________________________________________________________________________
| 002 | 영구 | 2 | b |
________________________________________________________________________
| 002 | 영구 | 3 | c |
________________________________________________________________________
| 002 | 영구 | 4 | d |
________________________________________________________________________
이런식으로 표출이 되는데요
________________________________________________________________________
| ID | 이름 | 학기 | 성적 |
________________________________________________________________________
| 001 | 홍길동 | 1 | a |
______________________________________________________
| 2 | b |
______________________________________________________
| 3 | c |
______________________________________________________
| 4 | d |
________________________________________________________________________
| 002 | 영구 | 1 | a |
______________________________________________________
| 2 | b |
______________________________________________________
| 3 | c |
______________________________________________________
| 4 | d |
______________________________________________________
이런식으로 표출이 되고싶은데 도무지 생각이 안나네여
각 학기가 1학기부터 4학기까지 고정적으로 표출이되고 ID와 이름이 같으면 하나로 합쳐서 셀머지기능이 수행이 되야하고 RowCount가 증가(ID가 추가될때) 할때마다 자동적으로 이런기능을 수행할수 있게 할려면 어케해야하죠
|