SchemaTable - How to read/write values out

J

John McCarthy

Dim oDT As New DataTable()
Dim oDC As New DataColumn()
Dim oDR As DataRow

From functions in a class -

(1) get the schema for tables authors - works

..Set_ActiveTableName("AUTHORS")
..Set_cmdPubsTableDirect(.Get_ActiveTableName)
oDT = .Get_odrPubs(True).GetSchemaTable
Get_odrPubs(False).Close()

(2) Write out values to screen - does not work

For Each oDR In oDT.Rows
For Each oDC In oDT.Columns
Response.Write(oDR[odc.tostring()])
Next
Next

Would someone show me the correct code for the
for loops

regards,
John McCarthy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,430
Messages
2,571,676
Members
48,796
Latest member
Greg L.

Latest Threads

Top