Binding Json Data in Silverlight

Question

I'm trying to bind a JSON array to a datagrid in Silverlight 3. I do not get any exceptions but I do not see the column values in the datagrid. I do see the rows though, but I do not know what the binding property should be. I do not want to create a class, populate the class and the bind. That works. I do not know what columns and datatypes the json string contains. I want the datagrid to just show all columns that are present in the json object.

Following is the code

Dim J As JsonArray = JsonArray.Load(New StringReader("[{'name':'arun', 'age':26, good:true},{'name':'kumar', 'age':28, good:false}]"))

For Each JJ In J
    MessageBox.Show(JJ("name")) 'This shows the proper names'
Next

Dim c = New DataGridTextColumn()
c.Binding = New Binding("name")
GridUsers.Columns.Add(c)
GridUsers.ItemsSource = J

I do see 2 rows in the grid, but the columns values are always blank. What am I missing the binding property?

Many Thanks, Arun

Dave Swersky · Accepted Answer · 2009-08-25 20:38:30Z

1

Have you tried JSON.NET? Version 3 apparently has support specifically for Silverlight 3:

http://james.newtonking.com/archive/2008/08/25/json-net-3-0-released.aspx

answered Aug 25, 2009 at 20:38

Dave Swersky

34.8k9 gold badges83 silver badges120 bronze badges

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

1 Comment

Arun Over a year ago

Thanks Dave, I have heard of JSON.net, but my problem is not with parsing the JSON. That works fine with System.JSON. My problem is with binding an anonymous object with a datagrid

mikemay · Accepted Answer · 2009-12-18 12:53:30Z

0

This looks similar to the problem of binding to dynamically created columns. See http://www.scottlogic.co.uk/blog/colin/2009/04/binding-a-silverlight-datagrid-to-dynamic-data-via-idictionary/]1. The secret is to make the entire object the binding source and use a value converter and a converter parameter to identify individual members.

answered Dec 18, 2009 at 12:53

mikemay

4,9977 gold badges37 silver badges38 bronze badges

Collectives™ on Stack Overflow

Binding Json Data in Silverlight

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related