Can data be added to individual cells of Datagrid

Hey Folks

I know there is a lot of posts regarding the datagrid but none of them really answers my question.

I have a stored procedure (SQL Server) that returns data as follows:

[Value], [Row] , [Col]

e.g

'Subtotal', 1, 1
'10000', 1, 2
'200', 1, 3

This data needs to be displayed in a 'grid' format.

In VB6 i would have obviously used the MSHFlexgrid and just used the row and col references to select a cell.

However i am having to produce this application using .net!
From what i've read it only seems that you can use a datagrid with a data table and not perform the routine above.

Is this the case? If so would inserting and formatting the data into an array and setting that as the data source be possible?

I have honestly searched the net and site for help!

Any advice would be great

Cheers