DataGrid Column Manipulation

Question

Hello All:

I am populating a datagrid from a table. On of the column in the table is an array of several values which I need to split and display it in datagrid.

Currently it is like this:

HEADER

ASP/1.01/l0/20/DEV/Prod

I need to dispaly it like this: 

Header	2nd Header	3rd Header	4th Header	5th Header
ASP	1.01	10	DEV	PROD

In Classic asp we would do something like this:


Array = Split(objRecordSet("ColumnName),"/")
<td>Array(1)</td>
<td>Array(2)</td>
<td>Array(3)</td>
<td>Array(4)</td>
<td>Array(5)</td>

. . . . etc.

How can I get the value of a specific column from a dataset and manipulate and then display the manipulated value in DataGrid insted of the actual Values from database?

Sure would appreciate ya'll help! Thanks


P.S. I am using Visual Studio (if it helps any)