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),"/")
Array(1)
Array(2)
Array(3)
Array(4)
Array(5)

. . . . 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)