跟ACCESS数据库连接用oleDbConnection当然行,试试下面代码,肯定能行。
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0 ; Data Source=f:\\xwj.mdb " ;
OleDbConnection conn = new OleDbConnection(strCon);
conn.Open()
string selestr = "SELECT * FROM department ORDER BY deptid";
OleDbDataAdapter adapter = new OleDbDataAdapter(selestr,conn);
Dataset1 dataset = new Dataset1();
adapter.Fill(dataset,"department");
conn.Close();
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0 ; Data Source=f:\\xwj.mdb " ;
OleDbConnection conn = new OleDbConnection(strCon);
conn.Open()
string selestr = "SELECT * FROM department ORDER BY deptid";
OleDbDataAdapter adapter = new OleDbDataAdapter(selestr,conn);
Dataset1 dataset = new Dataset1();
adapter.Fill(dataset,"department");
conn.Close();
是可以的
你的access有没有密码??