.sdf connection,query

Question

Hello,

Iam using vs 2010ultimate with c# for wpf application

my application need to save some data on database i added a local database to my project and created a table in my data base i know i need to write query to insert and retrieve data from table i don't know to write query please help me..

how to connect .sdf need connectionstring and server name

---

please

Answer 1

Hi

Define connection string like 

    <connectionStrings>
        <add name="connection" connectionString="Data Source=fileName.sdf;Persist Security Info=False;"/>
    </connectionStrings>

Refer for more : http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection.connectionstring(v=vs.100).aspx

How you use?

refer this, http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection.aspx

---

If this post answers your question, please click "Mark As Answer". If this post is helpful please click "Mark as Helpful".