Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
364 views
in Technique[技术] by (71.8m points)

Retrieving json data which in C#

I want to deserialise the following Json. I have tried the following:

JSON Data:

{
  "data":[
  {
      "employee":[
      {
          "empdetails":[
          {
              "empid":"40",
              "empname":"Amit",
              "empdept":"Director",
              "empphone":[
              {
                  "home":"23432235",
                  "office":"2352353",
              }]
          },
          {
              "empid":"54",
              "empname":"Abhishek",
              "empdept":"HR",
             "empphone":[
              {
                  "home":"5445457",
                  "office":"34634634",
              }]
          },
          {
              "empid":"80",
              "empname":"Rahul",
              "empdept":"Finance"
          },
          {
              "empid":"71",
              "empname":"Anand",
              "empdept":"Marketing",
             "empphone":[
              {
                  "home":"46346346",
                  "office":"346346346",
              }]
          }]
      }],
}

Code:

using System;
using Newtonsoft.Json.linq;
using System.Collections.Generics;

class Program
{
public class emp
{
public int empid {get; set;}
public string empname {get; set;}
public string empdept {get; set;}
public string empcontact {get; set; }
}
static void main(string[] args)
{
WebClient c= new WebClient();
var json = c.DownloadString(new uri("sampleurl"));
dynamic dynamicObj=JsonConvert.DeserializeObject(json);
foreach (var data in dynamicObj.data)
{
foreach (var getempdet in data.employee)
{
foreach(var dat in getempdet)
{
foreach(var datas in dat)
{
foreach(var getempdetails in datas)
{
foreach(var finaldata in getempdetails)
{
Console.WriteLine("	{0}", finaldata);
List<emp> empList=newList<emp>();
}
}
}
}
}
}
Console.ReadLine();
}
}
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Create C# classes that map to your json. As below:

public class Data
{
    public List<Employee> Employees { get; set; }
}

public class Employee
{
    public List<EmpDetails> EmpDetailss { get; set; }
}

public class EmpDetails
{
    public int Empid { get; set; }
    public string Empname { get; set; }
    public string Empdept { get; set; }
    public EmpPhone EmpPhone{ get; set; }
}

public class EmpPhone
{
    public string Home { get; set; }
    public string Office { get; set; }
}

and then

WebClient c = new WebClient();
var json = c.DownloadString("sampleurl");
Data data = JsonConvert.DeserializeObject<Data>(json);

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

1.4m articles

1.4m replys

5 comments

57.0k users

...