Professor Haseeb
Professor Haseeb

Reputation: 121

Converting JSON to Array in VB.NET

I have this code

Dim x As String
x = "{'books':[{'title':'HarryPotter','pages':'134'}]}"

what i want to do is to convert it into array like we do in PHP using the json_decode(x,TRUE or FALSE) function

Upvotes: 4

Views: 23386

Answers (2)

sloth
sloth

Reputation: 101072

Your string x does not contain an array, but a single JSON object.

Just use a JSON library like Json.NET to parse your string:

Dim x = "{'books':[{'title':'HarryPotter','pages':'134'}]}"

Dim result = JsonConvert.DeserializeObject(x)
Console.WriteLine(result("books")(0)("title") & " - " & result("books")(0)("pages"))

Output:

HarryPotter - 134

Upvotes: 9

Deja Vu
Deja Vu

Reputation: 413

@Professor Haseeb Maybe you forget to Add the following to @Dominic Kexel solution:

Imports Newtonsoft.Json

Or use:

Dim result = Newtonsoft.Json.JsonConvert.DeserializeObject(x)

Upvotes: 3

Related Questions