How to get selected value from complex Json data using C# in ASP.Net

Hi Vikash21,

You need to customize the code according to your need generic solution wont be available for complicated json so refer below sample code

C#

protected void Page_Load(object sender, EventArgs e)
{
    StreamReader stRead = new StreamReader(Server.MapPath("~/Test1.json"));
    DataTable dataTable = GetDataTableFromJsonString(stRead.ReadToEnd());
}

public DataTable GetDataTableFromJsonString(string json)
{
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[] {
        new DataColumn("TITLE")
        ,new DataColumn("ORGNAME")
        ,new DataColumn("PERSONAME")
        ,new DataColumn("ADDRESS")
        ,new DataColumn("CC_EMAIL")
        ,new DataColumn("PHONE")
        ,new DataColumn("EMAIL") });
    var jsonLinq = JObject.Parse(json);
    JToken id;
    string title = string.Empty;
    string orgName = string.Empty;
    string cc_email = string.Empty;
    string address = string.Empty;
    string personName = string.Empty;
    string email = string.Empty;
    string phone = string.Empty;
    List<JToken> results = jsonLinq.Children().ToList();
    foreach (JProperty item in results)
    {
        item.CreateReader();
        if (item.Name == "data")
        {
            id = item.Value;
            foreach (JObject jProp in id.Children().ToList())
            {
                title = jProp["title"].ToString();
                foreach (JProperty jitem in jProp["org_id"].Children().ToList())
                {
                    if (jitem.Name == "name")
                    {
                        orgName = jitem.Value.ToString();
                    }
                    if (jitem.Name == "cc_email")
                    {
                        cc_email = jitem.Value.ToString();
                    }
                    if (jitem.Name == "address")
                    {
                        address = jitem.Value.ToString();
                    }
                }
                foreach (JProperty jitem in jProp["person_id"].Children().ToList())
                {
                    if (jitem.Name == "name")
                    {
                        personName = jitem.Value.ToString();
                    }
                    if (jitem.Name == "email")
                    {
                        if (jitem.Value.Type == JTokenType.Array)
                        {
                            JArray items = (JArray)jitem.Value;
                            email = items[0].SelectToken("value").ToString();
                        }
                    }
                    if (jitem.Name == "phone")
                    {
                        if (jitem.Value.Type == JTokenType.Array)
                        {
                            JArray items = (JArray)jitem.Value;
                            phone = items[0].SelectToken("value").ToString();
                        }
                    }
                }
            }
            dt.Rows.Add(title, orgName, personName, address, cc_email, phone, email);
        }
    }
    return dt;
}