How to create a connection string in asp.net c#

Question

I am working on asp.net c# project, for connection I used:

SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\19-02\ABCC\App_Data\abcc.mdf;Integrated Security=True;User Instance=True");

but I want to get this connection string to get configure and be like this, so can any one help how to create this kind of connection.

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["itmall"].ConnectionString);

score 7 · Answer 1 · answered Mar 01 '14 at 11:42

Demo :

<connectionStrings>
<add name="myConnectionString" connectionString="server=localhost;database=myDb;uid=myUser;password=myPass;" />
</connectionStrings>

Based on your question:

<connectionStrings>
    <add name="itmall" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\19-02\ABCC\App_Data\abcc.mdf;Integrated Security=True;User Instance=True" />
    </connectionStrings>

Refer links:

http://www.connectionstrings.com/store-connection-string-in-webconfig/

Retrive connection string from web.config file:

write the below code in your file where you want;

string connstring=ConfigurationManager.ConnectionStrings["itmall"].ConnectionString;

SqlConnection con = new SqlConnection(connstring);

or you can go in your way like

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["itmall"].ConnectionString);

Note:

The "name" which you gave in web.config file and name which you used in connection string must be same(like "itmall" in this solution.)

score 2 · Answer 2 · edited Jun 02 '17 at 11:51

2

string connectionstring="DataSource=severname;InitialCatlog=databasename;Uid=; password=;"
SqlConnection con=new SqlConnection(connectionstring)

edited Jun 02 '17 at 11:51

Baum mit Augen

49,044
25
144
182

answered Jan 31 '15 at 07:19

PANKAJ PATIL

19
3

score 2 · Answer 3 · answered Jun 16 '17 at 10:51

add this in web.config file

           <configuration>
              <appSettings>
                 <add key="ConnectionString" value="Your connection string which contains database id and password"/>
            </appSettings>
            </configuration>

.cs file

 public ConnectionObjects()
 {           
    string connectionstring= ConfigurationManager.AppSettings["ConnectionString"].ToString();
 }

Hope this helps.

score 1 · Answer 4 · answered Mar 01 '14 at 11:31

1

Add this in your web.config file

<connectionStrings>
<add name="itmall" 
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\19-
02\ABCC\App_Data\abcc.mdf;Integrated Security=True;User Instance=True" />
</connectionStrings>

answered Mar 01 '14 at 11:31

Sudhakar Tillapudi

25,935
5
37
67

But what when i copy it to another folder, cant it like where we don't have to get update each time we change it's folder? – user3363485 Mar 01 '14 at 11:34
it willbe accessible from anywhere untill unless you are maintainig only one web.config file. – Sudhakar Tillapudi Mar 01 '14 at 11:36

score 1 · Answer 5 · answered Mar 01 '14 at 11:32

Add this connection string tag in web.config file:

<connectionStrings>
  <add name="itmall" 
    connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\19-02\ABCC\App_Data\abcc.mdf;Integrated Security=True;User Instance=True"/>
</connectionStrings>

And use it like you mentioned. :)

score 1 · Answer 6 · edited Jun 02 '17 at 11:50

1

It occurs when IIS is not being connected to SQL SERVER. For a solution, see this screenshot:

edited Jun 02 '17 at 11:50

Baum mit Augen

49,044
25
144
182

answered Jun 01 '17 at 12:08

Tariq Khan

19
1

can you please type out the solution? as some stack overflow users cant open pictures – WhatsThePoint Jun 01 '17 at 12:14

How to create a connection string in asp.net c#

6 Answers6

Linked