how to write connection string in web.config file and read from it

Question

0.00/5 (No votes)

See more:

i'm trying to write Connectionstring to Web.config like this:

HTML

<connectionStrings>
    <add name="Dbconnection" connectionString="Server=localhost; Database=OnlineShopping ; Integrated Security=True"/>
  </connectionStrings >

and read from it like this:

C#

string strcon = ConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString;
SqlConnection DbConnection = new SqlConnection(strcon);

when run the progrom I get an error because of the null reference.
but when I use this code:

C#

SqlConnection DbConnection = new SqlConnection();
DbConnection.ConnectionString = "Server=localhost; Database=OnlineShopping ; Integrated Security=True";

I don't get any error and the program work correctly!
What is the problem?
Tanx!

Posted 25-Aug-13 6:38am

alifat92

Add a Solution

Comments

abbaspirmoradi 25-Aug-13 12:57pm

please put error here.

alifat92 25-Aug-13 13:14pm

System.NullReferenceException: Object reference not set to an instance of an object.

5 solutions

Add a Solution

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

prasanta pradhan · Answer 1 · 2013-08-25T08:14:00

C#

<connectionstrings>
		<add name="Your Connection string name" connectionstring="data source=server name;Database=database name;uid=Database Username;pwd=password;multipleactiveresultsets=true;" providername="System.Data.SqlClient" />
	</connectionstrings>

For Call Connection string write the below code

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection string name"].ConnectionString.ToString());

Connection string name means "Your Connection string name"

Musakkhir · Answer 2 · 2013-08-25T07:06:00

Solution 1

Check your Web.config Connection string.

XML

<connectionStrings>
    <add name="Dbconnection" connectionString="Data Source=localhost;Initial Catalog=OnlineShopping;Integrated Security=true" providerName="System.Data.SqlClient" />

Posted 25-Aug-13 7:06am

Musakkhir

Comments

alifat92 25-Aug-13 13:18pm

I try this but still nut working!

Musakkhir 25-Aug-13 13:23pm

add database from database explorer and put one sqldatasource on test page and configure it with one table. It automatically creates connection string in web.config.

SaqibRasheed · Answer 3 · 2013-08-25T10:40:00

There doesn't seem anything wrong with your connection string other than the 'Initial Catalog' missing from it. You have specified it as Database, but in a connection string, we specify it as Initial Catalog. So, re-write your connection string as below and try again:

XML

<connectionStrings>
    <add name="Dbconnection" connectionString="Server=localhost;Initial Catalog=OnlineShopping;Integrated Security=True"/>
  </connectionStrings >

For detailed information, you can visit http://msdn.microsoft.com/en-us/library/ms178411.aspx[^] as well.

RajeeshMenoth · Answer 4 · 2015-02-25T21:26:00

Windows authentication :

HTML

<add name="windowsConnection" connectionString="Server=localhost; Database=databasename; Trusted_Connection=True" providername="System.Data.SqlClient" />

Sql server authentication :

HTML

<add name="Sqlserverconnection" connectionstring="server=localhost; Database=databasename;uid=username; password=123 " providername="System.Data.SqlClient"/>

Ref : Shortcut method for getting connection string

Rockjaw · Answer 5 · 2015-02-25T20:45:00

Solution 4

The web.config file must be added to the project/web site requiring the connection string.

Posted 25-Feb-15 20:45pm

Rockjaw

Comments

CHill60 26-Feb-15 5:42am

Answering old, resolved questions with this level of "detail" is likely to attract down-votes. I would avoid the practice if I was you.

how to write connection string in web.config file and read from it

5 solutions

Solution 2

Solution 1

Solution 3

Solution 5

Solution 4

Add your solution here

Preview 0

how to write connection string in web.config file and read from it

5 solutions

Solution 2

Solution 1

Solution 3

Solution 5

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us