Saving in existing JSON file using C#

Question

0.00/5 (No votes)

See more:

I have to save data in a JSON file. the data has to be inserted under a existing category. I am not able to write the data under the required category, instead it is coming as a seperate one. Please find the code below.

"CategoryName": [{
	"SubCategoryName": "Test2",
	"HostName": "111.222.225.15",
	"UserName": "AAAA",
	"Password": "AAAA",
	"IsActive": true
},
{
	"SubCategoryName": "test 1",
	"HostName": "11.11.11.11",
	"UserName": "3333",
	"Password": "33333",
	"IsActive": false
}]

I want to add a third Sub Category, but i am unable to do it?

What I have tried:

I have tried to read the data from the existing json file and assign it to a object and tried to write into the file again.
I am not able to write the new data into the file.

Posted 8-Sep-17 2:47am

Prakash Sekhar

Updated 8-Sep-17 2:59am

Graeme_Grant

v2

Add a Solution

1 solution

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)

Graeme_Grant · Answer 1 · 2017-09-08T02:57:00

Solution 1

Convert to classes, Add the extra data, then convert back and save the JSON. This article will show you how: Working with JSON in C# & VB[^]

Posted 8-Sep-17 2:57am

Graeme_Grant

Comments

Prakash Sekhar 11-Sep-17 2:17am

I went through the link which u had posted but i am not able to get it work correctly.
1. How to convert to classes and then add the new data. Can you explain more?

Graeme_Grant 11-Sep-17 2:21am

What do you want me to explain? Did you download the code? There are 6 different projects in the solution that are used in the article. All projects are fully working.

The article also explains how to convert JSON data into classes.

Prakash Sekhar 11-Sep-17 2:55am

I have downloaded the 3 solutions. I am not able to understand the implementation properly.

Graeme_Grant 11-Sep-17 3:58am

You followed the first example? JSON Utils[^] to generate the classes? If you have, I show you how to load the JSON from a file and how to convert it to the generated classes - 2 lines of code with the helper class. What is not to understand?

Prakash Sekhar 11-Sep-17 5:23am

i have generated the classes using JSON utils. I have the class file. What i need to do next?

Graeme_Grant 11-Sep-17 5:30am

Follow the instructions in the article. Read the json into a string and use the JsonHelper class... It is all in the article and the sample code provided. Look at the Etsy Category example (screenshot & code included). You can even run the sample code that you downloaded and watch it work.

Prakash Sekhar 11-Sep-17 6:18am

{ "CategoryInfo": [
{
"CategoryName": "AAA",
"SubCategoryName": [
{
"ConnectionName": "Test2"
},
{
"ConnectionName": "test 1"
}
]
},
{
"CategoryName": "XYZ",
"SubCategoryName": [
{
"ConnectionName": "Test8"
},
{
"ConnectionName": "test 2"
}
]
}
]
}

This is the structure which i have. I am trying to add a new ConnectionName under SubCategoryName. In the article i am not able to find the code to add new data to existing data.