Solved

Sort a generic List<Article> for its specific property

Posted on 2009-07-02
14
189 Views
Last Modified: 2012-05-07
Hello,

I have this class object

class Article
{    
        public string ArticleDescription { get; set; }
        public string WG { get; set; }
        public string Archived{ get; set; }
}

Now I have put many article objects into a

var articleList = new List();

articleList.Add(new Article());

the articleList has many objects now... How can I sort for the Property = ArticleDescription for example?
0
Comment
Question by:MSFanboy
  • 8
  • 5
14 Comments
 
LVL 9

Assisted Solution

by:Rahul Goel
Rahul Goel earned 150 total points
ID: 24761964
0
 
LVL 39

Expert Comment

by:abel
ID: 24761977
I copied your code and used the following (.NET 3.5) to sort it by WG. You can do the same with ArticleDescription. The code below prints the following

Unsorted:
balena
chris
anton

Sorted:
anton
balena
chris

-- Abel --

IList<Article> articleList = new List<Article>();

articleList.Add(new Article() { ArticleDescription = "other descr", WG = "balena" });

articleList.Add(new Article() { ArticleDescription = "yet other descr", WG = "chris" });

articleList.Add(new Article() { ArticleDescription = "description", WG = "anton" });

Debug.WriteLine("Unsorted:");

foreach (var a in articleList)

    Debug.WriteLine(a.WG);
 

articleList = articleList.OrderBy(article => article.WG).ToList();

Debug.WriteLine("\nSorted:");

foreach (var a in articleList)

    Debug.WriteLine(a.WG);

Open in new window

0
 
LVL 39

Expert Comment

by:abel
ID: 24762008
In other words, using LINQ (.OrderBy(), you may need to add a reference to System.Core to your project and an "using System.Linq" to the top of your class) makes this real easy.

- Before the "=>" symbol goes the name of the variable you want to sort on. Choose any, its type is the List type
- After the "=>" symbol goes the property you want to sort on. Use "article.ArticleDescription" in your case

What's important in my example is that I used the Generic List. You said so in your question, but you didn't show so in your code. Which is why I added the declaration of the generic list at the beginning of the code.

-- Abel --
0
 

Author Comment

by:MSFanboy
ID: 24762511
How can I sort several properties without using linq?
0
 

Author Comment

by:MSFanboy
ID: 24762586
or with linq is it possible at all to make orderby for several properties?

lets say I have 4 properties in a class:

1. articlenumber
2. articlename
3. articledate
4. category

I want first sort after articlenumber then articlename then articledate and and last category

Would be cool if someone can help me still have 3 hours to do this :/ damn should have learned before linq :P
0
 
LVL 39

Expert Comment

by:abel
ID: 24762813
complex task (relatively), only 3 hours before deadline (???) and only a voluntary service like EE to help you? That's scary...

You go quite a bit further then your original question. But I'll have a look, can't promise that I stay within your time constraints though, I have a job too... ;-)
0
 
LVL 39

Expert Comment

by:abel
ID: 24762862
Luckily, the answer is very easy. Simply chain your OrderBy clauses (each OrderBy returns an IEnumerable anyway):

articleList = articleList

    .OrderBy(article => article.ArticleNumer)

    .OrderBy(article => article.ArticleName)

    .OrderBy(article => article.ArticleDate)

    .OrderBy(article => article.ArticleCategory).ToList();

Open in new window

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 39

Expert Comment

by:abel
ID: 24762876
oops, forget that. That's not true, of course. I'm being to quick. Erase that from your memory... ;-)
0
 
LVL 39

Accepted Solution

by:
abel earned 350 total points
ID: 24762936
So, back on track, this time I tested first. This is LINQ and LINQ is easy, but you have to know how to. Here's two ways:

// using method calls

articleList = articleList

    .OrderBy(article => article.ArticleNumber)

    .ThenBy(article => article.ArticleName)

    .ThenBy(article => article.ArticleDate)

    .ThenBy(article => article.ArticleCategory).ToList();
 

// using LINQ syntax

articleList = (from art in articleList

              orderby art.ArticleNumber, 

                      art.ArticleName, 

                      art.ArticleDate, 

                      art.ArticleCategory

              select art).ToList();

Open in new window

0
 

Author Comment

by:MSFanboy
ID: 24762955
hey I got the same result as you but I choosed this:

instead of using the last 3 OrderBy I used "ThenBy" the rest is the same with your code :)

lets assume I have this output (I did not sort it here now... just example...)

quantity ... category
10.............stuff1
12.............stuff1
33.............stuff5
5 .............stuff5
12.............stuff7
33 .............stuff1          
55.............stuff3
10.............stuff3
3.............stuff7

How can I sum the quantity of every category?

so I have in the end thiat output:

55 stuff1
38 stuff5
14 stuff7
65 stuff3

?

0
 
LVL 39

Expert Comment

by:abel
ID: 24762995
> How can I sum the quantity of every category?

you are drifting further and further away from your original question. At EE, it is recommended (and actually mandatory) to stick to one question per thread: http://www.experts-exchange.com/help.jsp?hi=23

You have unlimited points. Consider asking these specific questions inside the LINQ zone. You'll probably get more to the point answers there from the LINQ experts.
0
 

Author Comment

by:MSFanboy
ID: 24763070
yeah sorry my boss was just here changing requirements arghhh stupid... i go to linq and close here later, thx a bunch guys!
0
 

Author Closing Comment

by:MSFanboy
ID: 31599116
@Abel you get 350 points for posting much and I use your linq solution as I use .net 3.5

@Rahu_ketu_patal: you get 150 points as your link is very helpfull where I am limited to .net 2.0 projects only. Your link shows it with .net 3.0 but its  also possible with 2.0 just less code to write.
0
 
LVL 39

Expert Comment

by:abel
ID: 24771520
After we stuck with you through all additional question and explaining all the lot, giving you cut-n-paste examples, why the B-grade? You asked more then the original q. and got more answers, shouldn't you grade accordingly?

Grading experts is not like at school, it is more a 10 points must system: http://www.experts-exchange.com/help.jsp?hi=403

Changing grades: http://www.experts-exchange.com/help.jsp?hi=404

-- Abel --
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now