access数据库用C#语言如何连接VIsual Studio2010

首先要添加引用代码,（在这用的是OLE DB驱动实现的，使用该驱动需要添加该驱动引用）

using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.Collections;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Reflection;

下面是要打开mydb文件代码

DataSet ds = new DataSet();
    //定义连接字符串
    string strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Application.StartupPath + "\\MyDB.mdb";
    //定义连接数据源
    string sql = "select * from 序号";
    //声明一个数据连接
    System.Data.OleDb.OleDbConnection con = new OleDbConnection(strFilePath);
    System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter(sql, con);

using System; using System.Data; using System.Data.OleDb;

namespace DataViewApp {  class DataViewExample  {   static void Main()   {    string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\C#Program\C#100\Chapter3\NWIND.mdb";    OleDbConnection Conn = new OleDbConnection(conStr);

   try    {     string SQL = "SELECt ContactName, Country FROM Customers";     OleDbDataAdapter adapter = new OleDbDataAdapter();     adapter.SelectCommand = new OleDbCommand(SQL,Conn);          DataSet ds = new DataSet();         adapter.Fill(ds, "Customers");

    DataTable datatable = ds.Tables["Customers"];

    DataView myView = new DataView(datatable,     "Country = 'Germany'",     "Country",     DataViewRowState.CurrentRows);

    foreach (DataRowView myDrv in myView)     {     for (int i = 0; i < myView.Table.Columns.Count; i++)     Console.Write(myDrv[i] + "\t");     Console.WriteLine();     }    }    catch(Exception ex)    {     Console.WriteLine("Error Orccured: " + ex.Message);     Conn.Close();    }    finally    {     Conn.Close();     Console.ReadLine();    }   }    } }

string sql="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=数据库名.mdb;Persist Security Info=False";

以上为联接字符串

OLEDBSqlConnection conn=new OLEDBSqlConnection(sql);

注意大小写可能有错误