// 设置连接字符串,以便访问Microsoft Access的eShops.mdb数据库
ConnectionString="Provider = Microsoft.Jet.OLEDB.4.0;"+"Data Source="+Server.MapPath("eshops.mdb");//请看请看请看 // 显示连接状态
OleDbConnection cn=new OleDbConnection(ConnectionString);
Message.Text=cn.State.ToString();
// 关闭连接
好象说你的机上没有安装Microsoft Data Access Components(MDAC) version 2.6
找到系统更新盘,从新装一边更新的内容即可。
{cn.open();}
catch(OledbException er)
{
Response.Write(er.Message.ToString());
Response.End();
}
到微软去下最新的MDAChttp://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp
using System.Data.OleDb;
---------------------------
OleDbConnection thisConnection=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\D\DevCs\Works2\Person.mdb;");
thisConnection.Open();
OleDbCommand thisCommand=thisConnection.CreateCommand(); //
thisCommand.CommandText="SELECT * FROM Intro";
OleDbDataReader thisReader=thisCommand.ExecuteReader();
while(thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",thisReader["ID"],thisReader["TheName"]);
}
thisReader.Close();
thisConnection.Close();