question

[abcd]

what is the equivalent of the below ADO code in ADO.NET

Set objRs = objConn.OpenSchema(adSchemaTables)

thanks

 

[Mark Rae]

what is the equivalent of the below ADO code in ADO.NET

Set objRs = objConn.OpenSchema(adSchemaTables)

This might give you a start:
http://www.dotnet247.com/247reference/a.aspx?u=http://www.dotnetextreme.com/code/getdbschema.asp

 

[abcd]

It is strange that in ADO this code works for OLEDB and ODBC.

In .NET currently supported for OLEDB and not for ODBC

thanks

 

[Cor Ligthert]

ABCD,

There is no equivalent, because there is no recordset.

Have a better look at ADONET in the documentation. By instance books from
Sceppa, Vaughn, or Malik.

(I did not read one letter in those books however these guys are active in
this newsgroup)

Cor

 

[oraclevsmicrosoft]

There is an equivalent because dataTable is an equivalent to recordSet.

Assuming "MyCon" is a valid and opened oledbConnection, the
following works fine :

System.Data.DataTable MyDataTable=
MyCon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);

hope this helps

Marc Boizeau

http://oraclevsmicrosoft.blogspot.com

 

[Paul Clement]

¤ It is strange that in ADO this code works for OLEDB and ODBC.
¤
¤ In .NET currently supported for OLEDB and not for ODBC

Yes, the schema info you can retrieve using the ODBC .NET provider is somewhat limited.


Paul
~~~~
Microsoft MVP (Visual Basic)