How to Configure the Connection String in Web Config?

Question

5.00/5 (1 vote)

See more:

This is my connection String

XML

<connectionstrings>

    <add name="ConnectionString" connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=<br mode=" hold=" />         |DataDirectory|\FusionChartsDB.mdf;Integrated Security=True;User Instance=True">
         <providerName="System.Data.SqlClient" />
  
</add>
</connectionstrings>

and my Database is located at my SQL Server management studio r2,
and the database is in DBfolder from Server explorer

My Deafult.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace InfoSoftGlobal.BluePrintApp.FC_ASP
{
///

/// Summary description for _default.
///

public class _default : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if ((Request.Form["Header1:animate"] == null ||
Request.Form["Header1:animate"].ToString().Length == 0) &&
Session["animation"] == null)
Session["animation"] = "1";
else if (Request.Form["Header1:animate"] != null)
Session["animation"] = Request.Form["Header1:animate"].ToString();

((UserControls.header)this.FindControl("Header1")).ShowSelection();

}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
}
}

Im using the Fusioncharts Sample code and it said that

FusionCharts Blueprint Application - C# (ASP.NET) + MS Access / SQL version
==================================================================

This demo application shows the capabilities of FusionCharts by integrating
it with C# (ASP.NET) and Access/SQL. The databases are contained in FusionChartsDB folder.
You'll find the Access MDB file and the SQL Database generation script.

Based on what you intend to use, change the data connection string in Web.config.

After that, run App/Default.aspx to view the application. Make sure you copy
all the files from App folder, keeping the folder structure intact.

PLEASE NOTE THAT THIS DEMO APPLICATION JUST USES A HANDFUL OF CHARTS
FROM FUSIONCHARTS SUITE FOR DEMO PURPOSE. FUSIONCHARTS OFFERS A LOT
MORE VARIETY OF CHARTS, WHICH IS PRESENT IN EVALUATION DOWNLOAD.

Troubleshooting
==================================================================
If for some reason, you do not see the charts, make sure you've
Adobe Flash Player 8 (or above) installed on your machine.

Support Information
==================================================================
Website: http://www.InfoSoftGlobal.com/FusionCharts
Email: support@infosoftglobal.com

Im New to Asp.net

Posted 2-Feb-14 23:01pm

Member 10533469

Updated 2-Feb-14 23:43pm

v4

Add a Solution

Comments

King Fisher 3-Feb-14 7:48am

if you solved this.update it

8 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Abhinav S · Accepted Answer · 2014-02-02T23:08:00

Solution 1

Try
http://www.connectionstrings.com/store-connection-string-in-webconfig/[^]
How to add Connection String in Web Config (VS2010 Ultimate)[^]
http://msdn.microsoft.com/en-us/library/ms178411.aspx[^]

Posted 2-Feb-14 23:08pm

Abhinav S

JoCodes · Accepted Answer · 2014-02-02T23:12:00

Try something like

XML

<connectionStrings>
   <add name="ConnString" connectionString="Data Source=localhost;Initial Catalog=YourDBName;Integrated Security=True;" providerName="System.Data.SqlClient" />
 </connectionStrings>

Refer below link and modify accordingly as needed.

http://www.connectionstrings.com/sql-server-2008/[^]

Ni!E$H_WAGH · Accepted Answer · 2014-02-02T23:16:00

Solution 3

If you simply want a connection string . place a gridview control on webpage & add the new datasouce, select the database you wanted to connect through code.
You will get the connection string from grdview properties.

Posted 2-Feb-14 23:16pm

Ni!E$H_WAGH

Comments

Member 10533469 3-Feb-14 5:40am

The ConnectionString property has not been initialized.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: The ConnectionString property has not been initialized.]

joginder-banger · Accepted Answer · 2014-02-02T23:18:00

you can try, I hope this is help full for you.

XML

<add name="_MyCon" connectionstring="Data Source=SystemName or you can used .[Dot];Initial Catalog=your DataBase Name ;Integrated Security=True">
   providerName="System.Data.SqlClient" />

</add>

and you can used in C# like this.

C#

 public SqlConnection _con;
_con = new SqlConnection(ConfigurationManager.ConnectionStrings["_MyCon"].ConnectionString);

for any query hit to reply.

Happy coding
☺

Praveen_P · Accepted Answer · 2014-02-02T23:33:00

In the web.config file add connection string as following

XML

<connectionStrings>
        <add name="con" connectionString="Data Source=.\sqlexpress;Initial Catalog=dbName;Integrated Security=True ; Pooling=False;"/>
    </connectionStrings>

and in the code behind u can access the connection string as

string connStr = ConfigurationManager.ConnectionStrings["con"].ConnectionString;

Ahmed Jubayer · Accepted Answer · 2014-02-03T00:57:00

You can change you web config file for connection based on your requirement:

Standard Security

HTML

Server=myServerAddress;Database=myDataBase;User Id=myUsername;
Password=myPassword;

Trusted Connection

HTML

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connection To SqlServer instance

HTML

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;

basurajkumbhar · Accepted Answer · 2014-02-03T01:43:00

Solution 7

Hi,

<connectionstrings>
		<add name="ConnectionString" connectionstring="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|FusionChartsDB.mdf;User Instance=true" providername="System.Data.SqlClient" />
</connectionstrings>

Posted 3-Feb-14 1:43am

basurajkumbhar

**VICK** · Accepted Answer · 2014-02-04T19:01:00

You can use the appSettings Tag in web.config for this purpose like below.

XML

<appSettings>
    <add key="dbStr" value="Server=local;Database=YourDBName;user id=sa ;password=SQLPassword"/>
</appSettings>

and to get/use it in application you can do something like below.

C#

string connectionString = System.Configuration.ConfigurationManager.AppSettings["dbStr"].ToString();

Hope it will help. :)

How to Configure the Connection String in Web Config?

8 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 6

Solution 7

Solution 8

Add your solution here

Preview 0