How format array json in ASP.NET C#

Question

2.00/5 (2 votes)

See more:

In code asp.net i get result like following:

[ { "CustomerId": 1, "Name": "Akki", "Country": "india" }, { "CustomerId": 3, "Name": "Jyothi", "Country": "france" }, { "CustomerId": 4, "Name": "Fatima", "Country": "india" }, { "CustomerId": 5, "Name": "Ankita1", "Country": "india" }, { "CustomerId": 6, "Name": "Yash", "Country": "india" }, { "CustomerId": 7, "Name": "Garauv", "Country": "india" }, { "CustomerId": 8, "Name": "grgr", "Country": "gegerg" }, { "CustomerId": 9, "Name": "prashant", "Country": "india" }, { "CustomerId": 10, "Name": "Rajesh", "Country": "Austerila" }, { "CustomerId": 11, "Name": "Fatima", "Country": "India" }, { "CustomerId": 12, "Name": "Rajesh", "Country": "Sydney" }, { "CustomerId": 13, "Name": "", "Country": "" } ]

i want to format above Array.json like following

[ 
{
 "CustomerId": 1,
 "Name": "Akki", 
"Country": "india" 
},
{ 
"CustomerId": 3, 
"Name": "Jyothi", 
"Country": "france"
 }, 
{ "CustomerId": 4, 
"Name": "Fatima",
 "Country": "india" 
}
]

and print on page

What I have tried:

i tried various thing ,but could not successes

Posted 26-Nov-19 19:31pm

Akshay malvankar

Updated 26-Nov-19 20:22pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2019-11-26T20:22:00

Quote:
In code asp.net i get result like following:

That is the standard way of data transfer, whitespaces and newlines are removed since they are only overhead on the raw payload and do not serve any performance improvement in the data parsing — on the contrary, they do the opposite, they take extra space and make the algorithm slower.

Quote:
i want to format above Array.json like following

That depends upon where you are showing the data. For example, several tools like Postman would contain a program that makes the syntax readable for humans. A program does not care about the readability, only the validity of the content.

On web browsers, there are extensions available that can improve the readability and structure of the JSON document for you. But all of this is totally debatable.

See this online tool for example, JSON Formatter & Validator[^]

In C#, you can use the JsonConvert library to deserialize the content with indentation,

C#

var indentedJson = JsonConvert.SerializeObject(obj, Formatting.Indented);

Taken from here: JSON formatter in C#? - Stack Overflow[^]
Serialize an Object[^]