Oh No a Global Variable

[Mike L]

This is for a Win form.

Currently I have several connection strings that are identical through out
my application. Is a global variable the best choice for this situation? If
so, what is the code to make a global string variable, and where do I put it,
(before the namespace, of just under it)?????

[Wayne]

You can't have variables outside of a class. Try it and you'll get a compile
error (I just tried). I would suggest having a config file that stores your
connection string, and maybe a singleton settings class that is responsible
for retrieving all of your settings. This way you are sure your entire app
is using the same values, and you only retrieve them in one place.

--
Thanks
Wayne Sepega
Jacksonville, Fl

Enterprise Library Configuration Console Module Generator
http://workspaces.gotdotnet.com/elccmg

"When a man sits with a pretty girl for an hour, it seems like a minute. But
let him sit on a hot stove for a minute and it's longer than any hour.
That's relativity." - Albert Einstein

"Mike L" <Ca***@nospam.n ospam> wrote in message
news:13******** *************** ***********@mic rosoft.com...

This is for a Win form.

Currently I have several connection strings that are identical through out
my application. Is a global variable the best choice for this situation?
If
so, what is the code to make a global string variable, and where do I put
it,
(before the namespace, of just under it)?????

[Joanna Carter \(TeamB\)]

"Mike L" <Ca***@nospam.n ospam> a écrit dans le message de news:
13************* *************** **...icrosof t.com...

Currently I have several connection strings that are identical through out
my application. Is a global variable the best choice for this situation? If so, what is the code to make a global string variable, and where do I put it, (before the namespace, of just under it)?????

The usual solultion for this is to have a static class of static methods or
properties that return the necessary "global" values.

static class Settings
{
public static string MyValue
{
get
{
return "MyValue";
}
}
}

Then you can use it like this :

{
string user = Settings.MyValu e;
...
}

Joanna

--
Joanna Carter
Consultant Software Engineer

[Mike L]

I added a config file but it looks like xml code. Will this work for my win
form application?

"Wayne" wrote:

You can't have variables outside of a class. Try it and you'll get a compile
error (I just tried). I would suggest having a config file that stores your
connection string, and maybe a singleton settings class that is responsible
for retrieving all of your settings. This way you are sure your entire app
is using the same values, and you only retrieve them in one place.

--
Thanks
Wayne Sepega
Jacksonville, Fl

Enterprise Library Configuration Console Module Generator
http://workspaces.gotdotnet.com/elccmg

"When a man sits with a pretty girl for an hour, it seems like a minute. But
let him sit on a hot stove for a minute and it's longer than any hour.
That's relativity." - Albert Einstein

"Mike L" <Ca***@nospam.n ospam> wrote in message
news:13******** *************** ***********@mic rosoft.com...

This is for a Win form.

Currently I have several connection strings that are identical through out
my application. Is a global variable the best choice for this situation?
If
so, what is the code to make a global string variable, and where do I put
it,
(before the namespace, of just under it)?????

[Ollie Riches]

Mike,

You are probably best adding a application configuration file to your
application and storing the value in there and then reading out the value as
required at runtime.

check out for asp.net sample:
http://msdn.microsoft.com/msdntv/epi...H/manifest.xml

Check out for winform sample:
Search for the text 'Using XML Application Configuration Files'
http://msdn.microsoft.com/library/de.../html/daag.asp

HTH

Ollie Riches
"Mike L" <Ca***@nospam.n ospam> wrote in message
news:13******** *************** ***********@mic rosoft.com...

This is for a Win form.

Currently I have several connection strings that are identical through out
my application. Is a global variable the best choice for this situation?
If
so, what is the code to make a global string variable, and where do I put
it,
(before the namespace, of just under it)?????

[Mark White]

I would go with a App.config file. That is exactly it's purpose, it's
secure and already accessible. No need to reinvent the wheel.

Add a key (XML format) to the App.config file, then use
System.Configur ationSettings.A ppSettings to retrieve the value, ex:
string sDsn = ConfigurationSe ttings.AppSetti ngs["dsn"];

Regards,
Mark
"Mike L" <Ca***@nospam.n ospam> wrote in message
news:13******** *************** ***********@mic rosoft.com...

This is for a Win form.

Currently I have several connection strings that are identical through out
my application. Is a global variable the best choice for this situation? If so, what is the code to make a global string variable, and where do I put it, (before the namespace, of just under it)?????

[Mark White]

Yes. Like so:
<?xml version="1.0" encoding="utf-8" ?>

<configuratio n>

<appSettings>

<add key="dsn" value="Server=( local);Database =XXXX;User
ID=XXXX;Passwor d=XXXXXXXX" />

</appSettings>

</configuration>

"Mike L" <Ca***@nospam.n ospam> wrote in message
news:D7******** *************** ***********@mic rosoft.com...

I added a config file but it looks like xml code. Will this work for my win form application?

"Wayne" wrote:

You can't have variables outside of a class. Try it and you'll get a compile error (I just tried). I would suggest having a config file that stores your connection string, and maybe a singleton settings class that is responsible for retrieving all of your settings. This way you are sure your entire app is using the same values, and you only retrieve them in one place.

--
Thanks
Wayne Sepega
Jacksonville, Fl

Enterprise Library Configuration Console Module Generator
http://workspaces.gotdotnet.com/elccmg

"When a man sits with a pretty girl for an hour, it seems like a minute. But let him sit on a hot stove for a minute and it's longer than any hour.
That's relativity." - Albert Einstein

"Mike L" <Ca***@nospam.n ospam> wrote in message
news:13******** *************** ***********@mic rosoft.com...

This is for a Win form.

Currently I have several connection strings that are identical through out my application. Is a global variable the best choice for this situation? If
so, what is the code to make a global string variable, and where do I put it,
(before the namespace, of just under it)?????

[Mike L]

I this line of code: string sConnString =
ConfigurationSe ttings.AppSetti ngs["dsn"];

I get the error: The type or namespace name 'ConfigurationS ettings' could
not be found (are you missing a using directive or an assembly reference?)
I also tried: string sConnString = configuration.a ppSetting["dsn"];
I get the error: The type or namespace name 'configuration' could not be
found (are you missing a using directive or an assembly reference?)

Here is the App.config code, I removed the password for security.

<?xml version="1.0" encoding="utf-8" ?>
<configuratio n>

<appSetting>

<add key="dsn" value="Data Source=db;Datab ase=License;Int egrated
Security=False; User ID=sa;password= REMOVED" />

</appSetting>

</configuration>

"Mark White" wrote:

I would go with a App.config file. That is exactly it's purpose, it's
secure and already accessible. No need to reinvent the wheel.

Add a key (XML format) to the App.config file, then use
System.Configur ationSettings.A ppSettings to retrieve the value, ex:
string sDsn = ConfigurationSe ttings.AppSetti ngs["dsn"];

Regards,
Mark
"Mike L" <Ca***@nospam.n ospam> wrote in message
news:13******** *************** ***********@mic rosoft.com...

This is for a Win form.

Currently I have several connection strings that are identical through out
my application. Is a global variable the best choice for this situation?

If

so, what is the code to make a global string variable, and where do I put

it,

(before the namespace, of just under it)?????

[Mark White]

Mike

It would be: System.Configur ation.Configura tionSettings.Ap pSettings["dsn"]
-OR-
using System.Configur ation;
then in the code you can use: ConfigurationSe ttings.AppSetti ngs["dsn"];

"Mike L" <Ca***@nospam.n ospam> wrote in message
news:06******** *************** ***********@mic rosoft.com...

I this line of code: string sConnString =
ConfigurationSe ttings.AppSetti ngs["dsn"];

I get the error: The type or namespace name 'ConfigurationS ettings' could
not be found (are you missing a using directive or an assembly reference?)
I also tried: string sConnString = configuration.a ppSetting["dsn"];
I get the error: The type or namespace name 'configuration' could not be
found (are you missing a using directive or an assembly reference?)

Here is the App.config code, I removed the password for security.

<?xml version="1.0" encoding="utf-8" ?>
<configuratio n>

<appSetting>

<add key="dsn" value="Data Source=db;Datab ase=License;Int egrated
Security=False; User ID=sa;password= REMOVED" />

</appSetting>

</configuration>

"Mark White" wrote:

I would go with a App.config file. That is exactly it's purpose, it's
secure and already accessible. No need to reinvent the wheel.

Add a key (XML format) to the App.config file, then use
System.Configur ationSettings.A ppSettings to retrieve the value, ex:
string sDsn = ConfigurationSe ttings.AppSetti ngs["dsn"];

Regards,
Mark
"Mike L" <Ca***@nospam.n ospam> wrote in message
news:13******** *************** ***********@mic rosoft.com...

This is for a Win form.

Currently I have several connection strings that are identical through out my application. Is a global variable the best choice for this

situation? If

so, what is the code to make a global string variable, and where do I

put it,

(before the namespace, of just under it)?????

[Jon Skeet [C# MVP]]

Mike L <Ca***@nospam.n ospam> wrote:

I this line of code: string sConnString =
ConfigurationSe ttings.AppSetti ngs["dsn"];

I get the error: The type or namespace name 'ConfigurationS ettings' could
not be found (are you missing a using directive or an assembly reference?)

That suggests you're missing the using directive:

using System.Configur ation;

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too