Connect to a MSSQL DB using Web.config

Question

I have created a ASP.NET C# MVC project. I am trying to connect it to a MSSQL DB. In the Web.config file i added the following;

  <connectionStrings>
     <add name="sdbconnection" providerName="System.Data.SqlClient"
         connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename="C:\Users\o\documents\visual studio 2012\Projects\ppl\ppl\App_Data\ppldb.mdf";Integrated Security=True" />
  </connectionStrings>

But, the above code is incorrect ; I want it to be as follows;

  <connectionStrings>
    <add name="sdbconnection" providerName="System.Data.SqlClient"
         connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|ppldb.mdf;Integrated Security=True" />
  </connectionStrings>

But What is DataDirectory ? Where do i specify it ?

What is name="sdbconnection" ? Can i give any name that i want ?

connectionstrings.com

Prabhu Murthy
– Prabhu Murthy

2013-04-18 06:15:21 +00:00
Commented Apr 18, 2013 at 6:15 — Prabhu Murthy
– Prabhu Murthy, Commented Apr 18, 2013 at 6:15

Piotr Stapp · Accepted Answer · 2013-04-18 06:10:14Z

2

First question Quoting MSDN:

The |DataDirectory| portion of the connection string specifies that the MDF file is located inthe App_Data directory

Moreover you can change it using following function:

AppDomain.CurrentDomain.SetData("DataDirectory", "D:\database");

Second question name="sdbconnection" allows you to use specified conection string. So in your code you can write:

string connectionString = ConfigurationManager.ConnectionStrings["sdbconnection"].ConnectionString;

to acces this connection string

answered Apr 18, 2013 at 6:10

Piotr Stapp

19.9k11 gold badges72 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

unique · Accepted Answer · 2013-04-18 06:18:33Z

0

Name is use to identify and use code your applications Please refer this article http://www.connectionstrings.com/Articles/Show/store-connection-string-in-web-config Data Directory is usually App_Data folder and in web.config file name is use to use connection string in the application

Ex:String conn=ConfigurationManager.ConnectionStrings["Your name at web.config file"].ConnectionString;

or String conn=ConfigurationManager.ConnectionStrings["Your name at web.config file"].toString();

answered Apr 18, 2013 at 6:18

unique

5,5926 gold badges25 silver badges26 bronze badges

Collectives™ on Stack Overflow

Connect to a MSSQL DB using Web.config

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related