Convert string List data to json format

Ravi Birla

Hello Everyone

I need your help. I'm working on windows service on 4.0 version using c# i want to convert string list to json format and pass that json data to third party.

My code is:-

List msisdnlist = new List();

msisdnlist.Add(rdr.GetInt64(0).ToString());

var jsonSerialiser = new JavaScriptSerializer();
var result = jsonSerialiser.Serialize(msisdnlist);

and also try this one:-

//var result = Newtonsoft.Json.JsonConvert.SerializeObject(msisdnlist);

//var result = JsonConvert.SerializeObject(msisdnlist);

now my problem is i'm not gatting the data in correct format and how to pass that data to third party.

data format which i'm gatting is-

["919464522803","919445453803"]

but i want this format -

{"msisdn": ["9418451354", "9617853673"]}

Please Help me.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp9y ago
Accepted answer
Hi,

In which line are you getting this exception?
Can you please check what value are you getting for below code?

rdr.GetInt64(0).ToString()
Ravi Birla9y ago
Thanks Both of you Midhun Sir and Ravi Sir my issue has been resolved.

below code is working fine.

List msisdnlist = new List();
msisdnlist.Add(rdr.GetInt64(0).ToString());
var jsonSerialiser = new JavaScriptSerializer();
var result = jsonSerialiser.Serialize(new{msisdn=msisdnlist});

once again thanks a lot.
Ravi Birla9y ago
Hi Mithun Sir

I'm getting msisdn like this:-

"(919815465349,919815846249)"
thanks
Ravi Birla9y ago
First of all Thanks for your reply sir
List msisdnlist = new List();
msisdnlist.Add(rdr.GetInt64(0).ToString());
var jsonSerialiser = new JavaScriptSerializer();
dynamic collectionWrapper = new
{
msisdnlist = msisdnlist
};
var result = jsonSerialiser.Serialize(collectionWrapper);
after using above code i'm getting this excepation

"Input string was not in a correct format".

and the output is same(["919464522803","919445453803"]) after using your code @Ravi Patel Sir

Thanks
Ravi Patel9y ago
Hi ,

try this

List msisdnlist = new List();
msisdnlist.Add(rdr.GetInt64(0).ToString());
var jsonSerialiser = new JavaScriptSerializer();
var result = jsonSerialiser.Serialize(new{msisdn=msisdnlist});
Midhun Tp9y ago
Hi,

Please try below code -
List msisdnlist = new List();
msisdnlist.Add(rdr.GetInt64(0).ToString());
var jsonSerialiser = new JavaScriptSerializer();
dynamic collectionWrapper = new
{
    msisdnlist = msisdnlist
};
var result = jsonSerialiser.Serialize(collectionWrapper);
Reference :
https://stackoverflow.com/questions/16294963/json-net-serialize-object-with-root-name