Category: ASP.NET

23 Jan 2017 10:28

Joined:	05/02/2011
Level:	Silver
Points:	102

Points:	4

How I able to take individual field and take entire data from url which contain json input

I came up with situation where I will give my aspx page to serverside ppl,they append json data to my page.I want to take that json data and insert into table1.Suppose json data contain 10 field,I want to take 5 out of them and insert into table2.

Here is my url.

http://domainname.com/pagename.aspx?{'data':'{"Location": "xxxxxx","Apikey": "xxxxxxxxxxxxx",
"Skill": "xxxxxx","PhoneName": "xxxxxxxxxx","Type": "xxxxxxx","Address":"xxxx","Pincode":"xxxx"
}'}

#768752

23 Jan 2017 13:34

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	3

Hai Pinky,
You need to first get the Json part of the data and kip the other part using Split function. Split the whole string from the '?' to get the second part as the JSON result.
Once you get the Json part, you need to stringify the Json data to get the string key values and then split it with ':'.
By this way, you can get the desired results for all your key with the values.
Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

#768765

24 Jan 2017 11:03

Joined:	05/02/2011
Level:	Silver
Points:	102

Points:	1

Thanks Pawan for ur help.Here I am giving url to client like http://domainname.com/pagename.aspx.On same page it will append json data to it.On same page I want to catch json data.I am not using other page to fetch data.If other page,I will able to do it.But on the same page how to do it.Normally we use querystring to fetch data like
http://domainname.com/pagename.aspx?page=page1&number=3 but data is not key value pair.It is in json format.I will take entire url of current page.If I get entire url string on same page like
http://domainname.com/pagename.aspx?{'data':'{"Location": "xxxxxx","Apikey": "xxxxxxxxxxxxx",
"Skill": "xxxxxx","PhoneName": "xxxxxxxxxx","Type": "xxxxxxx","Address":"xxxx","Pincode":"xxxx"
}'} Then only I am able to split.How will I get that?

How I able to take individual field and take entire data from url which contain json input

About dotnetspider.com

Quick Links

General

Services