bind gridview header and body with database

See more:

ASP.NET

Hi,
I am return a datatable with following data and data-structure

Admin|BLG_MB| NULL
CHAIRS| 2788|MICHEAL
CHAIRS| 278|MIC
CHAIRS| 288|TYSAN
CHAIRS| 28|MICK
Cabin|BLG_COB| NULL
PC| 2788|SHAWN1
PC| 1788|SHAWN2
PC| 18|SHAWN3
PC| 10|SHAWN4

I want to bind this with gridview ,the column which contain null should be header
and the column without null shold be its data (body).

<pre lang="SQL">Admin|BLG_MB| NULL   ----- header
CHAIRS| 2788|MICHEAL
CHAIRS| 278|MIC
CHAIRS| 288|TYSAN
CHAIRS| 28|MICK
Cabin|BLG_COB| NULL <pre> ----- header
PC| 2788|SHAWN1
PC| 1788|SHAWN2
PC| 18|SHAWN3
PC| 10|SHAWN4&lt;/pre&gt;</pre>

when i print this gridview the header shold be repeated on the next page after page break.