Sort Arrays inside an array, C#

Question

| ID         | Desc        | Priority     |
|:-----------|------------:|:------------:|
| 1          |        aabc |   Priority1     
| 2          |         xyz |   Priority3    
| 3          |         cba |   Priority5     
| 4          |          fg |   Priority2      
| 5          |         xdr |   Priority4    
| 6          |         pqr |   Priority1

Hi, I've above table stored in a form of an Array.

Array[] Values;


Values[0]={'ID','Desc','Priority'};
Values[1]={'1','aabc','Priority1'};
Values[2]={'2','xyz','Priority3'};
Values[3]={'3','cba','Priority5'};

Now I have to sort Values on the basis of priority so that my result comes as.

Values[0]={'ID','Desc','Priority'};
Values[1]={'1','aabc','Priority1'};
Values[2]={'4','fg','Priority2'};
Values[3]={'2','xyz','Priority3'};

help me write the code for this in C#

Possible duplicate of Better way to sort array in descending order — Rob
– Rob ♦, Commented Jan 14, 2016 at 12:02
This is literally one line in LINQ. Have you tried anything? — Andrei
– Andrei, Commented Jan 14, 2016 at 12:02
msdn.microsoft.com/en-us/library/bb383982.aspx , as @InBetween says it really not a good idea to have priority as string — maztt
– maztt, Commented Jan 14, 2016 at 12:13
Create a class for your table. dont use arrays like that. because there is no type safety or any information of how you represent your data. this makes your program hard to understand and can become real buggy. — M.kazem Akhgary
– M.kazem Akhgary, Commented Jan 14, 2016 at 12:18

InBetween · Accepted Answer · 2016-01-14 12:02:42Z

1

using System.Linq;

Values.OrderBy(a => a[2]);

Without more context can't really say for sure but Values looks horrendous. Why not use, for instance, an int to define priorities?

answered Jan 14, 2016 at 12:02

InBetween

32.9k3 gold badges52 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jdweng · Accepted Answer · 2016-01-14 12:18:20Z

If you really have a DataTable then try this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace ConsoleApplication66
{
    class Program
    {
        static void Main(string[] args)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("ID", typeof(int));
            dt.Columns.Add("Desc", typeof(string));
            dt.Columns.Add("Priority", typeof(string));

            dt.Rows.Add(new object[] {1, "aabc", "Priority1"});     
            dt.Rows.Add(new object[] {2, "xyz", "Priority3"});     
            dt.Rows.Add(new object[] {3, "cba", "Priority5"});     
            dt.Rows.Add(new object[] {4, "fg", "Priority2"});     
            dt.Rows.Add(new object[] {5, "xdr", "Priority4"});     
            dt.Rows.Add(new object[] {6, "pqr", "Priority1"});

            DataTable results = dt.AsEnumerable()
                .OrderBy(x => x.Field<string>("Priority"))
                .CopyToDataTable();
        }
    }
}

Collectives™ on Stack Overflow

Sort Arrays inside an array, C#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related