this line is giving error itemkey and itemvalue34TB7934345053434TB3934345053434TB3534345053434TB3634345053434TB3734345053434TB3834345053434TB3234345053434TB3134345053434TB3434345053434TB7034345053434TB33343450534this is sample data and i am unable to conver this data to xml formatjson wcDownloadStringSGDataUrlSystemCollectionsGen

HiYou can simply use JObjectParse to get the Key ValueRefer the below exampleCprotected void PageLoadobject sender EventArgs e string json FileReadAllTextServerMapPath34Jsontxt34 var user JObjectParsejsonReplace3434 3434Replace3434 3434Trim foreach var kv in user string key kvKey string value kvValueToStringReplace343434 3434 Your insert code

Retrieve Key Value from JSON in ASP.Net

iammann

SOLVED CLOSED ACTIVE ANSWERED
User: iammann
Posted: on Jun 26, 2018 11:51 PM
Forum: ASP.Net Web Forms
Answer: 1
Views: 1693
Sample Code: Download

this line is giving error. item.key and item.value

[{"TB79":"505","TB39":"505","TB35":"505","TB36":"505","TB37":"505","TB38":"505","TB32":"505","TB31":"505","TB34":"505","TB70":"505","TB33":"505"}]

this is sample data and i am unable to conver this data to xml format.

json = wc.DownloadString(SGDataUrl);
System.Collections.Generic.List<sgData> user = Newtonsoft.Json.JsonConvert.DeserializeObject<System.Collections.Generic.List<sgData>>(json);
foreach (var item in user)
{
    cmd.Parameters.AddWithValue("@TimeBlock", item.key);
    cmd.Parameters.AddWithValue("@SGData", item.Value);
}

public class sgData
{
    public string TimeBlock { get; set; }
    public decimal SGData { get; set; }
}

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 5

Reply
ANSWER
User: dharmendr
Replied: on Jun 28, 2018 05:07 AM
Report

Hi,

You can simply use JObject.Parse to get the Key Value.

Refer the below example.

protected void Page_Load(object sender, EventArgs e)
{
    string json = File.ReadAllText(Server.MapPath("~/Json.txt"));
    var user = JObject.Parse(json.Replace("[", "").Replace("]", "").Trim());
    foreach (var kv in user)
    {
        string key = kv.Key;
        string value = kv.Value.ToString().Replace("\"", "");
        // Your insert code.
    }
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Retrieve Key Value from JSON in ASP.Net

Company

Explore

Follow us

Contact Us