How to read columns Item from Indexes GetSchema ?

Andrea Rocca · Post by **Andrea Rocca** » Wed 10 May 2006 13:19

Dim Dtl As System.Data.DataTable
Dim Row As System.Data.DataRow
Dim Cols() As Char
Dim S as string

Dtl = mvarConnectionDB.GetSchema("Indexes")
For Each Row In Dtl.Rows

'This not work ?
Cols = CType(Row.Item("columns"), Char())

'This return System.Byte[]
S = Row.Item("columns").ToString

Next Row

Alexey · Post by **Alexey** » Thu 11 May 2006 07:10

We have found the problem and now we are fixing it. Look forward to the next build.

Alexey · Post by **Alexey** » Thu 11 May 2006 08:03

Use Protocol=Ver20 in the ConnectionString property for workaround.
Row.Item("columns").ToString statement will return string containing the
numbers of columns which form index.