JSON serialization from folder into c#. Beginner!

Question

1.00/5 (1 vote)

See more:

VS2010

Hi,

I'm very new to this, so I really hope there is somebody smart out there that will help me.

My JSON file looks like this (index3.json):
{"weeks": [{ "week": 1, "mothertext":"Det her er uge 1 mor", "babytext": "Det her er uge 1 baby" } ,{ "week": 2, "mothertext":"Det her er uge 2 mor", "babytext": "Det her er uge 2 baby" } ,{ "week": 3, "mothertext":"Det her er uge 3 mor", "babytext": "Det her er uge 3 baby" } ]}

I want to create an array in visual studio so its possible to insert the text from the different properties. I.e. week.mothertext[1] (or how it would look like) would deliver a string with "Det her er uge 2 mor" and so on.

This is my code which I must admit is losely constructed from code I have found on the web.

C#

public InformationPage()
{
   InitializeComponent();
}
 
public class weeksArray
{
   public weekProperties[] weeklist { get; set; }
}
 
public class weekProperties
{
   public int week { get; set; }
   public string mothertext { get; set; }
   public string babytext { get; set; }
}
 
private void myButton1_Click(object sender, RoutedEventArgs e)
{

   var client = new WebClient();
 
   client.OpenReadCompleted += 
      ( s, eargs ) = >
      {
         var serializer = new DataContractJsonSerializer(typeof(weeksArray));
         var dataArray = (weeksArray)serializer.ReadObject(eargs.Result);
 
         foreach(var obj in dataArray.weeks)
             //This sort of works but doesnt allow me to retrieve the indidual objects like the
            //the text for week: 3 only.
         {
            textBoxWeek0.TextWriter = textBoxWeek0.Text + obj.week;
         }
      };
   var uri = new Uri("http://...../index3.json");
   client.OpenReadAsync( uri );
}

Posted 8-Nov-12 8:22am

Kasper Andersen

Updated 8-Nov-12 8:26am

fjdiewornncalwe

v3

Add a Solution

2 solutions

Solution 1

Hi,
Look at NewtonSoft.Json, it allows you to serialize and deserialize objects incredibly easily.
Can be installed via NuGet

Posted 8-Nov-12 8:59am

mickfarrow

Comments

Kasper Andersen 8-Nov-12 16:12pm

I'm actually using NewtonSoft.Json...
I just can't get it to work properly.

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)

mickfarrow · Accepted Answer · 2012-11-08T10:58:00

Preview
Hi Kasper,

I may be on the wrong track here, but please find below a few lines that work with your json.

class Program
{
    static void Main(string[] args)
    {
        string json = "[{\"week\":\"1\",\"mothertext\":\"Det her er uge 1 mor\",\"babytext\":\"Det her er uge 1 baby\"},{\"week\":\"2\",\"mothertext\":\"Det her er uge 2 mor\",\"babytext\":\"Det her er uge 2 baby\"},{\"week\":\"3\",\"mothertext\":\"Det her er uge 3 mor\",\"babytext\":\"Det her er uge 3 baby\"}]";
 
        List<Week> weeks = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Week>>(json);
        foreach (Week week in weeks)
        {
            Console.WriteLine("Week {0} - {1} - {2}", week.week, week.mothertext, week.babytext);
        }
        Console.ReadLine();
    }
}
public class Week
{
    public string week { get; set; }
    public string mothertext { get; set; }
    public string babytext { get; set; }
}

Example use of lambda expression to filter results

C#

var filteredWeeks = weeks.Where(x => x.week == "2");
            foreach (Week week in weeks)
            {
                Console.WriteLine("Week {0} - {1} - {2}", week.week, week.mothertext, week.babytext);
            }
            Console.WriteLine("Filtered");
            foreach (Week filteredWeek in filteredWeeks)
            {
                Console.WriteLine("Week {0} - {1} - {2}", filteredWeek.week, filteredWeek.mothertext, filteredWeek.babytext);
            }
            Console.ReadLine();