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.nospam> wrote in message
news:13**********************************@microsof t.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.nospam> a écrit dans le message de news:
13**********************************@microsoft.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.MyValue;
...
}

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.nospam> wrote in message
news:13**********************************@microsof t.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.nospam> wrote in message
news:13**********************************@microsof t.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.ConfigurationSettings.AppSettings to retrieve the value, ex:
string sDsn = ConfigurationSettings.AppSettings["dsn"];

Regards,
Mark
"Mike L" <Ca***@nospam.nospam> wrote in message
news:13**********************************@microsof t.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" ?>

<configuration>

<appSettings>

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

</appSettings>

</configuration>

"Mike L" <Ca***@nospam.nospam> wrote in message
news:D7**********************************@microsof t.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.nospam> wrote in message
news:13**********************************@microsof t.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 =
ConfigurationSettings.AppSettings["dsn"];

I get the error: The type or namespace name 'ConfigurationSettings' could
not be found (are you missing a using directive or an assembly reference?)
I also tried: string sConnString = configuration.appSetting["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" ?>
<configuration>

<appSetting>

<add key="dsn" value="Data Source=db;Database=License;Integrated
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.ConfigurationSettings.AppSettings to retrieve the value, ex:
string sDsn = ConfigurationSettings.AppSettings["dsn"];

Regards,
Mark
"Mike L" <Ca***@nospam.nospam> wrote in message
news:13**********************************@microsof t.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.Configuration.ConfigurationSettings.AppSett ings["dsn"]
-OR-
using System.Configuration;
then in the code you can use: ConfigurationSettings.AppSettings["dsn"];

"Mike L" <Ca***@nospam.nospam> wrote in message
news:06**********************************@microsof t.com...

I this line of code: string sConnString =
ConfigurationSettings.AppSettings["dsn"];

I get the error: The type or namespace name 'ConfigurationSettings' could
not be found (are you missing a using directive or an assembly reference?)
I also tried: string sConnString = configuration.appSetting["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" ?>
<configuration>

<appSetting>

<add key="dsn" value="Data Source=db;Database=License;Integrated
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.ConfigurationSettings.AppSettings to retrieve the value, ex:
string sDsn = ConfigurationSettings.AppSettings["dsn"];

Regards,
Mark
"Mike L" <Ca***@nospam.nospam> wrote in message
news:13**********************************@microsof t.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.nospam> wrote:

I this line of code: string sConnString =
ConfigurationSettings.AppSettings["dsn"];

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

That suggests you're missing the using directive:

using System.Configuration;

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

[Michael S]

Hi Joanna.
What is a static class in C#? Please tell us... <vbg>

Anyways, I think would simply do this:

public class DataAccess
{
public static readonly string ConnectionString =
ConfigurationSettings.AppSettings["ConnectionString"];
}

Or better, provide a simple factory for connections.

public class DataAccess
{
private DataAccess() { }
private static readonly string connectionString =
ConfigurationSettings.AppSettings["ConnectionString"];
public static SqlConnection Create()
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
return conn;
}
}

Happy Coding
- Michael S


"Joanna Carter (TeamB)" <jo*****@nospamforme.com> wrote in message
news:eR*************@tk2msftngp13.phx.gbl...

"Mike L" <Ca***@nospam.nospam> a écrit dans le message de news:
13**********************************@microsoft.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.MyValue;
...
}

Joanna

--
Joanna Carter
Consultant Software Engineer

[Mike L]

Now I get this error:

An unhandled exception of type 'System.Configuration.ConfigurationException'
occurred in system.dll

Additional information: Unrecognized configuration section appSetting


Here is my code, password as be removed for security.

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

<appSetting>

<add key="dsn" value="Data Source=db;Database=License;Integrated
Security=False;User ID=sa;password=REMOVED" />

</appSetting>

</configuration>

I have tried both, string sConnString =
System.Configuration.ConfigurationSettings.AppSett ings["dsn"]; and string
sConnString = ConfigurationSettings.AppSettings["dsn"];
I get the error on both.

Added info, if this helps. The call to string sConnString =
System.Configuration.ConfigurationSettings.AppSett ings["dsn"]; is on Load of
my Win Form named frmDataEntry, and the file name for storing the value is
named App.config

"Mark White" wrote:

Mike

It would be: System.Configuration.ConfigurationSettings.AppSett ings["dsn"]
-OR-
using System.Configuration;
then in the code you can use: ConfigurationSettings.AppSettings["dsn"];

"Mike L" <Ca***@nospam.nospam> wrote in message
news:06**********************************@microsof t.com...

I this line of code: string sConnString =
ConfigurationSettings.AppSettings["dsn"];

I get the error: The type or namespace name 'ConfigurationSettings' could
not be found (are you missing a using directive or an assembly reference?)
I also tried: string sConnString = configuration.appSetting["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" ?>
<configuration>

<appSetting>

<add key="dsn" value="Data Source=db;Database=License;Integrated
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.ConfigurationSettings.AppSettings to retrieve the value, ex:
string sDsn = ConfigurationSettings.AppSettings["dsn"];

Regards,
Mark
"Mike L" <Ca***@nospam.nospam> wrote in message
news:13**********************************@microsof t.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]

it is called <appSettings> NOT <appsetting>

HTH

Ollie Riches

"Mike L" <Ca***@nospam.nospam> wrote in message
news:C1**********************************@microsof t.com...

Now I get this error:

An unhandled exception of type
'System.Configuration.ConfigurationException'
occurred in system.dll

Additional information: Unrecognized configuration section appSetting


Here is my code, password as be removed for security.

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

<appSetting>

<add key="dsn" value="Data Source=db;Database=License;Integrated
Security=False;User ID=sa;password=REMOVED" />

</appSetting>

</configuration>

I have tried both, string sConnString =
System.Configuration.ConfigurationSettings.AppSett ings["dsn"]; and string
sConnString = ConfigurationSettings.AppSettings["dsn"];
I get the error on both.

Added info, if this helps. The call to string sConnString =
System.Configuration.ConfigurationSettings.AppSett ings["dsn"]; is on Load
of
my Win Form named frmDataEntry, and the file name for storing the value is
named App.config

"Mark White" wrote:

Mike

It would be:
System.Configuration.ConfigurationSettings.AppSett ings["dsn"]
-OR-
using System.Configuration;
then in the code you can use: ConfigurationSettings.AppSettings["dsn"];

"Mike L" <Ca***@nospam.nospam> wrote in message
news:06**********************************@microsof t.com...

> I this line of code: string sConnString =
> ConfigurationSettings.AppSettings["dsn"];
>
> I get the error: The type or namespace name 'ConfigurationSettings'
> could
> not be found (are you missing a using directive or an assembly
> reference?)
>
>
> I also tried: string sConnString = configuration.appSetting["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" ?>
> <configuration>
>
> <appSetting>
>
> <add key="dsn" value="Data Source=db;Database=License;Integrated
> 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.ConfigurationSettings.AppSettings to retrieve the value, ex:
> > string sDsn = ConfigurationSettings.AppSettings["dsn"];
> >
> > Regards,
> > Mark
> >
> >
> > "Mike L" <Ca***@nospam.nospam> wrote in message
> > news:13**********************************@microsof t.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]]

Michael S <a@b.c> wrote:

What is a static class in C#? Please tell us... <vbg>

In C# 2.0, it's a class which is declared as being static. It is
implicitly sealed, has *no* constructors (private or public), and all
its members have to be static.

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

[Mike L]

Once I corrected my App.config file to appSettings, it worked!!!

Thank you everyone!!

"Ollie Riches" wrote:

it is called <appSettings> NOT <appsetting>

HTH

Ollie Riches

"Mike L" <Ca***@nospam.nospam> wrote in message
news:C1**********************************@microsof t.com...

Now I get this error:

An unhandled exception of type
'System.Configuration.ConfigurationException'
occurred in system.dll

Additional information: Unrecognized configuration section appSetting


Here is my code, password as be removed for security.

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

<appSetting>

<add key="dsn" value="Data Source=db;Database=License;Integrated
Security=False;User ID=sa;password=REMOVED" />

</appSetting>

</configuration>

I have tried both, string sConnString =
System.Configuration.ConfigurationSettings.AppSett ings["dsn"]; and string
sConnString = ConfigurationSettings.AppSettings["dsn"];
I get the error on both.

Added info, if this helps. The call to string sConnString =
System.Configuration.ConfigurationSettings.AppSett ings["dsn"]; is on Load
of
my Win Form named frmDataEntry, and the file name for storing the value is
named App.config

"Mark White" wrote:

Mike

It would be:
System.Configuration.ConfigurationSettings.AppSett ings["dsn"]
-OR-
using System.Configuration;
then in the code you can use: ConfigurationSettings.AppSettings["dsn"];

"Mike L" <Ca***@nospam.nospam> wrote in message
news:06**********************************@microsof t.com...
> I this line of code: string sConnString =
> ConfigurationSettings.AppSettings["dsn"];
>
> I get the error: The type or namespace name 'ConfigurationSettings'
> could
> not be found (are you missing a using directive or an assembly
> reference?)
>
>
> I also tried: string sConnString = configuration.appSetting["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" ?>
> <configuration>
>
> <appSetting>
>
> <add key="dsn" value="Data Source=db;Database=License;Integrated
> 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.ConfigurationSettings.AppSettings to retrieve the value, ex:
> > string sDsn = ConfigurationSettings.AppSettings["dsn"];
> >
> > Regards,
> > Mark
> >
> >
> > "Mike L" <Ca***@nospam.nospam> wrote in message
> > news:13**********************************@microsof t.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)?????
> > >
> >
> >
> >

[Michael S]

Oh.

I and was sitting hare having a laugh at Joanna (as she is seldom wrong).
Sorry Joanna and thanks Jon.

Happy Static
- Michael S

"Jon Skeet [C# MVP]" <sk***@pobox.com> wrote in message
news:MP************************@msnews.microsoft.c om...

Michael S <a@b.c> wrote:

What is a static class in C#? Please tell us... <vbg>

In C# 2.0, it's a class which is declared as being static. It is
implicitly sealed, has *no* constructors (private or public), and all
its members have to be static.

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

[nikita parekh]

hi

*** Sent via Developersdex http://www.developersdex.com ***

[Michael S]

hi

"nikita parekh" <ni***********@indiatimes.com> wrote in message
news:er**************@TK2MSFTNGP10.phx.gbl...

hi

*** Sent via Developersdex http://www.developersdex.com ***