Connection String not initialized

[rodchar]

hey all,

SqlDataAdapter da = new SqlDataAdapter(@"Select * from Products",
ConfigurationSettings.AppSettings["NorthwindConnectionString"]);
DataTable tbl = new DataTable();
da.Fill(tbl);

Can someone please tell me what I'm missing?

thanks,
rodchar

 

[Scott Roberts]

Connection strings are *typically* stored in the <ConnectionStrings> section
of web.config, not <AppSettings>. If that's the case, try this:

string dbConnection =
ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;

 

[Milosz Skalecki [MCAD]]

Hi there Rod,

Don't get me wrong but I would suggest you to start using every's
programmer's best friend - debugger. In this particular case seems connection
string is not defined in app settings, maybe there's a typo in the web.config
or it's defined but under connectionStrings section. Debugger will save you
time as you can pick up bugs much quicker than asking questions and waiting
for the reply.

Have a good night

 

[rodchar]

You are right that it's in the connectionStrings section, how do you get to
that?

Hi there Rod,

Don't get me wrong but I would suggest you to start using every's
programmer's best friend - debugger. In this particular case seems connection
string is not defined in app settings, maybe there's a typo in the web.config
or it's defined but under connectionStrings section. Debugger will save you
time as you can pick up bugs much quicker than asking questions and waiting
for the reply.

Have a good night
--
Milosz

hey all,

SqlDataAdapter da = new SqlDataAdapter(@"Select * from Products",
ConfigurationSettings.AppSettings["NorthwindConnectionString"]);
DataTable tbl = new DataTable();
da.Fill(tbl);

Can someone please tell me what I'm missing?

thanks,
rodchar

 

[David Wier]

What exactly do you mean by 'how do you get to that?"
The web.config file is a file, like any other in the root directory of the
website, that you can open and edit.

David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup

You are right that it's in the connectionStrings section, how do you get
to
that?

Hi there Rod,

Don't get me wrong but I would suggest you to start using every's
programmer's best friend - debugger. In this particular case seems
connection
string is not defined in app settings, maybe there's a typo in the
web.config
or it's defined but under connectionStrings section. Debugger will save
you
time as you can pick up bugs much quicker than asking questions and
waiting
for the reply.

Have a good night
--
Milosz

hey all,

SqlDataAdapter da = new SqlDataAdapter(@"Select * from Products",
ConfigurationSettings.AppSettings["NorthwindConnectionString"]);
DataTable tbl = new DataTable();
da.Fill(tbl);

Can someone please tell me what I'm missing?

thanks,
rodchar

 

[Scott Roberts]

string dbConnection =
ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;

You are right that it's in the connectionStrings section, how do you get
to
that?

Hi there Rod,

Don't get me wrong but I would suggest you to start using every's
programmer's best friend - debugger. In this particular case seems
connection
string is not defined in app settings, maybe there's a typo in the
web.config
or it's defined but under connectionStrings section. Debugger will save
you
time as you can pick up bugs much quicker than asking questions and
waiting
for the reply.

Have a good night
--
Milosz

hey all,

SqlDataAdapter da = new SqlDataAdapter(@"Select * from Products",
ConfigurationSettings.AppSettings["NorthwindConnectionString"]);
DataTable tbl = new DataTable();
da.Fill(tbl);

Can someone please tell me what I'm missing?

thanks,
rodchar

 

[Milosz Skalecki [MCAD]]

Howdy,

c#
System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString

vb.net
System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionStringName").ConnectionString

HTH
--
Milosz

You are right that it's in the connectionStrings section, how do you get to
that?

Hi there Rod,

Don't get me wrong but I would suggest you to start using every's
programmer's best friend - debugger. In this particular case seems connection
string is not defined in app settings, maybe there's a typo in the web.config
or it's defined but under connectionStrings section. Debugger will save you
time as you can pick up bugs much quicker than asking questions and waiting
for the reply.

Have a good night
--
Milosz

hey all,

SqlDataAdapter da = new SqlDataAdapter(@"Select * from Products",
ConfigurationSettings.AppSettings["NorthwindConnectionString"]);
DataTable tbl = new DataTable();
da.Fill(tbl);

Can someone please tell me what I'm missing?

thanks,
rodchar

 

[rodchar]

thanks again everyone for the feedback.
rod.