how to use the connection string written in web.config file within .net application 2.0

sattisanju

how to use the connection string written in web.config file within .net application 2.0

Posted by sattisanju in .Net | ASP.NET on Dec 21, 2006

0

1
5199

Do you know the answer for this question? Post it below.

Guest

This Feature is Sponsored By

500+ c# and .NET interview questions and answer videos.

Posted by kamal kamal on Dec 22, 2006

0

You write connection string in the web.Config file. Like

<connectionStrings>

<add name="nwindCnn" connectionString="Data Source=Test\SQLEXPRESS;Initial Catalog=NWind;Integrated Security=True"/>

connectionStrings>

In program you can use like this

Dim cnn As SqlConnection

cnn = New SqlConnection()

cnn.ConnectionString = ConfigurationManager.ConnectionStrings("nwindCnn").ConnectionString

You can write any number connection strings by giving proper names.

Related Questions

PREMIUM SPONSORS

DynamicPDF Developer Components iPhone, Android & Web Development Services

Join a Chapter

TRENDING NOW

What is difference between C++ and C# Which is the first version of C# language. How to develop XNA Apps in Visual Studio 2012? How to Fetch Different Values in LINQ? How to Retrieve Column Names of a Table in SQL Server 2012? How to create Backup of Database in SQL Server 2012? How a table is truncating using LINQ How to import Data to Excel SpreadSheet in .NET How to enabled form validation in html5? How to Get Marquee Feature Without Marquee Tag in HTML5?

MOST LIKED QUESTIONS

Why do you want to leave your current company? In which situation(s), the use of "Delegate" is a good idea? Which namespaces are necessary to create a localized application? In which assembly MVC framework is defined ? How a table is truncating using LINQ Types of Polymorphism How to declares a two-dimensional array in C#? What is Polymorphism? How does VB.NET/C# achieve polymorphism? I have some dll that developed by ASP application,can i use reuse that dll to ASP.net application,Is it possible ,How Explain? In an application currently in production, one module of code is being modified. Is it necessary to re-test the whole application or is it enough to just test functionality associated with that module?

SPONSORED BY

DynamicPDF ReportWriter Suite

PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.

Hosted By CBeyond Cloud Services TOP LEADERS MOST VIEWED LEGENDS NOW PRIZES AWARDS REVIEWS SURVEY CERTIFICATIONS DOWNLOADS

PHOTOS TIPS CONSULTING TRAINING STUDENTS MEMBERS MEDIA KIT SUGGEST AN IDEA

PRIVACY POLICY | TERMS & CONDITIONS | SITEMAP | CONTACT US | ABOUT US | REPORT ABUSE

2013© C# Corner. All contents are copyright of their authors.