Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get MS Access Query Column Names
Message
 
À
22/12/2009 07:21:41
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Divers
Thread ID:
01440055
Message ID:
01440156
Vues:
32
>>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?
>
>
>Assuming you are doing this against Norhwind.mdb:
>
>
DataTable t = con.GetSchema("columns",new string[] {null,null,"Sales By Category",null});
>Cetin


I already tried this. It returns no rows.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform