c oledb连接mysql_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();

}

}

}

}