How to sort a listBox not by the first letter?

[Nzsquall]

Hi, I am having trouble sorting a client contact lists by their surname. Every time when I press the "sort by surname button, it always appear alphabetical order
by clients' first name, because I put them before the surname, it is the first String of the every line in the listBox.
My code under the sortBySurname is

  private void sortBySButton_Click(object sender, EventArgs e)
        {
            contactListBox.Items.Clear();
            StreamReader fileReader;
            string[] myArray;
            string line = "";
            string bigString = "";
            fileReader = new StreamReader(@"c: \client contact details.txt");
            while (fileReader.Peek() != -1)
            {
                line = fileReader.ReadLine();
                bigString = bigString + line + "\n";
            }
            fileReader.Close();
            bigString = bigString.Trim();
            myArray = bigString.Split('\n');
            Array.Sort(myArray);
            foreach (string item in myArray)
            {
                contactListBox.Items.Add(item);
            }
        }
 

Can someone tell me how to specify it to be sorted by clients' surname?

[whodgson]

Clearly the surname should come before the given names and initials.
In which case as you say your sort would work as intended.
Failing that, code it to sort on the second capital letter

[Banfa]

There is no function that automatically finds the second word in a string of an array of strings and sorts the array on that word. You will have to sort by hand or re-order your string with the last word at the front (i.e. surname first).

This is a .NET problem and I am moving it to that forum.

[Nzsquall]

@Banfa
Thanks very much!! It solves me a big question. But what if I need to sort by the location in each line? the location is a Combo box called locationComboBo x. Where should I put the syntax and what code should I put?

Many thanks

[PRR]

You could put all information in Dataset create a default view and sort it and bind to controls by looping through the view .
DataView.Sort property.

[Nzsquall]

Hello everyone. I am a C# learner. I am having troubles doing my first program.
Part of the function is to sort a list box contain client details.
For instance:
One typical line of the contactListBox is:

Surname Firstname Firstmeetingdat e Location Phone

I have work out the "sort by surname" button, it is simple to loop through the contactListBox using an array and sort and return, because the surname is the first string in every single line.

 private void sortBySButton_Click(object sender, EventArgs e)
        {
            contactListBox.Items.Clear();
            StreamReader fileReader;
            string[] myArray;
            string line = "";
            string bigString = "";
            fileReader = new StreamReader("client contact details.txt");
            while (fileReader.Peek() != -1)
            {
                line = fileReader.ReadLine();
                bigString = bigString + line + "\n";
            }
            fileReader.Close();
            bigString = bigString.Trim();
            myArray = bigString.Split('\n');
            Array.Sort(myArray);
            foreach (string item in myArray)
            {
                contactListBox.Items.Add(item);
            }
        }

Now I am having troubles coding the "sort by location" button, because I don't know where to tell the compiler to recognize the location string.
This has already drived me crazy!!!

Can somebody help me a little? None of the resource I found is suitable for a beginner. Thanks in advance.

private void sortByLButton_Click(object sender, EventArgs e)
        {
 
        }

P.S. location is retrieved from locationComboBo x.

[ssnaik84]

my suggestion is..
- read file into DataTable
- bind DataTable to ListBox

and on button click event,
- sort DataTable and re-bind to ListBox

[Nzsquall]

Thanks very much, I appreciate it. But how can I read file into DataTable and bind read file into ListBox?

[tlhintoq]

TIP: When you are writing your question, there is a button on the tool bar that wraps the [code] tags around your copy/pasted code. It helps a bunch. Its the button with a '#' on it. More on tags. They're cool. Check'em out.

[tlhintoq]

In your source text file, is there a delimiter to look for? Is there a tab or comma between fields? Where did the source text file come from?