I need a datagrid that has 4 columms & 2 rows.
Each cell in that datagrid will represent one row from my database table.
I also need to use paging with that datagrid.

can someone plz giv me some sample code for that ?
or any tips on how to achieve the same ??

Thanx
 - Prasadd

You need to use a pivot table for that. Check BOL if you are using SQL Server. This is actually a SQL question, not a datagrid question.