web.config connection string - how to set connection string in side of this file

Question

1.50/5 (4 votes)

See more:

CSS

</appSettings>
 <connectionStrings>
   <add name="Local" connectionString="Data Source=172.16.0.22;Initial Catalog=GQMS;User ID=dbdeveloper;Password=maha@123" providerName="System.Data.SqlClient"/>
 </connectionStrings>
 <system.web>

Posted 25-Jun-14 23:44pm

Member 10534998

Updated 25-Jun-14 23:45pm

v2

Add a Solution

Comments

Thomas Daniels 26-Jun-14 5:50am

What do you mean exactly?

Prasad Avunoori 26-Jun-14 5:56am

You already did that. What do you want?

Member 10534998 26-Jun-14 5:56am

my exact ques iz tht, wt does name, Data Source & Initial Catalog mean?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sampath Lokuge · Accepted Answer · 2014-06-26T00:19:00

Solution 1

It's like this. :)

name="Local" - This is the name for your connection string.

Data Source=172.16.0.22 - Your SQL server name.

Initial Catalog=GQMS - Your Data base name.

Please read this for more info : SQL Server Connection Strings for ASP.NET Web Applications

Posted 26-Jun-14 0:19am

Sampath Lokuge

Comments

Member 10534998 26-Jun-14 6:25am

thnx.

Sampath Lokuge 26-Jun-14 6:39am

You're warmly welcome! :)

web.config connection string - how to set connection string in side of this file

1 solution

Solution 1

Add your solution here

Preview 0

web.config connection string - how to set connection string in side of this file

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us