connection string

Question

What connection string should I use in order to connect local database (added in project tree))

Answer 1

Hi Haris,

<connectionStrings>
    <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
  </connectionStrings>

 

Just provide the database name as master or create a test database

Regards,

Charan S

Answer 2

Hi Haris,

Check the following link for more information on ConnectionString

http://www.connectionstrings.com/sql-server-2008

---

PS.Shakeer Hussain

Answer 3

Data Source=MyData.sdf;Persist Security Info=False;

 

 

 

 

---

 

 

 

 

---

Noam B.

---

Do not Forget to Vote as Answer/Helpful, please. It encourages us to help you...

 

 

Answer 4

Hi Haris,

You can use VS Server Explorer --->Add a connection, the Wizard will give your connection String.

Or you can refer this link: http://www.connectionstrings.com/

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.