Access数据库的连接

[n499848748]

做的一个小东西 怎么连接Access数据库呢 代码 sql server 的好连
大神们 教教

[王晓彤]

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


OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\123.mdb");

[orochiheart]

string connStr, selectCmd;

connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=POST.mdb";
selectCmd = "Select * From Customer Order By ID ASC";
OleDbConnection conn;
OleDbDataAdapter myAdapter;
DataSet myDataSet = new DataSet();
conn = new OleDbConnection(connStr);
myAdapter = new OleDbDataAdapter(selectCmd, conn);
myAdapter.Fill(myDataSet, "Customer");

dataGrid1.DataSource = myDataSet.Tables["Customer"];