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
Titre:
Read Access JOIN Metadata
Divers
Thread ID:
01438726
Message ID:
01438726
Vues:
96
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?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform