Read a JSON object using VB.Net

Question

Sorry but I'm at a loss. I'm trying to loop the following JSON object using Newtonsoft so that I can process some code

      [{"FirstName":"Andrea","Middlename":"M.","LastName":"Smith"},{"FirstName":"Ronald","Middlename":"E.","LastName":"Jones"}]

What I need is a simple loop that will read the names and send to a database. So I want to

    For  .....
    Dim FirstName as string = 
    Dim Middlename =""
    Dim LastName = ""

    Send to data base FirstName + " " + MiddleName + " " + LastName
    Loop

Thanks for the help and if this is listed somewhere else I have not been able to find it

Search for “newtonsoft json deserialize array vb.net” and you’ll find plenty of examples. — Ola Ekdahl
– Ola Ekdahl, Commented Feb 20, 2018 at 21:28

Bill · Accepted Answer · 2018-02-20 21:32:51Z

2

Worked out my own answer. First created a class

       Public Class Person
       Public FirstName As String
       Public MiddleName As String
       Public LastName As String
       End Class

Then

     Dim JObject = JsonConvert.DeserializeObject(Of Person())(JSON)

Then

Looped it

        For i = 0 To JObject.Length - 1
        firstname = JObject(i).FirstName
        Next

answered Feb 20, 2018 at 21:32

Bill

1,5172 gold badges36 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

Read a JSON object using VB.Net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related