Csharp/C Sharp by API/System.Data.OleDb/OleDbSchemaGuid
Версия от 18:31, 26 мая 2010; (обсуждение)
OleDbSchemaGuid.Tables
<source lang="csharp"> using System; using System.Data; using System.Data.OleDb; public class DatabaseInfo {
public static void Main () { String connect = "Provider=Microsoft.JET.OLEDB.4.0;data source=.\\Employee.mdb"; OleDbConnection con = new OleDbConnection(connect); con.Open(); Console.WriteLine("Made the connection to the database"); Console.WriteLine("Information for each table contains:"); DataTable tables = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[]{null,null,null,"TABLE"}); Console.WriteLine("The tables are:"); foreach(DataRow row in tables.Rows) Console.Write(" {0}", row[2]);
con.Close(); }
}
</source>