-
C#教程之oledb连接access数据库示例
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
OleDbConnection conn = new OleDbConnection();
OleDbCommand comm = new OleDbCommand();
OleDbDataReader dr=null;
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Environment.CurrentDirectory + "\\SimpleNews.mdb";
comm.Connection = conn;
comm.CommandText = "select * from [login]";
try
{
conn.Open();
dr = comm.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
Console.Write(dr.GetValue(i) + " ");
Console.WriteLine("");
//dr.Close();
}
dr.Close();
}
catch (Exception err)
{
Console.WriteLine(err.Message);
}
finally
{
comm = null;
conn.Close();
comm = null;
Console.ReadKey();
}
}
}
}