openschema question

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!

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

Quote:

---

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?

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

And are you using ADO or ADO.NET?

I think its safe to say he is using ADO.

Gpooh use ADO.NET