.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Convert user.config to database storage via my custom settings provider

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :.NET Framework
 

Hi,

I've created my own custom settings provider to save user settings (formerly in the user.config) to a database. To point the particular settings that are to be saved to the database I specified

[SettingsProvider(typeof(BlobSettingsProvider))]
for each property to point to the BlobSettingsProvider instead of allowing them to default to the LocalFileSettingsProvider.
Now I need to convert existing user.configs to save to the database on the fly - a one time conversion. Because I've now specified the properties to use the BlobSettings provider they can no longer access the local user.config.
Does anyone have any thoughts on how best to accomplish this conversion (i.e. read the local user.config and populate the BlobSettingsProvider). The app can be run as a ClickOnce installed app or as a simple .net app - finding the correct local user.config looks to be a problem.
Thoughts, ideas,...?
Thanks,
Glenn

Glenn


View Complete Post


More Related Resource Links

User Preferences: Manage User Settings in Your .NET App with a Custom Preferences API

  

There are plenty of options out there for managing user preferences including custom configuration files, the Windows registry, and the isolated storage. But each option has its pros and cons -- and a bad choice can make life difficult. In this article, the author evaluates various options and identifies the characteristics of a good preferences API. Based on those characteristics, he introduces an API that is specifically designed for preferences management, one that offers the best of all the options.

Ray Djajadinata

MSDN Magazine July 2004


Web.config for Custom Membership Provider

  
I am trying to set-up the connection strings to my Membership Provider. I am using the Sql server database and not the default aspnet_db. Iam giving the Fully Qualifying namespace+class in my "type"  and it still throws an error msg "connection string cannot be blank". Web.config: < < < < membership defaultProvider="CustomMembershipProvider">providers>clear />add connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="RavLoginApp" description="Stores and retrieves membership data from the local Microsoft SQL Server database" name="CustomMembershipProvider" type="MyNamespace.CustomMembershipProvider" />  </providers> </membership <connectionStrings > <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="data source=127.0.0.1;database=MyLocaldb;uid=xxxxx;pwd=xxxxxx" providerName="System.Data.SqlClient" /> <

claims authenticated (FBA) user cannot open a connection to our custom application database

  
We have designed a custom sharepoint site. This site uses a membership provider that I implemented, and the users are stored in our custom application database. These are the steps I follow to reproduce the error: 1. Browse to our site. Select Forms Authentication from the default.aspx selection. 2. Enter in a username from our DB table. This user I have configured as a site collection administrator. 3. Login to the site. The user is authenticated by our membership provider and allowed access (ValidateUser returns true) 4. Browse to a page that attempts to connect to the custom app DB. 5. I get the following error when the page attempts to open a connection to our DB: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server NOTES: The code that opens the DB connection is running with SPSecurity.RunWithElevatedPrivileges. Our application pool account has access to the database. My user can connect to the database fine as well as the user that our  application pool is running as. I have validated the connection string that is being used in the debugger, and that is correct.

Custom membership provider not returning values from my web.config

  

I created a custom membership provider in my ASP.NET 4.0 web site, stored  in App_Code, and referenced in my web.config.

However, it doesn't appear to be pulling values out of web.config during initialization.

The code was taken from http://www.asp.net/general/videos/how-do-i-create-a-custom-membership-provider, and the only modifications were changing "connectionStringName" here to the name of my connection string:


    Dim ConnectionStringSettings As ConnectionStringSettings = _
      ConfigurationManager.ConnectionStrings(config("connectionStringName"))

The connection string always comes back as nothing in this line:


    If ConnectionStringSettings Is Nothing OrElse ConnectionStringSettings.ConnectionString.Trim() = String.Empty Then
      Throw New ProviderException("Connection string cannot be blank.")
    End If




No matter what I change the password format to in web.config, the default value here is always used:


    Dim temp_format As String = config("passwordFormat")
    If temp_format Is Nothing Then
      temp_format = "Has

User-specific application settings vs Isolated Storage

  

I was wondering what's the difference between these two ways to store user-specific settings.

In isolated storage you're supposed to have the security that the path to the files is unknown. But MSDN still recommends not to store sensitive information. On the other hand, user-specific settings, maybe with default values in the app.config file, are also stored in a randomly generated folder. In this case I imagine that you can encrypt the user settings the same way you do with the app.config file.

My question is, what are the advantages of using one method over the other to store user-specific settings?


