Read (Parse) JSON data from URL and display in HTML Table in ASP.Net MVC

sunnyk21

SOLVED CLOSED ACTIVE ANSWERED
User: sunnyk21
Posted: on Oct 16, 2019 04:51 AM
Forum: ASP.Net MVC
Answer: 1
Views: 8758
Sample Code: Download

I am able to fetch api data , but the response is coming in collection form, how should i loop through first array and store only that information . The response which i am receiving from api is as follows:

{"ngodetails":[{"id":"DL\/2017\/0165260","name":"\tASSOCIATION FOR SOCIAL SERVICE AND REHABILITATION OF THE AGED ASSRA","registrationNumber":"42540 OF 2002","panNumber":"Available","panVerifyStatus":"V"}],"memberdetails":[{"name":"NAMITA SAHOO","designation":"President","aadhaarNumber":"Available","aadhaarVerifyStatus":"V","panNumber":"Available","panVerifyStatus":"V","LastUpdated":"13-10-2017 07:00:17"},{"name":"PRASHANTA GHADAI","designation":"Vice President","aadhaarNumber":"Available","aadhaarVerifyStatus":"V","panNumber":"Available","panVerifyStatus":"V","LastUpdated":"13-10-2017 07:00:09"},{"name":"ANIL KUMAR ROY","designation":"Secretary","aadhaarNumber":"Available","aadhaarVerifyStatus":"V","panNumber":"Available","panVerifyStatus":"V","LastUpdated":"14-10-2017 11:36:20"}]}

        public ActionResult Index()
        {
            List<ngodarpan> ngo = new List<ngodarpan>();
            string baseurl = "https://ngodarpan.gov.in/ngodarpanws_ndci/apin/getngo/DL_2017_0165260";
            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri(baseurl);
                client.DefaultRequestHeaders.Clear();
                client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
                HttpResponseMessage Res = client.GetAsync(baseurl).Result;
                if (Res.IsSuccessStatusCode)
                {
                    var response = Res.Content.ReadAsStringAsync().Result;
                    ngo = JsonConvert.DeserializeObject<List<ngodarpan>>(response);
                }
                return View(ngo);
            }
        }

@model IEnumerable<eofficeWepApi.Models.ngodarpan>
@{
    ViewBag.Title = "Index";
}

<h2>Index</h2>
<table>
    <thead>
        <tr>
            <th>Id</th>
            <th>Name</th>
            <th>Registration Number</th>
            <th>PanNumber</th>
            <th>PanVerifyStatus</th>

        </tr>
    </thead>
    <tbody>
        @foreach(var i in Model)
        {
        <tr>
            <td>@i.id</td>
            <td>@i.name</td>
            <td>@i.registrationnumber</td>
            <td>@i.panNumber</td>
            <td>@i.panVerifyStatus</td>
        </tr>
        }
    </tbody>
</table>

dharmend...

0 5

Reply
ANSWER
User: dharmendr
Replied: on Oct 17, 2019 07:27 AM
Report

Hi sunnyk21,

Check this example. Now please take its reference and correct your code.

Model

public class ngodarpan
{
    public string id { get; set; }
    public string name { get; set; }
    public string registrationnumber { get; set; }
    public string panNumber { get; set; }
    public string panVerifyStatus { get; set; }
}

Namespaces

using System.Collections.Generic;
using System.Data;
using System.Net.Http;
using System.Web.Mvc;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

Controller

public class HomeController : Controller
{
    // GET: /Home/
    public ActionResult Index()
    {
        List<ngodarpan> ngo = new List<ngodarpan>();
        string baseurl = "https://ngodarpan.gov.in/ngodarpanws_ndci/apin/getngo/DL_2017_0165260";
        using (var client = new HttpClient())
        {
            client.BaseAddress = new Uri(baseurl);
            client.DefaultRequestHeaders.Clear();
            client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
            HttpResponseMessage Res = client.GetAsync(baseurl).Result;
            if (Res.IsSuccessStatusCode)
            {
                var response = Res.Content.ReadAsStringAsync().Result;                
                object obj = JsonConvert.DeserializeObject(response);
                DataSet dsDetails = JsonConvert.DeserializeObject<DataSet>(((JObject)obj).ToString());
                for (int i = 0; i < dsDetails.Tables["ngodetails"].Rows.Count; i++)
                {
                    DataRow dr = dsDetails.Tables["ngodetails"].Rows[i];
                    ngo.Add(new ngodarpan
                    {
                        id = dr["id"].ToString(),
                        name = dr["name"].ToString(),
                        panNumber = dr["panNumber"].ToString(),
                        panVerifyStatus = dr["panVerifyStatus"].ToString(),
                        registrationnumber = dr["registrationnumber"].ToString()
                    });
                }
            }

            return View(ngo);
        }
    }
}

View

<table>
    <tr>
        <th>Id</th>
        <th>Name</th>
        <th>Registration Number</th>
        <th>PanNumber</th>
        <th>PanVerifyStatus</th>
    </tr>
    <% foreach (var item in Model)
        { %>
    <tr>
        <td><%: item.id %></td>
        <td><%: item.name %></td>
        <td><%: item.registrationnumber %></td>
        <td><%: item.panNumber %></td>
        <td><%: item.panVerifyStatus %></td>
    </tr>
    <% } %>
</table>

Screenshot

Read (Parse) JSON data from URL and display in HTML Table in ASP.Net MVC

Company

Explore

Follow us

Contact Us