How can use json_decode in C#

Question

1.00/5 (2 votes)

See more:

in mysql database i have custom_field that have some sort of data like this;

{"1":"product","2":"111111"}

i have found json viewer

JSON Viewer[^]

and it decodes the data above but when i look the second row like

a:4:{i:1;s:9:"product";i:3;s:10:"6120359453";i:4;s:0:"";i:5;s:12:"company";}

this is not decoded it says not in proper format.is it a way to decode this data using the same codes like json viewer.

thanks.

What I have tried:

i have tried this a:1:{i:4;s:11:"12772044120";} at unserialize.com this is working i like to know if is this string can be deserialize in c# like

C#

JavaScriptSerializer js = new JavaScriptSerializer();

            try
            {
                Dictionary<string, object> dic = js.Deserialize<Dictionary<string, object>>(txtInput.Text);

                TreeNode rootNode = new TreeNode("Root");
                jsonExplorer.Nodes.Add(rootNode);
                BuildTree(dic, rootNode);
            }
            catch (ArgumentException argE)
            {
                //MessageBox.Show("JSON data is not valid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }

or maybe a php unserialize page at server but i heard it was not a good idea for security, and print_r so i can call in to c# application from web page like

C#

WebClient wc = new WebClient();
            var json = wc.DownloadString(textBox1.Text);

            List<User> users = JsonConvert.DeserializeObject<List<User>>(json);

            dataGridView1.DataSource = users;

any idea please help thanks.

Posted 12-May-16 9:18am

mardag

Updated 15-May-16 8:31am

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 12-May-16 15:22pm

Not clear. After all, convert it to whatever you want. What prevents you from doing so?
—SA

Richard Deeming 12-May-16 15:24pm

That is not a valid JSON string. You need to find out what format it's supposed to be it, and find or write code to parse it.

If it's supposed to be JSON, then find the person who wrote the code that produces it, point them to the official JSON site[^], and tell them to do it again properly.

4 solutions

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)

Dave Kreskowiak · Answer 1 · 2016-05-12T09:40:00

Solution 1

That's not valid JSON formatted data. I don't know what it is.

You're going to have to go back to whatever site this data is coming from and find out what the format is.

Posted 12-May-16 9:40am

Dave Kreskowiak

Patrice T · Answer 2 · 2016-05-12T11:19:00

Solution 2

Quote:
How can use json_decode in C#

To use json decode, you first need to have json data, it is mandatory. The fact that your data loosely look like json don't help.

Either you find what is the data format and find a decoder, either you build your own decoder. No other choice.

Posted 12-May-16 11:19am

Patrice T

mardag · Answer 3 · 2016-05-14T09:01:00

Thank you very much for your answers,
i have tried this a:1:{i:4;s:11:"12772044120";} at unserialize.com this is working i like to know if is this string can be deserialize in c# like

C#

JavaScriptSerializer js = new JavaScriptSerializer();

            try
            {
                Dictionary<string, object> dic = js.Deserialize<Dictionary<string, object>>(txtInput.Text);

                TreeNode rootNode = new TreeNode("Root");
                jsonExplorer.Nodes.Add(rootNode);
                BuildTree(dic, rootNode);
            }
            catch (ArgumentException argE)
            {
                //MessageBox.Show("JSON data is not valid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }

or maybe a php unserialize page at server but i heard it was not a good idea for security, and print_r so i can call in to c# application from web page like

C#

WebClient wc = new WebClient();
            var json = wc.DownloadString(textBox1.Text);

            List<User> users = JsonConvert.DeserializeObject<List<User>>(json);

            dataGridView1.DataSource = users;

any idea please help thanks.

Dmitriy Gakh · Answer 4 · 2016-05-15T08:31:00

Quote:
is it a way to decode this data using the same codes like json viewer.

As I understand it is a question (no question mark set). Then I have only two answers:

No. No, because your format does not comply JSON standard and you cannot directly use JSON libraries here.

Yes. Yes, because you can study sources of JSON Viewer and change codes of this library to read your custom format. But it is not easy way, because need meeting to the license and study of your custom format. You can also study other parsers. So, I think if you understand how JSON Viewer and JSON parsers work, you can find a solution. The key is understanding how parsers work.

How can use json_decode in C#

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0