hi how to display records from sqltable in 6 rows ?

See more:

SQL-Server-2005

C#

ASP.NET

, +

hi how to display sqltable records in grid in 6 rows..
m having columns named
DeskSide,Semister,RegistrationNo
i want to display this like
I                             II
L  R
Reg(sem) Reg(sem)


like this in second row will continue till VI th row..
and L is DeskSide so in L side should sit any one class sem and another R side other class sem.and how to show in one column two table values like registration and semister.
can any one help me.thanks