Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Read Access JOIN Metadata
Message
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Divers
Thread ID:
01438726
Message ID:
01438749
Vues:
39
I know nothing about Access but if you call GetSchema() without specifying a collection name you should get *everything* back.
As a last resort poking around in that should give you a clue to the collection you need......

>I have this code:
>
>
>static void Main(string[] args)
>{
>    // Microsoft Access provider factory
>    DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
>
>    DataTable Info = null;
>
>    using (DbConnection connection = factory.CreateConnection())
>    {
>        // c:\test\test.mdb
>        connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=K:\KevinM\Apex\APEX Data Warehouse - ProfitKey San Marcos.mdb";
>
>        // We only want user tables, not system tables
>        //string[] restrictions = new string[4];
>        //restrictions[3] = "Columns";
>
>        connection.Open();
>
>        // Get list of user tables
>        //Info = connection.GetSchema("Tables", restrictions);
>        // Info = connection.GetSchema("Tables");
>        Info = connection.GetSchema("Views");
>
>        int Count = Info.Rows.Count;
>    }
>}
>
>
>It returns table and view info for an MS Access database. Anyone know how to get the JOIN info?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform