Read from file into hashtable and populate textBoxes
I'm creating an agenda program using windows form application, I'm trying to load data from a file into a hash table and display this data into text boxes. The labels on the text boxes are dates but these dates are of the form (dd MMMM dddd e.g 30 November Friday) and are used as key values for the hash table. The dates in the file are of the form (dd MM yyyy). A sample of the data in the file is shown.
10/07/2012,Having an exam at 10.30 *
30/11/2012,Will go to swimming at 15.30 *
When I load the form, the data should be shown in the corresponding textbox. For example Will go to swimming at 15.30 * must be shown under text box with label "30 November Friday" (because it corresponds to date 30/11/2012). My code so far is this:-
However the textBoxes are not being populated. I cant find what the error is. How can i get the data populated? thanks
while ((line = sr.ReadLine()) != null)
string inData = line.Split(',');
key = inData;
value = inData;
foreach (DictionaryEntry dataEntry in hT)
//Will throw a FormatException if 'dataEntry.Key' doesn't represent a valid date format
DateTime keyAsDate = Convert.ToDateTime(key);
//This overload of 'ToString' uses CurrentCulture
string comparisonKey = keyAsDate.ToString("dd MMMM dddd");
if (label1.Text.Equals(comparisonKey, StringComparison.OrdinalIgnoreCase))
textBox1.Text = dataEntry.Value.ToString();
if (label2.Text.Equals(comparisonKey, StringComparison.OrdinalIgnoreCase))
textBox2.Text = dataEntry.Value.ToString();
if (label3.Text.Equals(comparisonKey, StringComparison.OrdinalIgnoreCase))
textBox3.Text = dataEntry.Value.ToString();
Re: Read from file into hashtable and populate textBoxes
So, first, your design using a key of the date allows for only one event per day... I would do something like creating Dictionary of lists, keyed on the date where the list is all the events that occur on that date. Then you can do:
You can do it slightly more performantly with TryGetValue, but I omitted that here for clarity.
string lines = File.ReadAllLines(path);
Dictionary<string, List<string>> dayDictionary = new Dictionary<string, List<string>>();
for( string line in lines )
//Parse the lines to get the date and some text string about it
string date = //whatever
string text = //whatever
//Check to see if this date is already in the dictionary
if( ! dayDictionary.ContainsKey(date) )
dayDictionary.Add(date, new List<string>()); //If not create a new list
//Now add the displaytext to the day's list
Then write a second loop that queries the dayDictionary based on the label of the textbox you want to query and then dump each item of the list into a textbox.
Does that make sense?
That probably isn't the best design pattern ever, but I didn't want to get too far away from your initial design.