title: DataDirectory Set up project
body: <p>I am doing a SETUP project for a C# winforms, sqlite application. 
  Connection string seems to a bit of a problem. The user will put the Database he wants to work with at a location(which v will tell him).  In this example it is <code>"C:\\Program Files(x86)\\DefaultCompany\\RSetup";</code> The user can work his own copy of the DB. </p>
  
  <p>So I am setting the data directory to this path in the Program.cs Main 
   This is the only way I can think of. If there is a better way thats grt!!. </p>
  
  <pre><code> App.config 
  
          &lt;add name="ConnString" connectionString="|DataDirectory|\MySQlite.db;Compress=True;Version=3"
                providerName="System.Data.Sqlite" /&gt;
  
    Program.cs 
      Setting the datadirectory to the path of the executable. Currently hard coded the path of the executable 
        static void Main()
              {
  
                     AppDomain.CurrentDomain.SetData("DataDirectory","C:\\Program Files(x86)\\DefaultCompany\\RSetup");
  </code></pre>
  
  <p>This doesn't seem to be working. It doesn't give any error except the data is not blank. Doesn't seem to be working in both set up and the regular project </p>
  
  <p>Thank you
  JC</p>