Click here to Skip to main content
15,395,652 members
Home / Discussions / C#
   

C#

 
GeneralRe: Declaring a connection string in class file Pin
Pete O'Hanlon13-Aug-12 4:06
mvaPete O'Hanlon13-Aug-12 4:06 
GeneralRe: Declaring a connection string in class file Pin
Wes Aday13-Aug-12 4:39
professionalWes Aday13-Aug-12 4:39 
GeneralRe: Declaring a connection string in class file Pin
Member 925960613-Aug-12 18:43
MemberMember 925960613-Aug-12 18:43 
GeneralRe: Declaring a connection string in class file Pin
Pete O'Hanlon13-Aug-12 22:51
mvaPete O'Hanlon13-Aug-12 22:51 
GeneralRe: Declaring a connection string in class file Pin
Member 925960614-Aug-12 0:00
MemberMember 925960614-Aug-12 0:00 
GeneralRe: Declaring a connection string in class file Pin
Pete O'Hanlon14-Aug-12 0:04
mvaPete O'Hanlon14-Aug-12 0:04 
AnswerRe: Declaring a connection string in class file Pin
Shameel13-Aug-12 4:23
professionalShameel13-Aug-12 4:23 
AnswerRe: Declaring a connection string in class file Pin
Pete O'Hanlon13-Aug-12 4:31
mvaPete O'Hanlon13-Aug-12 4:31 
A connection string is just a string that conforms to a particular pattern. The actual value that goes into the string depends on how the database is set up (e.g. is it accessed Windows Authentication) and other features such as whether or not you want Multiple Active RecordSets (MARS), which allows you to perform several reads using what appears to be the same connection. A good list of connection strings is available here[^]

It's traditional to store the connection string inside the .config file. There is a ConnectionStrings section (you won't see it in the default .config file, as you have to add it). Inside this ConnectionStrings section, you will add a ConnectionString entry that holds the details of the connection itself.

To retrieve the connection string in your code, you just need to use the following (here I'm assuming you've added your connection string into the config file with a key of MyConnectionString):
C#
string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos


CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

GeneralRe: Declaring a connection string in class file Pin
Shameel13-Aug-12 5:47
professionalShameel13-Aug-12 5:47 
GeneralRe: Declaring a connection string in class file Pin
Pete O'Hanlon14-Aug-12 0:04
mvaPete O'Hanlon14-Aug-12 0:04 
GeneralRe: Declaring a connection string in class file Pin
Shameel14-Aug-12 1:49
professionalShameel14-Aug-12 1:49 
GeneralRe: Declaring a connection string in class file Pin
Pete O'Hanlon14-Aug-12 2:02
mvaPete O'Hanlon14-Aug-12 2:02 
GeneralRe: Declaring a connection string in class file Pin
Member 925960614-Aug-12 2:20
MemberMember 925960614-Aug-12 2:20 
GeneralRe: Declaring a connection string in class file Pin
Pete O'Hanlon14-Aug-12 2:40
mvaPete O'Hanlon14-Aug-12 2:40 
GeneralRe: Declaring a connection string in class file Pin
Member 925960614-Aug-12 2:53
MemberMember 925960614-Aug-12 2:53 
GeneralRe: Declaring a connection string in class file Pin
Shameel14-Aug-12 4:13
professionalShameel14-Aug-12 4:13 
GeneralRe: Declaring a connection string in class file Pin
Pete O'Hanlon14-Aug-12 4:34
mvaPete O'Hanlon14-Aug-12 4:34 
AnswerRe: Declaring a connection string in class file Pin
Simon_Whale13-Aug-12 4:35
professionalSimon_Whale13-Aug-12 4:35 
AnswerRe: Declaring a connection string in class file Pin
Vijay Selvaraj26-Aug-12 22:10
MemberVijay Selvaraj26-Aug-12 22:10 
Questionin C#.net [moved] Pin
Member 925960613-Aug-12 2:56
MemberMember 925960613-Aug-12 2:56 
GeneralRe: in C#.net Pin
chriselst13-Aug-12 3:01
Memberchriselst13-Aug-12 3:01 
GeneralRe: in C#.net Pin
V.13-Aug-12 3:04
professionalV.13-Aug-12 3:04 
GeneralRe: in C#.net Pin
JimmyRopes13-Aug-12 3:10
professionalJimmyRopes13-Aug-12 3:10 
GeneralRe: in C#.net Pin
V.13-Aug-12 3:14
professionalV.13-Aug-12 3:14 
GeneralRe: in C#.net Pin
NormDroid13-Aug-12 3:09
professionalNormDroid13-Aug-12 3:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.