openschema question

[Gpooh]

When I want to list columns in a table with vb6.0, I write
adoconnection.OpenSchema(ADODB.SchemaEnum.adSchemaColumns, Array(empty, empty, empty, tablename))
but now with vb.net, I find that Array(empty, empty, empty, tablename)) is not correct , how can i rewrite it in vb.net?
thanks in advance!

[Edneeis]

Are you still using ADO or did you switch to OLEDB?

[DevGrp]

Originally posted by Gpooh
When I want to list columns in a table with vb6.0, I write
adoconnection.OpenSchema(ADODB.SchemaEnum.adSchemaColumns, Array(empty, empty, empty, tablename))
but now with vb.net, I find that Array(empty, empty, empty, tablename)) is not correct , how can i rewrite it in vb.net?
thanks in advance!

What do you mean by listing columns?

[Gpooh]

I want to get every column name of a table, so I use openschema function

[Edneeis]

And are you using ADO or ADO.NET?

[DevGrp]

I think its safe to say he is using ADO.

Gpooh use ADO.NET