Search results matching tag 'ConfigurationElement'

declare connection string in app.config in WPF

kpxkpx — Sat, 05 May 2007 04:00:00 GMT

Dear all,

Here is my question. I am trying to build up a object data source that will to be bound to xaml object in WPF. After I declare a connectionString in app.config of object data source project, the connectionString can not be found and show the error below:

"Object reference not set to an instance of an object."

app.config file:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="Connection" connectionString="Data Source=***;Initial Catalog=***;User ID=***;Password=***" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>

cs code:

string _connectionString =ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;

Can any one tell me what I did wrong? Many thanks.

______________________________________________________________________________________

After that, I though that it may be work if use connection string in code, but I got new error as below:

"Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."

CS:

string _connectionString="Data Source=***;Initial Catalog=***;User ID=***;Password=***" ;

SqlClientPermission permission = new SqlClientPermission(PermissionState.None);
            permission.Add(_connectionString, "", KeyRestrictionBehavior.AllowOnly);
            permission.PermitOnly();

string sqlCmd = "select * from OBJ_WORK_ITEMS where ITEM_ID=38";

SqlConnection conn = new SqlConnection(_connectionString);
SqlDataAdapter da = new SqlDataAdapter(sqlCmd, conn);

DataSet ds = new DataSet();

            try
            {
                conn.Open();
                da.Fill(ds, "OBJ_WORK_ITEMS");
            }
            catch (Exception ee)
            {
                throw new Exception("Something wrong in da.fill()" + ee);
            }
            finally
            {
                conn.Close();
            }

You can see I tried to modify SqlClientPermission to make it work, but no luck. Please help me!

Supporting configSource attribute on custom ConfigurationSectionGroup

sandor — Thu, 26 Apr 2007 04:00:00 GMT

I would like to support the configSource attribute on my custom ConfigurationSectionGroup in order to allow for storage of the group contents in an external .config file. Unfortunately, I have no clue how to do this in a proper manner, other than writing custom code that loads and processes the external file. The latter is probably not a good idea because the logic is allegedly available in the .NET framework (as some of the built-in section groups, like <profiles> support it), though I don't know how to make use of it.

serving webresource.axd over https

Ahmad49 — Sat, 10 Feb 2007 05:00:00 GMT

I am observing (via fiddler) a problem where "webresource.axd" files are
being deployed over http (port 80) hot https (443) even when the request is
https://xxx.xx.
IE6 doesn't seem to mind this and reports the page as secure (padlock
closed) but Firefox 1.5 on the other hand reports the page a partially secure
(padlock closed with red line through it).
Disabling Javascript on the Firefox Browser allows the page to become fully
secure (no red line in the padlock).
I have read several blogs on this and specifically Scott Gu's blog entry
http://weblogs.asp.net/scottgu/archive/2006/04/11/Don_1920_t-run-production-ASP.NET-Applications-with-debug_3D001D20_true_1D20_-enabled.aspx
and have performed his suggestion of setting Debug=false on the compilation
directive to no avail! Page is still showing as insecure in Firefox.
Fiddler shows me two webresource entries being downloaded on http rather
than https, is this normal?
Does anyone have any ideas on this, its bugging the hell out of me and my
client is moaning about the Firefox partially secure message on the secure
pages on the site including the login page.
BTW ASPNET validators are used on this page.

I am sure sone one has seen this before please help to solve this problem.

Thank,

Ahmad...

How to add AppSettings key / value pair's dynamically in web Config file

BalaKrishnan — Thu, 01 Feb 2007 05:00:00 GMT

Is it possible to add Dynamically AppSetting Key / value pair's in webconfig file?

if yes,

How? anybody can explain! through C# Coding

Thanks in advance

Balakrishnan

User credentils popup

Jayapradha — Tue, 21 Nov 2006 05:00:00 GMT

I have a ASP.NET application with windows authentication and session state is inproc.

when I access this application from the local computer it runs fine.

But in Remote in one page it asking again user credentails by one popup. if we cancel that once then we are getting unaturized to view this page.

if u click ok then then it proceeds and again asking user credentials.

this problem i am getting in one page

this page takes 5 mintues to popluate the data.

In this page database operation and some calculatons are there.

in the locla system also it takes 5 min to load but after that it is working fine. but in the remote after 5 mintues it is open a popup asking user credentials.

what is the problem.

please assist me.

please this is very urjent.

Please help me out

thanks in Advnace

Jayapradha Mallepally

how to modify the web.config file when application is running by code

Corny — Fri, 15 Sep 2006 04:00:00 GMT

yes , i got some idea from msdn about OpenWebConfiguration and OpenExeConfiguration Method,and i do some test about it , what's happed?

when i modify something like connectionString and CustomeSection by code, it's ok when application running, even the connectionstrings is readonly( it's too many properties was readonly ),no any exception, but the value had no saved to disk. when the application was shutdown, all the value of my modified all lost.

