sorting in List box trouble....!

Question

3.33/5 (3 votes)

See more:

I want to sort those data in a listbox like that:
mesu ozil germany [5]
mesi argentina [4]
ronado portugal [3]

so the high value in bracket to be first :
I am using this code but they are not sorting

C#

String[] sort= listBox1.Items.Cast().ToArray();
            List count= (
             sort.GroupBy(name => name).OrderByDescending(g => g.Count())
             .Select(group => string.Format("{0} [{1}]", group.Key, group.Count())).ToList());
            listBox2.DataSource = count

Posted 23-May-12 4:32am

h5h5

Updated 23-May-12 4:34am

Ganesan Senthilvel

v2

Add a Solution

Comments

Ganesan Senthilvel 23-May-12 10:34am

Code format is done

R. Giskard Reventlov 23-May-12 11:27am

Why don't you just sort the data before it gets anywhere near the listbox? How are you getting the data? From a table?

Sergey Alexandrovich Kryukov 23-May-12 11:40am

Exactly.
--SA

Chris Ross 2 23-May-12 11:47am

Unfortunately the OP cannot sort on the source data because it is just the name/country text - without the appended '[nnn]'. And he wants to sort on the 'nnn'.

R. Giskard Reventlov 23-May-12 12:44pm

He could add a column to the table with a number in for sorting then order by that number, for instance. select stuff from table order by new_sort_column

Mohamed Mitwalli 23-May-12 15:04pm

good suggestions :)

Killzone DeathMan 23-May-12 11:41am

ronaldo portugal[5]*

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohamed Mitwalli · Answer 1 · 2012-05-23T08:45:00

Hi ,
Check this i believe this what you want

C#

private void button1_Click(object sender, EventArgs e)
      {

          OpenFileDialog dialogu = new OpenFileDialog();
          dialogu.Filter = "*.txt|*.txt";
          if (dialogu.ShowDialog() == DialogResult.OK)
          {
              string[] all = File.ReadAllLines(dialogu.FileName, System.Text.Encoding.Default);
              listBox1.DataSource = all;
              all.ToList();

              Dictionary<string,int> dict = new Dictionary<string,int>();
              foreach (string item in all)
              {
                    int len = item.IndexOf("[");
                  int len2 = item.IndexOf("]");
                  string itm = item.Remove(0, len+1); ;

                  string key1 = item.Substring(0, len);
                  string value1 = itm.Substring(0, itm.Length-1);

                  dict.Add(key1,Convert.ToInt32( value1));
              }
              var res = (from x in dict
                        orderby x.Value descending
                        select x).ToList();
              listBox1.DataSource = null;
              listBox1.DataSource = res;
          }
      }

Best Regards
M.Mitwalli

Chris Ross 2 · Answer 2 · 2012-05-23T05:45:00

I did a test - using your Linq expression - and it (the Linq expression) worked. But I expect you knew that already.

Perhaps you've set the Sorted property of listBox2 to true? That would undo any sorting you did in your Linq expression because it would re-sort the strings based on the name portion of the strings, not on the count part.

sorting in List box trouble....!

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0