ConfigurationSe ttings.AppSetti ngs["value"] returns a string that starts with '@'

[lauralucas]

Hello

I'm trying to use a connection string stored in web.config

here is the web.config part

<appSettings>
<add key="NDDbase"
value="Server=S OMESERVER\\SOME INSTANCE;integr ated
security=SSPI;d atabase=NDD"/>
</appSettings>

and from code I'm trying to access it like this:

string mySelectQuery = "SELECT * FROM sometable'";
string myConnectString = ConfigurationSe ttings.AppSetti ngs["NDDbase"];

SqlCommand myCommand = new SqlCommand(mySe lectQuery);
myCommand.Conne ction = new SqlConnection(m yConnectString) ;
But when debugging, I see that myConnectString value always starts with
an @, like this:
@"Server=SOMESE RVER\\SOMEINSTA NCE;integrated
security=SSPI;d atabase=NDD"

is this normal? I could parse the string and remove the at-sign but I
suppose is there for a reason. This makes the SqlConnection to not
open, as it is not initialized properly.

help me and write me some suggestions please, thanks =)

Regards
Laura Lucas

[lauralucas]

now that I look at it, the at-sign is not part of the string, look at
this picture:

http://i7.tinypic.com/20tgj08.jpg

weird, what does it mean?
la********@gmai l.com wrote:

Hello

I'm trying to use a connection string stored in web.config

here is the web.config part

<appSettings>
<add key="NDDbase"
value="Server=S OMESERVER\\SOME INSTANCE;integr ated
security=SSPI;d atabase=NDD"/>
</appSettings>

and from code I'm trying to access it like this:

string mySelectQuery = "SELECT * FROM sometable'";
string myConnectString = ConfigurationSe ttings.AppSetti ngs["NDDbase"];

SqlCommand myCommand = new SqlCommand(mySe lectQuery);
myCommand.Conne ction = new SqlConnection(m yConnectString) ;
But when debugging, I see that myConnectString value always starts with
an @, like this:
@"Server=SOMESE RVER\\SOMEINSTA NCE;integrated
security=SSPI;d atabase=NDD"

is this normal? I could parse the string and remove the at-sign but I
suppose is there for a reason. This makes the SqlConnection to not
open, as it is not initialized properly.

help me and write me some suggestions please, thanks =)

Regards
Laura Lucas

[lauralucas]

the answer:

It means that any backslash characters displayed aren't used for escape
purposes. For instance:

@"hello\twor ld" is hello backslash tworld
whereas
"hello\twor ld" is hello tab world

thanks

la********@gmai l.com wrote:

now that I look at it, the at-sign is not part of the string, look at
this picture:

http://i7.tinypic.com/20tgj08.jpg

weird, what does it mean?
la********@gmai l.com wrote:

Hello

I'm trying to use a connection string stored in web.config

here is the web.config part

<appSettings>
<add key="NDDbase"
value="Server=S OMESERVER\\SOME INSTANCE;integr ated
security=SSPI;d atabase=NDD"/>
</appSettings>

and from code I'm trying to access it like this:

string mySelectQuery = "SELECT * FROM sometable'";
string myConnectString = ConfigurationSe ttings.AppSetti ngs["NDDbase"];

SqlCommand myCommand = new SqlCommand(mySe lectQuery);
myCommand.Conne ction = new SqlConnection(m yConnectString) ;
But when debugging, I see that myConnectString value always starts with
an @, like this:
@"Server=SOMESE RVER\\SOMEINSTA NCE;integrated
security=SSPI;d atabase=NDD"

is this normal? I could parse the string and remove the at-sign but I
suppose is there for a reason. This makes the SqlConnection to not
open, as it is not initialized properly.

help me and write me some suggestions please, thanks =)

Regards
Laura Lucas