在asp.net中怎么使用access数据库

Question

在web.config中的配置是
<add key="DbConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\database\myStandDB.mdb"/>在代码中,要使用access数据库,要用哪个类库呢?

Answer 1

http://msdn.microsoft.com/en-us/library/system.data.oledb(VS.71).aspx

Answer 2

        /// <summary>
        /// 打开数据库连接
        /// </summary>
        private static void openConn()
        {
            if (conn.State == ConnectionState.Closed)
            {
                //SysConfig.ConnectionString 为系统配置类中连接字符串，如："server=localhost;database=databasename;uid=sa;pwd=;"
                string olestring = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + System.AppDomain.CurrentDomain.BaseDirectory;  //字符串设置
                conn.ConnectionString = olestring + ConfigurationManager.ConnectionStrings["ConnString"].ToString();    
                comm.Connection = conn;
                try
                {
                    conn.Open();
                }
                catch (Exception e)
                {
                    throw new Exception(e.Message);
                }
            }
        }//config文件
<connectionStrings>
<add name="ConnString" connectionString="App_Data/news.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>