Barney,
The only thing I know is when you make a kind of "reflection" xy = yx of
your datatable.
Here a sample I once made for that.
\\\Needs only a project with a datagrid on a form
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim ds As New DataSet
Dim dt1 As New DataTable("Original")
ds.Tables.Add(dt1)
dt1.Columns.Add("Name")
dt1.Columns.Add("Adress")
dt1.Columns.Add("Age")
For i As Integer = 0 To 2
dt1.Rows.Add(dt1.NewRow)
Next
dt1.Rows(0).ItemArray = New Object() {"John", "23 noway", 12}
dt1.Rows(1).ItemArray = New Object() {"Sally", "12 yesway", 34}
dt1.Rows(2).ItemArray = New Object() {"Suzzy", "43 okway", 21}
Dim dt2 As New DataTable("Reflection")
ds.Tables.Add(dt2)
For i As Integer = 0 To ds.Tables("Original").Rows.Count - 1
dt2.Columns.Add(i.ToString)
Next
For i As Integer = 0 To ds.Tables("Original").Rows.Count - 1
Dim dr As DataRow = ds.Tables("Reflection").NewRow
For y As Integer = 0 To ds.Tables("Original").Columns.Count - 1
dr(y) = ds.Tables("Original").Rows(y).Item(i)
Next
ds.Tables("Reflection").Rows.Add(dr)
Next
DataGrid1.DataSource = ds.Tables("Reflection")
End Sub
///
I hope this helps a little bit?
Cor
