Fetching values from list of Dictionaries

Question

4.00/5 (1 vote)

See more:

Hi All,

I want to fetch the values from list of dictionaries in order to get the values that started with letter a,b,c,d.

I want to implement the functionality that will sort out the list of dictionary started with letter a,b,c,d and e,f,g,h and ...... and y,z.

C#

List<Dictionary<string, object>> neighborhoodList = new List<Dictionary<string, object>>();
string locs_id = string.Empty;

while (dr.Read())
{
   locs_id = dr["locationid"].ToString();
   neighborhood = new Dictionary<string, object>();
   neighborhood.Add("LocationID",dr["locationid"].ToString());
   neighborhood.Add("LocationName", dr["locationName"].ToString()); 
   neighborhoodList.Add(neighborhood);
}

Now i want to get only those record from the neighborhoodList that starts with letter a,b,c,d. The same process i want to do for all section such as e,f,g,h and y,z. I need to keep the sorted record in the list of dictionary becuase that list of dictionary i need to pass to dot liquid. That implementation i cannot change because it will be a big change.

Thanks

Umesh Tayade

Posted 17-Sep-13 20:42pm

Umesh Tayade

Updated 17-Sep-13 21:09pm

phil.o

v2

Add a Solution

2 solutions

Solution 1

You can do like this by linq..

var a = neighborhoodList.Select(x => x.Name.StartsWith("a"));

For more detials refer this:

http://www.c-sharpcorner.com/UploadFile/0f68f2/using-lambda-expression-over-a-list-in-C-Sharp/[^]

Posted 17-Sep-13 21:29pm

Ashishmau

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)

Harshil_Raval · Accepted Answer · 2013-09-17T21:41:00

Hi,

After your dictionary list ready, try this.

C#

Dictionary<string, object> temp = new Dictionary<string, object>();

foreach (Dictionary<string, object> dict in neighborhoodList)
{
    if (dict.Keys.First().ToString().StartsWith("a") || dict.Keys.First().ToString().StartsWith("b") || dict.Keys.First().ToString().StartsWith("c") || dict.Keys.First().ToString().StartsWith("d"))
    {
        temp.Add(dict.Keys.First().ToString(),dict.Values.First().ToString());
    }
}
var items = from pair in temp
            orderby pair.Key ascending
            select pair;
neighborhoodList = new List<Dictionary<string, object>>(); // null your list, so that new value can be inserted
foreach (KeyValuePair<string, object> pair in items)
{
    temp = new Dictionary<string, object>();
    temp.Add(pair.Key, pair.Value);
    neighborhoodList.Add(temp);
}
//now your list is sorted and key value start with a,b,c,d.

It would be more simple if you store value in simple dictionary object, not in list of dictionary. Because you can store multiple value in simple dictionary object.

Hope it helps you.
Thanks.