Re: Passing the connection string from a web form to a business lo
- From: "Juan T. Llibre" <nomailreplies@xxxxxxxxxxx>
- Date: Wed, 9 Nov 2005 11:17:57 -0400
Just import system.configuration and use :
string sConnString = System.Configuration.ConfigurationManager.AppSettings["dsn"];
The thing is that the ConfigurationManager class isn't meant to be used
just to read a key and insert the key's string value into a connection.
It's meant to be used to *modify* configuration files.
If you just want to read a value in web.config, use :
System.Configuration.ConfigurationSettings.AppSettings["dsn"];
Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"Mike L" <Cadel@xxxxxxxxxxxxx> wrote in message
news:F1CF1091-F405-4E63-B72D-8F51DC776ABE@xxxxxxxxxxxxxxxx
> 'System' does not exist in the namespace 'System.Configuration'
>
> I added C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.configuration.dll
> I also added using System.Configuration;
>
> Here is the line of code it errors on.
> string sConnString =
> System.Configuration.System.Configuration.ConfigurationManager.AppSettings["dsn"];
>
>
> For now, I'm staying with ConfigurationSettings and live with the warnings.
> string sConnString =
> System.Configuration.ConfigurationSettings.AppSettings["dsn"];
>
>
> "Juan T. Llibre" wrote:
>
>> Hi, Greg.
>>
>> re:
>> > Can anyone explain?
>>
>> System.Configuration.ConfigurationSettings.AppSettings
>> is a class in the System.Configuration namespace in system.dll.
>>
>> System.Configuration.ConfigurationManager.AppSettings isn't.
>>
>> See :
>>
>> http://www.asp.net/QUICKSTART/util/classbrowser.aspx?namespace=System.Configuration
>>
>> Configuration.ConfigurationManager is a class which resides in
>> System.Configuration (in system.configuration.dll), not in system.dll
>> which is where Configuration.ConfigurationSettings.AppSettings resides.
>>
>> It's a bit confusing because the System.Configuration first names seem the same,
>> but -just like you do with people- you need a first name *and* a last name
>> to identify individuals.
>>
>> The System.Configuration class in System.dll is really System.System.Configuration
>> ( notice the *two* "system" in the name ) but we don't have to identify the base
>> namespace because it's automatically imported in all aspx pages.
>>
>> If you want to use the ConfigurationManager.AppSettings class which is
>> a part of system.configuration.dll without importing the namespace,
>> you'll need to use its full name :
>>
>> System.Configuration.System.Configuration.ConfigurationManager.AppSettings
>>
>> That because the System.Configuration.System.Configuration namespace
>> is *not* imported automatically into every aspx page.
>>
>> I hope this is clearer to you now.
>>
>>
>>
>> Juan T. Llibre, ASP.NET MVP
>> ASP.NET FAQ : http://asp.net.do/faq/
>> ASPNETFAQ.COM : http://www.aspnetfaq.com/
>> Foros de ASP.NET en Español : http://asp.net.do/foros/
>> ======================================
>> "Greg Burns" <bluebunny@xxxxxxxxxxxxxxxxx> wrote in message
>> news:utHTBAN5FHA.252@xxxxxxxxxxxxxxxxxxxxxxx
>> > FYI, to actually use System.Configuration.ConfigurationManager.AppSettings in 2.0 you
>> > must add a reference to System.configuration.dll. (I wasted a lot of time trying to
>> > figure that out).
>> >
>> > This is not necessary to do to use
>> > System.Configuration.ConfigurationSettings.AppSettings and I not sure why. Can anyone
>> > explain?
>> >
>> > Greg
>> >
>> > "Jaime Stuardo" <jstuardo@xxxxxxxxxxxxx> wrote in message
>> > news:uMErc0M5FHA.884@xxxxxxxxxxxxxxxxxxxxxxx
>> >> Hi Patrick..
>> >>
>> >> I cannot do that since this method is in a DLL that is referenced by the ASP.NET
>> >> project. When I use AppSettings from the component, I receive a null. However I
>> >> think I
>> >> could use what you suggested if I have public DataSet GetCategories(String
>> >> connectionStr).
>> >>
>> >> By the way, I use ASP.NET 2.0 and in this version ConfigurationSettings.AppSettings
>> >> is
>> >> reported as obsolete. I should use ConfigurationManager.AppSettings instead.
>> >>
>> >> Jaime
>> >>
>> >> "Patrick.O.Ige" <naijacoder@xxxxxxxxxxx> wrote in message
>> >> news:emOmcoM5FHA.2364@xxxxxxxxxxxxxxxxxxxxxxx
>> >>> if you have it in Web.Config like:-
>> >>> <add key="ConnectionString" value="server=(local);database=YourDB;integrated
>> >>> security=true;" />
>> >>> Then in you app do:-
>> >>> myconnection = New
>> >>> SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
>> >>> Is that what you are looking for.
>> >>> Patrick
>> >>>
>> >>>
>> >>> "Jaime Stuardo" <jstuardo@xxxxxxxxxxxxx> wrote in message
>> >>> news:efEeFlM5FHA.4012@xxxxxxxxxxxxxxxxxxxxxxx
>> >>>> Hi all..
>> >>>>
>> >>>> I have created a business logic component that is used from my ASP.NET
>> >>>> webform. It works, but connection string to the database is hard coded, as
>> >>>> in this method :
>> >>>>
>> >>>> public DataSet GetCategories()
>> >>>> {
>> >>>> SqlConnection conn = new SqlConnection("Data Source=DEVSERVER;Initial
>> >>>> Catalog=XXXX;User ID=X;Password=Y");
>> >>>> SqlDataAdapter adapter = new SqlDataAdapter("SELECT CAT_ID, CAT_NOM
>> >>> FROM
>> >>>> CATEGORIA ORDER BY CAT_NOM", conn);
>> >>>> DataSet ds = new DataSet();
>> >>>> adapter.Fill(ds);
>> >>>> return ds;
>> >>>> }
>> >>>>
>> >>>> I need to know what is the best way to pass the connection string that is
>> >>>> present in the web.config file. I tried using a constructor in that
>> >>> business
>> >>>> class but with no success. Also I have read that ObjectDataSource uses
>> >>>> stateless components so I think the usage of properties isn't allowed
>> >>> here.
>> >>>>
>> >>>> The question is, the only solution I could implement is passing the
>> >>>> connection string as a parameter to GetCategories? is there another one?
>> >>>> Since this method resides in a DLL, I cannot use ConnectionManager class
>> >>> to
>> >>>> access web.config file.
>> >>>>
>> >>>> Thanks a lot
>> >>>> Jaime
>> >>>>
>> >>>>
>> >>>
>> >>>
>> >>
>> >>
>> >
>> >
>>
>>
>>
.
- Prev by Date: Re: Exception Running App v/NTD
- Next by Date: Re: Cannot convert type 'ASP.login_aspx' to 'System.Web.UI.WebControls.Login'
- Previous by thread: Re: Exception Running App v/NTD
- Next by thread: Re: Passing the connection string from a web form to a business lo
- Index(es):
Relevant Pages
|
Loading
