Parse JSON Array using Newtonsoft

Question

I'm working on a project in which I want to deserialize a JSON Array. I have tried but didn't get how to parse it.

JSON ARRAY:

{"showAttendanceResult":[{"lec_no":"FA10-BCS-40","reg_no":"2","std_status":"A","std_username":"fahidnadeem"},{"lec_no":"FA10-BCS-4","reg_no":"2","std_status":"A","std_username":"muneebamjad"}]}

Here is the JSON which I get from the WebService:

How I Tried:

    string URL = "http://localhost:32319/ServiceEmployeeLogin.svc/getattendance";
    WebRequest wrGETURL;
    wrGETURL = WebRequest.Create(URL + "/" + Server.UrlEncode("24-06-2014"));
    wrGETURL.Method = "POST";
    wrGETURL.ContentType = @"application/json; charset=utf-8";
    HttpWebResponse webresponse = wrGETURL.GetResponse() as HttpWebResponse;

    Encoding enc = System.Text.Encoding.GetEncoding("utf-8");
    // read response stream from response object
    StreamReader loResponseStream = new StreamReader(webresponse.GetResponseStream(), enc);

    // read string from stream data
    strResult = loResponseStream.ReadToEnd();
    // close the stream object
    loResponseStream.Close();
    // close the response object
    webresponse.Close();

    RootObject ro = JsonConvert.DeserializeObject<RootObject>(strResult);

    //what to do now?
    }
}

public class ShowAttendanceResult
{
    public string lec_no { get; set; }
    public string reg_no { get; set; }
    public string std_status { get; set; }
    public string std_username { get; set; }
}

public class RootObject
{
    public List<ShowAttendanceResult> showAttendanceResult { get; set; }
}

I want the values in string, im new and i dont know how to get these values from json array. — Fahid Nadeem
– Fahid Nadeem, Commented Jun 24, 2014 at 13:49
@DhavalPatel thanks for your response, but how can i get these values FA10-BCS-40, 2, A from "lec_no":"FA10-BCS-40","reg_no":"2","std_status":"A" — Fahid Nadeem
– Fahid Nadeem, Commented Jun 24, 2014 at 13:55

MRebai · Accepted Answer · 2014-06-24 14:00:59Z

3

RootObject ro = JsonConvert.DeserializeObject<RootObject>(strResult);

foreach(var item in ro.showAttendanceResult)
{
    string _name= item.lec_no;
}

answered Jun 24, 2014 at 14:00

MRebai

5,4823 gold badges35 silver badges55 bronze badges

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

Comments

gligoran · Accepted Answer · 2015-03-06 14:32:27Z

1

You can use something like this:

foreach(var item in ro.showAttendanceResult)
{
    string lec_no = item.lec_no;
}

edited Mar 6, 2015 at 14:32

gligoran

3,3484 gold badges35 silver badges47 bronze badges

answered Jun 24, 2014 at 13:55

Dhaval Patel

7,6116 gold badges43 silver badges72 bronze badges

Collectives™ on Stack Overflow

Parse JSON Array using Newtonsoft

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related