The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Creating a JSON Request using VB.NET
Posted on 2016-08-25
I have to create a JSON request in the following format
{
"companyId": 1111,
"shipDate": "2016-08-25",
"notes": "ABC",
"Items":
[
{
"productId": 111,
"Type": "9",
"Qty": 2,
"cost": 3,
"price": 3.50,
}
]
}
So far, I have created two classes:
Public Class SaleOrder
Public Property companyId As Integer
Public Property shipDate As Date
Public Property notes As String
Public Property Items As Items
End Class
Public Class Items
Public Property productId As Integer
Public Property Type As String
Public Property Qty As Integer
Public Property cost As Double
Public Property price As Double
End Class
Below is my code in VB.NET
Dim OrderList As New List(Of SaleOrder()
Dim SaleOrder As New SaleOrder()
SaleOrder.companyId= "1111"
SaleOrder.notes = "ABC"
SaleOrder.shipDate = Now.ToString("yyyy-MM-dd")
SaleOrder.Items.productId = 111
SaleOrder.Items.Type = "9"
SaleOrder.Items.Qty = 3
SaleOrder.Items.cost = 2
SaleOrder.Items.price = 3.5
OrderList.Add(SaleOrder)
I am getting "object reference not set to instance..." error on
SaleOrder.Items.productId
It the way I am trying to create the Items array wrong?
{
"companyId": 1111,
"shipDate": "2016-08-25",
"notes": "ABC",
"Items":
[
{
"productId": 111,
"Type": "9",
"Qty": 2,
"cost": 3,
"price": 3.50,
}
]
}
So far, I have created two classes:
Public Class SaleOrder
Public Property companyId As Integer
Public Property shipDate As Date
Public Property notes As String
Public Property Items As Items
End Class
Public Class Items
Public Property productId As Integer
Public Property Type As String
Public Property Qty As Integer
Public Property cost As Double
Public Property price As Double
End Class
Below is my code in VB.NET
Dim OrderList As New List(Of SaleOrder()
Dim SaleOrder As New SaleOrder()
SaleOrder.companyId= "1111"
SaleOrder.notes = "ABC"
SaleOrder.shipDate = Now.ToString("yyyy-MM-dd")
SaleOrder.Items.productId = 111
SaleOrder.Items.Type = "9"
SaleOrder.Items.Qty = 3
SaleOrder.Items.cost = 2
SaleOrder.Items.price = 3.5
OrderList.Add(SaleOrder)
I am getting "object reference not set to instance..." error on
SaleOrder.Items.productId
It the way I am trying to create the Items array wrong?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
2
7 Comments
Active 1 day ago
change;
for
Public Property Items As Items
for
Public Property Items As new list(of Items)
Active 5 days ago
Thanks! Got it. I made the following change
Dim Item As New Items()
Item.productId = 111
Item.Type = "9"
Item.Qty = 3
Item.cost = 2
Item.price = 3.5
SaleOrder.Item = Item
OrderList.Add(SaleOrder)
This created the JSON request as
[{
"companyId": 1111,
"shipDate": "2016-08-25",
"notes": "ABC",
"Items":
{
"productId": 111,
"Type": "9",
"Qty": 2,
"cost": 3,
"price": 3.50,
}
}]
Items is created as an object. How to I convert it to array so it looks exactly like the sample in my question?
Dim Item As New Items()
Item.productId = 111
Item.Type = "9"
Item.Qty = 3
Item.cost = 2
Item.price = 3.5
SaleOrder.Item = Item
OrderList.Add(SaleOrder)
This created the JSON request as
[{
"companyId": 1111,
"shipDate": "2016-08-25",
"notes": "ABC",
"Items":
{
"productId": 111,
"Type": "9",
"Qty": 2,
"cost": 3,
"price": 3.50,
}
}]
Items is created as an object. How to I convert it to array so it looks exactly like the sample in my question?
Active 5 days ago
If I declare Items as
Public Property Items As new list(of Items)
Can you please let me know how do I assign it values?
Item.productId = 111
Item.Type = "9"
Item.Qty = 3
Item.cost = 2
Item.price = 3.5
as the above wouldn't work anymore.
Public Property Items As new list(of Items)
Can you please let me know how do I assign it values?
Item.productId = 111
Item.Type = "9"
Item.Qty = 3
Item.cost = 2
Item.price = 3.5
as the above wouldn't work anymore.
Active 1 day ago
if you would like to be clean, your class:
should be declared as:
because a class instance contains only 1 item
you will have to change your property for:
then you do something like to create an instance of the class:
to finally add your item to the collection:
Public Class Items
should be declared as:
Public Class Item
because a class instance contains only 1 item
you will have to change your property for:
Public Property Items As new list(of Item)
then you do something like to create an instance of the class:
dim x as new Item
x.productId = 111
x.Type = "9"
x.Qty = 3
x.cost = 2
x.price = 3.5
to finally add your item to the collection:
SaleOrder.Items.Add(x)
Featured Post
A day that will go down in Cloud history.. But are you ready for it? Will you accept this Cloud challenge?
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special.
It's completely agentless, but does let you create an agent, if you desire.
It offers powerful scalability …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 2 hours left to enroll
635 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.