need help for value in sortedList change to percentage

Question

i meet 2 problems now. the 1st problem is ,i have a sortedList, i need to change the value into percentage. my 2nd problem is after change to percentage. when i key in minimum support, if the value which is not fulfill the minimum support, then will ignore it. * total trasaction is 20=contentBox my sortedLIst: 1: 11 2: 14 4: 5 3: 13 6: 3 5: 6 now i can change the value to percentage.the code are shown below. but the problem is , it just can show value only, i want the output is like this: 1: 55 2: 70 4: 25 3: 65 6: 15 5: 30 double v2; richTextBox13.Clear(); foreach (String sorting2 in sortList1.Keys) { if (!(sortList11.ContainsKey(sorting2))) { sortList1.TryGetValue(sorting2, out v2); sortList11.Add(sorting2, v2); double Count1 = (double)sortList11[sorting2]; sortList11[sorting2] = (v2 / ContentBox.Lines.Length)*100; } richTextBox13.AppendText(sortList11[sorting2].ToString() + "
"); } double[] store = new double[richTextBox13.Lines.Length]; int al = 0; foreach (double abv in sortList11.Values) { store[al] = abv; al++; } string min_supp = textBox9.Text; double min = Double.Parse(min_supp); textBox4.Text = textBox9.Text; string output = ""; for (int prune = 0; prune { if (store[prune] >= min) { output += store[prune] + "
"; } richTextBox14.Clear(); richTextBox14.AppendText(output ); } explaination above are my 1st problem. for my 2nd problem, if i get my expected output, then if i key in minimum support like 40%, if nto fulfill 40, it will ignore. My expected output is : 1: 55 2: 70 3: 65 hope can help me..

Vulpes · Answer

I can't see any mistake in your code and, as I can't run it as it stands, I've modelled it as a console app and it works fine with the output exactly as expected: using System; using System.Collections.Generic; using System.Windows.Forms; class Test { static void Main() { List richTextBox13 = new List (); // modelling an RTB with a List richTextBox13.Add("1: 55"); richTextBox13.Add("2: 70"); richTextBox13.Add("4: 25"); richTextBox13.Add("3: 65"); richTextBox13.Add("6: 15"); richTextBox13.Add("5: 30"); MessageBox.Show(String.Join("
", richTextBox13.ToArray())); string min_supp = "40"; double min = Double.Parse(min_supp); string output = ""; for (int prune = 0; prune { string[] items = richTextBox13[prune].Split(':'); string key = items[0]; double value = Double.Parse(items[1]); if (value >= min) { output += key + ": " + value.ToString() + "
"; } } MessageBox.Show(output); } } Are you putting '40' in the textbox or '40%'? The latter though would give an exception. You'll have to try and debug it concentrating on this part of the code: for (int prune = 0; prune { string[] items = richTextBox13.Lines[prune].Split(':'); string key = items[0]; double value = Double.Parse(items[1]); if (value >= min) { output += key + ": " + value.ToString() + "
"; // put a breakpoint here } } I'd put a breakpoint on the line indicated and check what 'key' and 'value' are each time through the loop.

Vulpes · Answer

Sure, just add a couple of lines: var sl = new SortedList (); for (int prune = 0; prune { string[] items = richTextBox13[prune].Split(':'); string key = items[0]; double value = Double.Parse(items[1]); if (value >= min) { output += key + ": " + value.ToString() + "
"; sl.Add(key, value); } }

y s · Answer

after i get my expected output: 1: 55 2: 70 3: 65 may i know how to store it into sortedList?

y s · Answer

when i key in minimum support =40%. My expected output is : 1: 55 2: 70 3: 65 still cannot come out with this output.

y s · Answer

double v2; richTextBox13.Clear(); foreach (String sorting2 in sortList1.Keys) { if (!(sortList11.ContainsKey(sorting2))) { sortList1.TryGetValue(sorting2, out v2); sortList11.Add(sorting2, v2); double Count1 = (double)sortList11[sorting2]; sortList11[sorting2] = (v2 / ContentBox.Lines.Length) * 100; } richTextBox13.AppendText(sorting2 + ": " + sortList11[sorting2].ToString() + "
"); } string min_supp = textBox9.Text; double min = Double.Parse(min_supp); textBox4.Text = textBox9.Text; string output = ""; for (int prune = 0; prune { string[] items = richTextBox13.Lines[prune].Split(':'); string key = items[0]; double value = Double.Parse(items[1]); if (value >= min) { output += key + ": " + value.ToString() + "
"; } } richTextBox14.Clear(); richTextBox14.AppendText(output); i have did any mistake with it?

Vulpes · Answer

Sorry again, that line should be: double value = Double.Parse(items[1]);

y s · Answer

May i know this line double value = Double.Parse(items[i); the item[i] is what? i change it to item[0]; but no output also . my" min" values does not key in too high.

Vulpes · Answer

Sorry, that was a slip on my part - I'm just doing it off the top of my head. However, as long as you haven't cleared the richTextBox13 again, then I'd expect this to work. for (int prune = 0; prune { string[] items = richTextBox13.Lines[prune].Split(':'); string key = items[0]; double value = Double.Parse(items[1]); // CORRECTED if (value >= min) { output += key + ": " + value.ToString() + "
"; } } richTextBox14.Clear(); richTextBox14.AppendText(output); If you're seeing nothing, then p erhaps your 'min' value is set so high that it's filtering every line out?

y s · Answer

the first point is work, but the second point cant work. if i use this line string value = Double.Parse(items[0]); then got error, therefor i change it to double value = Double.Parse(items[0]); after i change it, can run the program , but nothing come out.

Vulpes · Answer

On the first point, if I've understand it correctly, then it should just be a matter of changing this line: richTextBox13.AppendText(sortList11[sorting2].ToString() + "
"); to this: richTextBox13.AppendText(sorting2 + ": " + sortList11[sorting2].ToString() + "
"); On the second point, I'd then change the rest of the code to this: string min_supp = textBox9.Text; double min = Double.Parse(min_supp); textBox4.Text = textBox9.Text; string output = ""; for (int prune = 0; prune { string[] items = richTextBox13.Lines[prune].Split(':'); string key = items[0]; string value = Double.Parse(items[i); if (value >= min) { output += key + ": " + value + "
"; } } richTextBox14.Clear(); richTextBox14.AppendText(output);

need help for value in sortedList change to percentage

Answers (10)