Returning JSON Array in WCF

Question

In PHP I can do this for example:

while($r = mssql_fetch_assoc($sth)) {
   $rowsField["rowsinfo"][] = $r;
}

print json_encode($rowsField);

Which basically returns a (two/multi dimensional I believe) array and returns it in a JSON format.

I am trying to achieve the same thing as I am moving my website to .NET.

So I am trying to do this in a WCF Web Service and so far I have only had success getting this far with Newtonsoft JSON Converter.

I managed to return a DataTable in JSON format but I now need it to return almost like the array like: [["rowsinfo"]{"Address":"15 Tyne Cresent","Name":"John Smith"}] etc...

How can this be achieved? Is it a DataTable I need to return still?

Thanks

Community · Accepted Answer · 2017-05-23 12:21:10Z

0

Perhaps you'd find this interesting: C# WCF REST client JSON array or Generate JSON array with WCF

Looks like there are a lot of questions about it already where you could potentially find more information.

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Oct 31, 2013 at 10:22

Johan

7532 gold badges11 silver badges31 bronze badges

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

Comments

Pawan Nogariya · Accepted Answer · 2013-10-31 10:30:34Z

0

return this List<string, List<string>()>()

or just the multidimensional array

string[,] array = new string[4, 2];

edited Oct 31, 2013 at 10:30

answered Oct 31, 2013 at 10:23

Pawan Nogariya

9,04614 gold badges61 silver badges137 bronze badges

3 Comments

realtek Over a year ago

Will this work if I don't know what columns I will be displaying from the database? Basically, the SQL Query that is executed is dynamic so will not always return the same data

Pawan Nogariya Over a year ago

Hmm yes, it that is the case, I just edited my answer

realtek Over a year ago

hmm, it doesn't seem to like this. How would I then add my SQL results to this list? Thanks!

Collectives™ on Stack Overflow

Returning JSON Array in WCF

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related