'Json' help to sort data!

Question

1.00/5 (1 vote)

See more:

I want to get result as "never" from bellow json data
using Newtonsoft.Json
VB 2010

help me :)

{"status":"ok","status_message":"Query was successful","data":{"Go":"Never"}}

What I have tried:

I want to get result as "never" from bellow json data
using Newtonsoft.Json
VB 2010
help me :)

{"status":"ok","status_message":"Query was successful","data":{"Go":"Never"}}

Posted 14-Sep-19 16:58pm

Member 13358124

Updated 14-Sep-19 20:19pm

Add a Solution

2 solutions

Solution 2

In addition to Griff's answer, here is a good article about working with JSON: Working with JSON in C# & VB[^]
It mentions: JSON Utils: Generate C#, VB.Net, SQL Table, Java and PHP from JSON[^]

Posted 14-Sep-19 20:20pm

RickZeeland

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)

OriginalGriff · Accepted Answer · 2019-09-14T20:04:00

Solution 1

To use that JSON, you will need appropriate classes in your code:

VB

Public Class Data
    Public Property Go As String
End Class

Public Class RootObject
    Public Property status As String
    Public Property status_message As String
    Public Property data As Data
End Class

With that, you can use the JsonConvert.DeserializeObject Method[^] to process your JSON, and it will "fill in" your data:

VB

Dim MyData As RootObject = JsonConvert.DeserializeObject(Of RootObject)(jsonStringData)

Posted 14-Sep-19 20:04pm

OriginalGriff

Comments

OriginalGriff 15-Sep-19 2:18am

You're welcome!

BTW: Don't use "txtspk" here - you have a keyboard, use it. Typing as little as possible is a bad idea on a site where the better your info, the better the response. And remember, a very large number of our member do not have English as their first language, so txtspk abbreviations may not make any sense at all to them. nowtimn?