SQL Server CE Connection string to connect to the database from a windows form application

Asked Apr 03 '13 at 08:54

Active Apr 03 '13 at 08:57

Viewed 637 times

SqlCeConnection conn =
   new SqlCeConnection(@"Data Source= " + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\ITIA.sdf;Persist Security Info=False;"));
conn.Open();

this is my code and it is showing me the following error:

The file name is not valid. Check the file name for the database. [ File name = file:\C:\Users\Prash\documents\visual studio 2010\Projects\ITIA\ITIA\bin\Debug\ITIA.sdf ]

but in the folder the database is saved as ITIA.

I want to publish my windows form application so that the client can enter data which can be stored in a database.

edited Apr 03 '13 at 08:57

marc_s

732,580
175
1,330
1,459

asked Apr 03 '13 at 08:54

user2132038

Where is it saved to? (The *exact* location). How does this differ from what is above? – Arran Apr 03 '13 at 09:00
I didnt really get you? – user2132038 Apr 03 '13 at 09:03
See reply here: http://stackoverflow.com/questions/52797/how-do-i-get-the-path-of-the-assembly-the-code-is-in – ErikEJ Apr 03 '13 at 09:26

SQL Server CE Connection string to connect to the database from a windows form application

0 Answers0