[Access]根据Office版本获取数据库连接字段

最新推荐文章于 2024-11-01 12:20:35 发布

u011170962

最新推荐文章于 2024-11-01 12:20:35 发布

阅读量875

点赞数

分类专栏： C# + Access 文章标签：注册表 office access C#.net 数据库

本文链接：https://blog.csdn.net/u011170962/article/details/37557647

版权

C# + Access 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

        /// <summary>
        /// 读取注册表，根据Office版本获取数据库连接字段
        /// </summary>
        /// <returns>数据库连接字段</returns>
        private string GetConnectionString()
        {
            string strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ";

            RegistryKey rk = Registry.LocalMachine;
            //查询Office2003
            RegistryKey f03 = rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\11.0\Access\InstallRoot\");
            //查询Office2007
            RegistryKey f07 = rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\12.0\Access\InstallRoot\");
            //查询Office2010
            RegistryKey f10 = rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\14.0\Access\InstallRoot\");

            if (f03 != null)
            {
                strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ";
            }
            else if (f07 != null || f10 != null)
            {
                strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = ";
            }

            return strConnectionString;
        }