C# 查看access数据库的各种信息,表,列,行等信息

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.OleDb;

namespace DatabaseTest1
{
    class Program
    {
   
       static void Main(string[] args)
        {

            string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
            strConnection += @"Data Source=E:/c#study/test2005/DatabaseTest/DatabaseTest.mdb";

 

            OleDbConnection oconn = new OleDbConnection(strConnection);

            OleDbDataReader oReader;
            OleDbCommand oCmm = new OleDbCommand("select * from address", oconn);

            try
            {
                oconn.Open();

                DataTable oDataTable = oconn.GetSchema("Tables");

                //DataSet oDataSet = oDataTable.DataSet;
                foreach (System.Data.DataRow otmpRow in oDataTable.Rows)
                {
                    object[] a;
                    a = otmpRow.ItemArray;
                    foreach (object b in a)
                    {
                        Console.WriteLine(b.ToString());
                    }
                }
                Console.WriteLine("====================================");

                oDataTable = oconn.GetSchema("Views");

                //DataSet oDataSet = oDataTable.DataSet;
                foreach (System.Data.DataRow otmpRow in oDataTable.Rows)
                {
                    Console.WriteLine(otmpRow[2].ToString());
                }
                Console.WriteLine("====================================");

                ///下面是数据库中的表的信息
                oReader = oCmm.ExecuteReader();

 

 

                for (int i = 0; i < oReader.FieldCount; i++)
                {
                    Console.Write(oReader.GetName(i));
                    Console.Write("/t");
                }
                Console.WriteLine();

                //oReader.Read();

                for (int i = 0; i < oReader.FieldCount; i++)
                {

                    Console.Write(oReader.GetFieldType(i));
                    Console.Write("/t");
                }
                Console.WriteLine();

                while (oReader.Read())
                {

                    for (int i = 0; i < oReader.FieldCount; i++)
                    {
                        Console.Write(oReader.GetValue(i));
                        //Console.Write(oReader[i].ToString());
                        Console.Write("/t");
                    }
                }

                Console.WriteLine("====================================");

            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            finally
            {
                oconn.Close();
            }

            //
            Console.ReadLine();

    }
    }
}