How to deploy custom membership provider dll in STS web config in SPS 2010

  

i am having a custom membership provider dll which i want to deploy in the STS webconfig file in sps 2010. i donno how to deploy it. since sts webconfig doesnt have any <system.web>, <sharepoint> entries and where shoudl i add these? will that suffice to deploy my custom membership provioder assembly? also  i am NOT  using any oob membershi p providers. am using a CUSTOM PROVIDER.  can anyone help by what are the steps and where & wher to add those entries.  below one isused for  aspnetsqlmembership provider.                       

can i use the same pattern with changes in the name of the assembly withmy  custom provider will work for me/

<system.web>
  <membership>   <providers> <memberships>  </membership> ....

any sample code with the sts web.config format /src code will be helpful

 thanks

 


Not able to convert user control to custom control.

  

 I have created a user control and am ready to convert it into a custom control. I am trying to follow: http://msdn.microsoft.com/en-us/library/aa479318.aspx the steps mentioned in the link.

I am not  seeing Build / Publish Web Site option. I am using VS 2008. I only see Publish User Control but it doesn't give all the settings mentioned below. When I do publish user control, it just copies the ascx file to the desired location. Please suggest how can I convert the user control to custom control.


How to deploy custom membership provider dll in STS web config in SPS 2010

  

i am having a custom membership provider dll which i want to deploy in the STS webconfig file in sps 2010. i donno how to deploy it. since sts webconfig doesnt have any <system.web>, <sharepoint> entries and where shoudl i add these? will that suffice to deploy my custom membership provioder assembly? also  i am NOT  using any oob membershi p providers. am using a CUSTOM PROVIDER.  can anyone help by what are the steps and where & wher to add those entries.  below one isused for  aspnetsqlmembership provider.                       

can i use the same pattern with changes in the name of the assembly withmy  custom provider will work for me/

<system.web>
  <membership>   <providers> <memberships>  </membership> ....

any sample code with the sts web.config format /src code will be helpful

 thanks

 


MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Convert English to Arabic number without changing any regional settings in .net

  
Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

Linq - add data to database then email user the details

  

Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 

 

Thanks in advance for your help,

Laura

 

 


Need Oracle Data Provider .CS File for Oracle 10g Database connection !

  

Hi.,

I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query

(eg)

Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");

Gridview1.DataBind();

Plz Post the link if there is any open source !    


ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismatch

  

Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.

Below is the information on the server before/after the upgrade.

Before            After

---------       -----------  

Solaris 8      Solaris 10

IDS 9.40     IDS 11.50


The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.

As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.

The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.

I have gone through many articles and it suggest me to set the environement  variable in the server :  DB_LOCALE=en_us.819.

I haven't try this solution but i think that this might not be the best solution.

Is it possible to to to have this settin

Custom Control Design-Time SiteMap Provider Error

  

Greetings - I was referred here by MSDN forums hope this is the right place -  

I have a custom control (:WebControl) that renders web.sitemap in a specific way. While it runs error free and produces the expected result, at Design-Time it complains

Error Creating Control - MyControl  The provider 'AspNetXmlSiteMapProvider' specified for the defaultProvider does not exist in the providers collection.

I have discovered that the error is cause by this line of code:

string div = string.Format("<div class='{0}' id='{1}'>{2}</div>", this.CssClass, this.ID.ToString(), EnumerateNodesRecursive(SiteMap.RootNode, level));

or more specifically, by the reference to SiteMap.RootNode - I am not clear what is missing thoough because I have configured the SiteMapProvider in web.config as this:

<siteMap>
      <providers>
        <clear/>
        <add name="AspNetXmlSiteMapProvider" 
             type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" 
             siteMapFile="web.sitemap" 
             securityTrimmingEnabled="true"/>
      </providers>
    </s

Data Points: Windows Azure Table Storage - Not Your Father's Database

  

Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.

Julie Lerman

MSDN Magazine July 2010


Toolbox: Database and OR/M Tools, Oren Eini and Custom Visual Studio Tabs

  

This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.

Scott Mitchell

MSDN Magazine December 2009


Fuzz Testing: Create a Custom Test Interface Provider for Team System

  

Dan Griffin shows the extensibility of Visual Studio 2005 Team Edition for Software Testers by discussing the modification of the existing Test Interface Provider sample in the latest Visual Studio SDK and implements Fuzz Testing.

Dan Griffin

MSDN Magazine November 2007


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend