Connection String

Expand Post »

Hi Guys,
I am developing asp.net web application using vb.net ,I was wondering If there is a way to get the connection string value actually stored in web.xml file to be used in the vb.net code.
Any comment will be helpful
Thanks

Similar Threads

connection string of SqlConnection in C#
Connection String in Visual Basic 4 / 5 / 6
Connection String in MS Access and FileMaker Pro
connection string in ASP.NET
Dynamic Connection String Using ADO in Visual Basic 4 / 5 / 6

hamjad

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Sep 2007

Permalink

Sep 21st, 2007

Re: Connection String

To pull the SQL Connection String from the Web.Config use

In the web.config

ASP.NET Syntax (Toggle Plain Text)

<add name="SQLConnStr" connectionString="Data Source=SQLSERVER;Initial Catalog=DATABASE;uid=USERNAME;pwd=PASSWORD"/>

In the VB.NET Code

ASP.NET Syntax (Toggle Plain Text)
System.Configuration.ConfigurationManager.ConnectionStrings("SQLConnStr").ConnectionString
System.Configuration.ConfigurationManager.ConnectionStrings("SQLConnStr").ConnectionString

ptaylor965

Reputation Points: 16

Solved Threads: 19

Junior Poster

Offline

169 posts
since Oct 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: ControlParameter DropDownList not recognized on a ObjectDataSource

Next Thread in ASP.NET Forum Timeline: Comment tag ASP.NET

DaniWeb Message

Cancel Changes

User Name
Password