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();
}
}
}