Hi,
Add a application Configuration file and put connection string there.
after installation your application,The app.config file remains unchanged and it is editable,You can change conncetion string.
Use Connection string as:
cn.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
app.config:
<pre lang="xml"><?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<appSettings>
<add key="ConnectionString" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\DealerCare\DealerReports.accdb"/>
<add key="ClientSettingsProvider.ServiceUri" value="" />
</appSettings>
</configuration>