Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get MS Access Query Column Names
Message
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Titre:
Get MS Access Query Column Names
Divers
Thread ID:
01440055
Message ID:
01440055
Vues:
88
I'm trying to get the column names of queries in MS Access . So far I have:
public static void Test()
{
    OleDbConnection connection = new OleDbConnection(AccessConnString);

    try
    {
        connection.Open();
    }
    catch (Exception e)
    {
        throw e;
    }

    DataTable t1 = connection.GetSchema("Columns");         // Returns Table column names
    DataTable t2 = connection.GetSchema("Procedures");      // Returns all Query names
    DataTable t3 = connection.GetSchema("Views");           // Returns all Subquery names

    connection.Close();
}
I cannot see to figure out how to get the column names for queries/subqueries. Anyone know how to do this?
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