asp.net 连接 access

web.config中设置

 <appSettings>
    <add key="ConnStr" value="provider=microsoft.jet.oledb.4.0;data source="/>
    <add key="dbPath" value="/App_Data/zzjz.mdb"/>
  </appSettings>

 

程序中调用如下：

String connstr = System.Configuration.ConfigurationSettings.AppSettings["ConnStr"] + System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["dbPath"]);  //链接字符串

                OleDbConnection myconn = new OleDbConnection(connstr); //定义连接对像
                myconn.Open(); //打开连接

 

//以下是输出内容的一段小程序
                String sql = "select * from zlm ";
                OleDbCommand mycod = new OleDbCommand(sql,myconn);
                OleDbDataReader rs = mycod.ExecuteReader();
                while (rs.Read()) {
                    Label1.Text =Label1.Text+"+"+ rs["title"].ToString();
                }