在数据库C＃中存储的用户设置 [英] c# store user settings in database

问题描述

有一个简单的方法来存储在SQL 2000数据库中一个人的用户设置。理想的情况是在某一领域的所有设置，所以我不保持有我每次添加一个设置，编辑表格。我沿着如果任何人有一个例子序列化设置类的思路思考。

Is there an easy method to store a person's user settings in a sql 2000 database. Ideally all settings in one field so I don't keep having to edit the table every time I add a setting. I am thinking along the lines of serialize a settings class if anyone has an example.

我不希望使用内置的存储在持久性存储.NET用户设置的原因是工作使用超级强制配置文件，以便在一个用户注销的设置将被清除这是一种痛苦。我张贴要求到此previously任何解决方案，但并没有得到太多的响应。

The reason I don't want to use the built in .NET user settings stored in persistent storage is work uses super mandatory profiles so upon a users log off the settings are cleared which is a pain. I posted asking for any solutions to this previously but didn't get much of a response.

推荐答案

该VS设计保持了的 ApplicationSettingsBase 类。默认情况下，这些属性是序列化/反序列化到每个用户的XML文件。您可以通过使用自定义 SettingsProvider 覆盖此行为，在这里你可以添加你的数据库的功能。只需添加 SettingsProvider 属性到VS生成设置类：

The VS designer keeps property settings in the ApplicationSettingsBase class. By default, these properties are serialized/deserialized into a per user XML file. You can override this behavior by using a custom SettingsProvider which is where you can add your database functionality. Just add the SettingsProvider attribute to the VS generated Settings class:

[SettingsProvider(typeof(CustomSettingsProvider))]
internal sealed partial class Settings { 
   ...
}

这方面的一个很好的例子就是 RegistrySettingsProvider 。

我回答了另一个类似的问题同样的方式<一个href="http://stackoverflow.com/questions/170825/how-to-serialize-systemconfigurationsettingsproperty#170932">here.

I answered another similar question the same way here.

这篇关于在数据库C＃中存储的用户设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！