how to display JSON output in asp.net webpage from sql database

Question

i want to print following output by fetching data from sql in C#. I dont want to use asp.net web service. I just want to print JSON output on .aspx page.

{
    "dept_updates":
    [
        {
            "id":"11",
            "subject":"zzz",
            "utime":"Saturday 4th July 2015 05:20:29",
            "description":"zz","branch":"Computer Engineering",
            "flag":"http:\/\/www.emample.com\/login\/image\/5.jpg",
            "uploadedby":"JD"
        },
        {
            "id":"10",
            "subject":"hhh",
            "utime":"Monday 25th May 2015 02:48:46",
            "description":"hh","branch":"Information Technology",
            "flag":"http:\/\/www.example.com\/login\/image\/1\,
            "uploadedby":"JD"
         }

    ]
}

Thomas Koelle · Accepted Answer · 2015-09-10 10:09:21Z

1

I think the most straightforward way would be this:

<pre><%Response.Write(HttpUtility.HtmlEncode("foo")); %></pre>

(replace "foo" with JSON)

Notice how the pre should keep the spacing, and the HtmlCode should do that nothing bad comes out on screen.

answered Sep 10, 2015 at 10:09

Thomas Koelle

3,8742 gold badges30 silver badges53 bronze badges

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

3 Comments

Jtin Over a year ago

thanks for answering. But can you give me whole code from fetching data from database to printing it in JSON using C#

Thomas Koelle Over a year ago

Sorry. My advice is you add a new datamodel toss tables into there and then use Link to Entities.

Jtin Over a year ago

sorry, I am not getting. Because i dont have that much of knowledge. :)

Collectives™ on Stack Overflow

how to display JSON output in asp.net webpage from sql database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related