Trying to return dataset from web api in ASP.NET

Question

1.00/5 (1 vote)

See more:

Hi Guys,

I am trying to learn Web api by my own, for the same i have developed very basic Login application in asp.net and middle layar as web api to interact with database.
Everything works fine until the response received at client side. i am converting dataset into JSON in asp.net and at client side(ASP.net application) JSON string which is received is not in proper format(as below).

"{\r\n \"Table\": [\r\n {\r\n \"RESULT\": \"1\"\r\n }\r\n ],\r\n \"Table1\": [\r\n {\r\n \"RESULT\": \"2\"\r\n }\r\n ]\r\n}"

So request you to suggest me a proper solution so that i can received JSON as per below .

"{
"Table":
[
{"RESULT":"1"}
],
"Table1":
[
{"RESULT":"2"}
]
}".

Your precious revert is expected, please do the needful.

Thanks in advance.

What I have tried:

I tried to remove \\ using replace function in c#, but it does not work as per requirement.

Posted 18-Jun-19 7:12am

Sachin11089

Updated 13-Oct-20 20:54pm

Add a Solution

Comments

Richard MacCutchan 18-Jun-19 13:37pm

Make sure the sending part is formatting it correctly.

F-ES Sitecore 19-Jun-19 5:18am

Those "\t" type characters aren't actually in the text, it's just the debuggers way of letting you know there is a tab, or a new line etc. As long as you are correctly deserialising your json it will still work.

2 solutions

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)

Gerry Schmitz · Answer 1 · 2019-06-18T11:08:00

Solution 1

Your need to read "lines" not straight "text".

Straight text maintains the carriage returns and line feeds; "reading as lines" returns a string collection.

c# - What is the difference between File.ReadAllLines() and File.ReadAllText()? - Stack Overflow[^]

Posted 18-Jun-19 11:08am

Gerry Schmitz

S.V.Aaditya.S.V · Answer 2 · 2020-10-13T20:54:00

Hello,

I have faced similar issue where the dataset is being serialized into JSON string and sent as response and at client side it was received in the similar format as in the query. So, I have directly sent the dataset in the response and worked.
Below is what I did.

Set the API ActionMethod return type to

IHttpActionResult

Instead of returning some string, use below

return Ok(YourDataSet);

Most Importantly, set below line in the WebApiConfig.cs file within Register method under App_Start folder...

GlobalConfiguration.Configuration.Formatters.JsonFormatter.MediaTypeMappings.Add(new System.Net.Http.Formatting.RequestHeaderMapping("Accept", "text/html", StringComparison.InvariantCultureIgnoreCase, true, "application/json"));

(Above line in config file is used to format the output in JSON result format).

Hope this solution helps to you or someone who faces similar problem.
Kindly correct me in case this is wrong or should not use.
Thank you.