Why?

anyone would tell me ? thks very much!!

Re: Custom Config Section, .NET 2.0

rrahlf — Tue, 12 Sep 2006 04:00:00 GMT

Well, I did finaly get this working. I'll post some links and some advice here for anyone else who is looking.

One of my major problems with implementing a custom config section in .NET 2.0 was the lack of solid documentation. It's there, but not very deep, and the "example below" examples all seem to be missing at the time I'm writing this. I was able to piece things together thanks to some tenacious people with blogs. Here's a list of links that helped me out, in no particular order.

http://fredrik.nsquared2.com/viewpost.aspx?PostID=233

http://msdn2.microsoft.com/en-us/library/ms228062.aspx

http://blogs.msdn.com/markgabarra/archive/2006/06/27/648742.aspx

http://blogs.msdn.com/markgabarra/archive/2006/06/25/646775.aspx

http://msdn.microsoft.com/msdnmag/issues/06/06/ConfigureThis/

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=132716&SiteID=1&mode=1

http://www.agileprogrammer.com/oneagilecoder/archive/2005/06/11/3689.aspx

http://jason.diamond.name/weblog/2006/05/25/custom-configuration-section-validator-weirdness

That last link was particularly helpful; it set me in the right direction. Jason Diamond admits that he didn't look deep enough into the problem to find the reason, but I think I may have found the answer in the Microsoft forums (third last link).

In my mind, the declarative programming model for custom config sections is broken. The issue is with default values, validators, and the ConfigurationElement base class constructor.

It seems that the ConfigurationElement base constructor attempts to set "default" values for your ConfigurationElement's properties. If it's an integer property, the ConfigurationElement constructor will attempt to assign a zero to it, "" for a String etc. Reasonably, this default assignment is still passed through any validation you may have assigned to the property declaritively using an attribute, since the declarative validation attribute's routines are attached to the properties before the constructor attempts to assign a default value (I think).

However, as Jason Diamond and Paul D. Murphy point out, this becomes a problem if, for example, your validation says that your integer property needs to be between 2 and 5; zero is invalid. OK, so you also decorate your property with the DefaultValue attribute and inform the ConfigurationElement constuctor that when it assigns a value to that property, it should use, say, 3 instead of zero. Now the framework can instantiate your ConfigurationElement derived class without the validator throwing an error. But.

Now you have a property of your ConfigurationElement that has a default value. Default value...that means that the implementor/user of your custom configuration section is no longer required to type in a value for that property (an attribute on an xml tag in the config file). What if you wanted to require that the implementor type a value? You're stuck, if you wanted to use the declarative model to code your custom config section. The only solution is to use the programatic model.

Justin Diamonds post shows how this can be done. http://jason.diamond.name/weblog/2006/05/25/custom-configuration-section-validator-weirdness

Another Tip:

If you want to have a ConfigurationElementCollection in your config section without actually having a parent tag around the collection, declare the collection name in the ConfigurationProperty attribute as an empty string. For example if you have a <MyConfigSection> section with a collection of FileGroup elements, you can code:

       <ConfigurationProperty("", IsRequired:=True, IsDefaultCollection:=True)> _
        Public Property FileGroups() As FileGroupCollection
            Get
                Return CType(Me(""), FileGroupCollection)
            End Get
            Set(ByVal value As FileGroupCollection)
                Me("") = value
            End Set
        End Property

which will give you:

<MySection>
   <FileGroup/>
   <FileGroup/>
   <FileGropu/>
<MySection>

as opposed to

<ConfigurationProperty("FileGroups", IsRequired:=True, IsDefaultCollection:=True)>

which would require the section to look like:

<MySection>
   <FileGroups>
      <FileGroup/>
      <FileGroup/>
      <FileGropu/>
   </FileGroups>
<MySection>

Something Odd

Most of the example code I've found on the web write the property accessors as I did above, using Me("someName") (or base["someName"] in C#) to store the values. Reading the documentation, it looks like the default the default property of the ConfigurationElement is Item(), but tracing through the code I found that the values I was trying to retrieve could be found in the Values property collection (a hash I think, probably a ConfigurationPropertiesCollection object) , a property which doesn't appear in the MSDN documentation for the ConfigurationElement. Me("someName") seems to be functionaly equivalent to Me.Values("someName"). I'm not sure why they omitted that from the documentation, or what purpose the Item() property serves except that it's documented as:

In C#, this property is the indexer for the ConfigurationSectionCollection class.

which leaves me wondering why it's in the ConfigurationElement class and what it does for VB. In my explorations, I found that Me.Item("someName") couldn't get me to my value, but Me.Values("someName") could. If anyone has some insight into this, I'd be very happy to hear it.

I hope this helps someone out.