Parse Json using Json Net and C# to fill a dropdown

Question

I have a Json something like below: [{"Example temp" : "value"}, {"Example Default" : "", "selected": true}]

I need to fill a dropdown say for example: Dropdown should contain values : Example temp Example Default

And Example Default should be the default selected value,

I tried below code:

JArray jArray = JArray.Parse(jsonstring);

foreach (JObject jObject in jArray.Children<JObject>())
{
   foreach (JProperty jProperty in jObject.Properties())
    {
     string name = jProperty.Name.Trim();
      string value = jProperty.Value.ToString().Trim();
        drpValues.Items.Add(new RadComboBoxItem(name, value));
     }
 }

But "selected" also comes as a dropdown value.

Any help is greatly appreciated.

Thank you so much!

-PT

Can you change your json format? It would be easier if you can change it to something like [{"Text" : "Example temp", "Value" : "SomeValue"}, {"Text" : "Example Default", "Value" : "", "selected": true}] — ekad
– ekad, Commented Feb 15, 2014 at 3:19
Thanks for your reply ekad! how do I fill the dropdown with this json, please help! I used this json with my dropdown filling logic and now I have my dropdown values as Example temp, Value, Text, Value — user2659046
– user2659046, Commented Feb 15, 2014 at 4:43

ekad · Accepted Answer · 2014-02-15 05:45:32Z

1

Assuming there's only one default value, this code should work

JArray jArray = JArray.Parse(jsonStr);

bool isDefault;
string defaultValue;
foreach (JObject jObject in jArray.Children<JObject>())
{
    isDefault = false;

    // check if current jObject contains a property named "selected"
    // and if the value is true
    JProperty p = jObject.Properties().SingleOrDefault(x => x.Name == "selected");
    if (p != null && (bool)p.Value == true)
    {
        isDefault = true;
    }

    foreach (JProperty jProperty in jObject.Properties())
    {
        string name = jProperty.Name.Trim();
        string value = jProperty.Value.ToString().Trim();

        if (name != "selected")
        {
            drpValues.Items.Add(new RadComboBoxItem(name, value));
            if (isDefault)
            {
                defaultValue = value;
            }
        }
    }
}

// set the dropdown selected item
RadComboBoxItem itemToSelect = drpValues.FindItemByValue(defaultValue);
itemToSelect.Selected = true;

edited Feb 15, 2014 at 5:45

answered Feb 15, 2014 at 5:03

ekad

14.7k26 gold badges46 silver badges49 bronze badges

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

3 Comments

user2659046 Over a year ago

This looks great! Looking for any answer without changing the Json, Want to be less Json for the user for easy update and less confusion, Thanks a lot for your reply.

user2659046 Over a year ago

can this be done without changing the Json? Thank you!

ekad Over a year ago

see the edited answer, I think that's what you're looking for.

Collectives™ on Stack Overflow

Parse Json using Json Net and C# to fill a dropdown

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related