Databases
StackOverflow2013
Postsdbo
POHow to store a HashTable in the usersettings?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to store a HashTable in the usersettings?
    primarykey
    data
    text
    <p>In .NET you can select a hashtable as type for a usersetting. However when I save it and retrieve it in this way, it doesnt seem to have saved it at all.</p> <pre><code>Hashtable t = new Hashtable(); t.Add(1,"Foo"); t.Add(2,"Bar"); Properties.Settings.Default.Setting = t; Properties.Settings.Default.Save(); if(Properties.Settings.Default.Setting != null) foreach (DictionaryEntry entry in Properties.Settings.Default.Setting) { MessageBox.Show(entry.Key + " " + entry.Value); } </code></pre> <p>Why doesnt it serialize it in the usersettings, when I can clearly select that type in Visual studio? I would understand if this was the case with an unlisted type such as dictionary, but Hashtable is listed. How do I solve this problem?<br> Simplicity and efficiency in this order have the highest priority for me.</p> <p>Many Thanks, Kave</p> <hr> <p>update:</p> <p>@Joao , Many Thanks the Binary solution. I find it quite interesting, its clean. One disadvavtage with serializing it as binary might be the fact that you cant change anything in the usersetting file manually anymore. but I think that will be done very rarely anyway, so its a good solution.</p> <p>I was thinking of a different approach to create an "XMLSetting" field of type string in the user scope and use this code to store and retrieve the values as an XMl file serialized into a hashtable. But I am sure this is not the best way, does anyone know a better way to serialize a hashtable/dictionary as xml in the usersettings, other than what i am doing below?</p> <pre><code>if(string.IsNullOrEmpty(Properties.Settings.Default.XMLSetting)) { Console.WriteLine("Usersettings is empty. Initializing XML file..."); XmlDocument doc = new XmlDocument(); XmlElement hashtable = doc.CreateElement("HashTable"); doc.AppendChild(hashtable); GenerateValues(doc, hashtable, "1", "Foo"); GenerateValues(doc, hashtable, "2", "Bar"); Properties.Settings.Default.XMLSetting = doc.OuterXml; Properties.Settings.Default.Save(); } else { Console.WriteLine("Retrieving existing user settings..."); XmlDocument doc = new XmlDocument(); doc.LoadXml(Properties.Settings.Default.XMLSetting); Hashtable hashtable = new Hashtable(); foreach (XmlNode entry in doc.DocumentElement.ChildNodes) { hashtable.Add(int.Parse(entry.FirstChild.InnerText), entry.FirstChild.NextSibling.InnerText); } foreach (DictionaryEntry entry in hashtable) { Console.WriteLine(entry.Key + " " + entry.Value); } } private static void GenerateValues(XmlDocument doc, XmlElement hashtable, string skey, string svalue) { XmlElement entry = doc.CreateElement("entry"); XmlElement key = doc.CreateElement("Key"); XmlElement value = doc.CreateElement("Value"); entry.AppendChild(key); entry.AppendChild(value); key.AppendChild(doc.CreateTextNode(skey)); value.AppendChild(doc.CreateTextNode(svalue)); hashtable.AppendChild(entry); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USHouman
    1. USHouman
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to store a HashTable in the usersettings?
      1. USHouman
      1. VTFavorite
    2. VO
      singulars
      1. POHow to store a HashTable in the usersettings?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to store a HashTable in the usersettings?
      1. USAngelo
      1. VTFavorite
    1. COI have just tested persisting an Hashtable as user setting and detected no problems. If you haven't done it already, try to do it from scratch in a new test project.
      singulars
      1. POHow to store a HashTable in the usersettings?
      1. USJoão Angelo
    2. COHi, I just have tried it again. It keep ssaying the Properties.Settings.Default.Setting stays as null, even after i saved and restarted the application. It works with other types such string though. How did you get it work? Can you post your solution somehow?
      singulars
      1. POHow to store a HashTable in the usersettings?
      1. USHouman
    3. COI was to hasty in my tests. The Hashtable is not persisted between application runs with the default settings class. However if it's vital for you to have a Hashtable and don't mind some manual work, you can check my answer.
      singulars
      1. POHow to store a HashTable in the usersettings?
      1. USJoão Angelo
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload