///<summary>
///读取注册表，根据Office版本获取数据库连接字段
///</summary>
///<returns>数据库连接字段</returns>
privatestringGetConnectionString()
{
stringstrConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=";
RegistryKeyrk=Registry.LocalMachine;
//查询Office2003
RegistryKeyf03=rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\11.0\Access\InstallRoot\");
//查询Office2007
RegistryKeyf07=rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\12.0\Access\InstallRoot\");
//查询Office2010
RegistryKeyf10=rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\14.0\Access\InstallRoot\");
if(f03!=null)
{
strConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=";
}
elseif(f07!=null||f10!=null)
{
strConnectionString="Provider=Microsoft.ACE.OLEDB.12.0;DataSource=";
}
returnstrConnectionString;
}
