Converting genric list in c# to json

Question

4.00/5 (3 votes)

See more:

I am try to covert a c# object to json but am getting json obj in this way

"{\"PkUserId\":1,\"CubicalName\":\"21547\"}"

C#

System.Web.Script.Serialization.JavaScriptSerializer jSearializer =
                   new System.Web.Script.Serialization.JavaScriptSerializer();
            string list = jSearializer.Serialize(genricobj);

C#

public class UserProfile
    {
        [DataMember]
        public int PkUserId { set; get; }

        [DataMember]
        public string CubicalName { get; set; }
}

the problem is the above json is not a correct json format.

C#

List loginInfolist=new List();
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                {
 foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                    
                    loginInfoDC = new UserProfile();
                    loginInfoDC.PkUserId = Convert.ToInt32(dr["pkUserId"]);
                    loginInfoDC.CubicalName = Convert.ToString(dr["CubicalName"]);
                    loginInfolist.add(loginInfoDC);
                } 

                }

i want to know how to serialise to json and how to differentiate it with list index
say list[0] json and the lit[1]json

meant all the serialised json of the list will be in same json obj how to differentiate

Posted 25-Jan-14 21:39pm

naveend915

Updated 25-Jan-14 22:35pm

Sampath Lokuge

v3

Add a Solution

Comments

Sampath Lokuge 26-Jan-14 3:41am

Which format do you expect ?

naveend915 26-Jan-14 4:06am

Json format like this

{"PkUserId":1,"CubicalName":"21547"}

Sampath Lokuge 26-Jan-14 4:08am

Can you put your 'genricobj' code snippet also ?

naveend915 26-Jan-14 4:14am

public class UserProfile
{
[DataMember]
public int PkUserId { set; get; }

[DataMember]
public string CubicalName { get; set; }
}

Sampath Lokuge 26-Jan-14 4:16am

Not only this,the way you fill the data into 'genricobj' ?

naveend915 26-Jan-14 4:32am

List<userprofile> loginInfolist=new List<userprofile>();
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{

loginInfoDC = new UserProfile();
loginInfoDC.PkUserId = Convert.ToInt32(dr["pkUserId"]);
loginInfoDC.CubicalName = Convert.ToString(dr["CubicalName"]);
loginInfolist.add(loginInfoDC);
}

}

i want to know how to serialise to json and how to differentiate it with list index
say list[0] json and the lit[1]json

meant all the serialised json of the list will be in same json obj how to differentiate

naveend915 26-Jan-14 4:33am

List<userprofile> loginInfolist=new List<userprofile>();
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{

loginInfoDC = new UserProfile();
loginInfoDC.PkUserId = Convert.ToInt32(dr["pkUserId"]);
loginInfoDC.CubicalName = Convert.ToString(dr["CubicalName"]);
loginInfolist.add(loginInfoDC);
}

}

i want to know how to serialise to json and how to differentiate it with list index
say list[0] json and the lit[1]json

meant all the serialised json of the list will be in same json obj how to differentiate

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)

Kornfeld Eliyahu Peter · Answer 1 · 2014-01-25T22:54:00

Solution 1

Microsoft's JavaScriptSerializer is not a Json serializer!!! So it will escape special chars...
Use Json.NET - much better...
http://james.newtonking.com/json[^]

Posted 25-Jan-14 22:54pm

Kornfeld Eliyahu Peter

Comments

Sampath Lokuge 26-Jan-14 5:00am

+ 5 :)

Kornfeld Eliyahu Peter 26-Jan-14 5:02am

Thanks...

naveend915 26-Jan-14 6:34am

Can u please give an example how to do that?

naveend915 26-Jan-14 6:34am

i have used JsonConvert.SerializeObject(result) , even then same issue so can u please give an example ?

Kornfeld Eliyahu Peter 26-Jan-14 6:39am

1. there are over a 100 samples here:http://james.newtonking.com/json/help/index.html?topic=html/Samples.htm
2. are you looking at your result in the debug window?

naveend915 26-Jan-14 6:52am

ya am seeing it, i am getting like this

sonConvert.SerializeObject(result)

"{\"PkUserId\":1,\"CubicalName\":\"21547\"}"

even when i use

Kornfeld Eliyahu Peter 26-Jan-14 7:06am

What you see in the debugger windows has no meaning - it's escaped.
In the real word you have no \" there but only "...

naveend915 26-Jan-14 7:27am

When i download it as a json file even then it has
"{\"PkUserId\":1,\"CubicalName\":\"21547\"}"

Kornfeld Eliyahu Peter 26-Jan-14 7:41am

You definitely looking at the wrong place - the result is a valid JSON - the escape char (\) you see is NOT PART of the result...
Please try to elaborate so we can see together...