How to convert coma separate string into json array

Anil Kumar

7y2.4k.NET

Hi i have string like "12,23,45" from database now i have to convert that into json array to send in webapi parameter but when i convert that into array i got result like

i have string like "12,23,54" in my database

my result: ["\"93\",\"94\""]

but i need like : ["93","94"]

Please help

8 Replies

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

Amit Mohanty7y ago
Hey try this.
First I declared a utility class
public class RawJsonActionResult : IHttpActionResult
{
    private readonly string _jsonString;

    public RawJsonActionResult(string jsonString)
    {
        _jsonString = jsonString;
    }

    public Task ExecuteAsync(CancellationToken cancellationToken)
    {
        var content = new StringContent(_jsonString);
        content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
        var response = new HttpResponseMessage(HttpStatusCode.OK) { Content = content };
        return Task.FromResult(response);
    }
}
Then use this class in your controller. Here is a simple example
public IHttpActionResult GetData()
{
    var jsonString = "{\"id\":1,\"name\":\"a small object\" }";
    return new RawJsonActionResult(jsonString);
}
0
Sonu Gupta7y ago
Hi,

This is the solution -

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;
using Newtonsoft.Json; // User the name space
namespace Rextester
{
public class Program
{
public static void Main(string[] args)
{
var ids = "100,200,300".Split(',');
var personsString = JsonConvert.SerializeObject(new { person = ids.Select(x => new { id = x }).ToList() });
Console.WriteLine(personsString);
}
}
}
Output -
{"person":[{"id":"100"},{"id":"200"},{"id":"300"}]}
0
Rajeesh Menoth7y ago
Hi,

Check this example also :

https://stackoverflow.com/questions/4253367/how-to-escape-a-json-string-containing-newline-characters-using-javascript
0
Rajeesh Menoth7y ago
Hi,

I think better to share your code.
0
Anil Kumar7y ago
I have tried all but not getting perfect result..
0
Rajeesh Menoth7y ago
Hi,

Try the following code.
jsonStr.replaceAll("\\\\", "");
Reference :
https://stackoverflow.com/questions/13939925/remove-all-occurrences-of-from-string
0
Amit Mohanty7y ago
Hey if you have data in datatable then convert the datatable data to json string by below coding.
public static object DataTableToJSON(DataTable table)
{
    var list = new Liststring, object>>();
    foreach (DataRow row in table.Rows)
    {
        var dict = new Dictionary<string, object>();
        foreach (DataColumn col in table.Columns)
        {
            dict[col.ColumnName] = (Convert.ToString(row[col]));
        }
        list.Add(dict);
    }
    JavaScriptSerializer serializer = new JavaScriptSerializer
    {
        MaxJsonLength = Int32.MaxValue
    };
    return serializer.Serialize(list);
}
0
Asma Khalid7y ago
To serialize data in C# use
JsonConvert.SerializeObject(yourObj)
To serialize data in Jquery use
JSON.stringify(yourObj)
To deserialize data in C# use
JsonConvert.DeserializeObject(yourObj)
To deserialize data in Jquery use
JSON.parse(yourObj)
Mark answer as accept if helpful.

Thanks & Regards,

For more visit: www.asmak9.com
0