DataDirectory Full Vs. Virtual Path

Hi

I am having some problems figuring out how the SSCE database connection string is set correctly in a forms application.

I have a database file, Database1.sdf, in the main directory of the application. I can add records to that via VS server explorer no probs. When I use any of the following connection strings in app.config..


Data Source ="|DataDirectory|Database1.sdf"

Data Source =".Database1.sdf"

Data Source ="Database1.sdf"

It will databind to a gridview of a combobox fine. However, when I create a form with some textboxes, build an insert string and use any of those connection strings with "Properties.Settings.Default.Database1ConnectionString" it just does nothing. No errors, no records inserted, just nothing.

But, if I change the connection stirng to...

Data Source ="D:\path\to\my\application\directory\Database1.sdf" (Just so happens I have this application on a D drive)

It all works just fine, including the insert.

So how do I refer to the database with virtual vs. absolute path? As far as I can tell the very first connection string I used should work, and should publish with the application.

Thanks!