how to read json data using for loop

Question

1.00/5 (1 vote)

See more:

<br />
var arrCust =[{"Table":[ {"UserID":"1","User":"test","Ordering":""}, {"UserID":"6","User":"Moss","Ordering":"Moss"}, {"UserID":"16","User":"B","Ordering":"B"}, {"UserID":"1","User":"H","Ordering":"H"}]}];<br />

how to access User in arrCust ?
iam trying to access User as arrCust.Table.User but am unable to find out User value in json variable please help me..

Posted 26-Apr-15 20:44pm

Member hani

Add a Solution

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)

Karthik_Mahalingam · Answer 1 · 2015-04-26T21:01:00

Solution 1

Try this..

JavaScript

var arrCust = [{ "Table": [{ "UserID": "1", "User": "test", "Ordering": "" }, { "UserID": "6", "User": "Moss", "Ordering": "Moss" }, { "UserID": "16", "User": "B", "Ordering": "B" }, { "UserID": "1", "User": "H", "Ordering": "H" }] }];
            var temp = arrCust[0].Table;
            for (var i = 0; i < temp.length; i++) {
                var user = temp[i].User;
                alert(user);
            }

JavaScript

var arrCust =  [{ "Table": [{ "UserID": "1", "User": "test", "Ordering": "" }, { "UserID": "6", "User": "Moss", "Ordering": "Moss" }, { "UserID": "16", "User": "B", "Ordering": "B" }, { "UserID": "1", "User": "H", "Ordering": "H" }] },
          { "Table1": [{ "azGroup": "1", "User": "test", "Ordering": "" }, { "azGroup": "6", "User": "Moss", "Ordering": "Moss" }, { "azGroup": "16", "User": "B", "Ordering": "B" }, { "azGroup": "1", "User": "H", "Ordering": "H" }] }];
          var temp = arrCust[0].Table;
          for (var i = 0; i < temp.length; i++) {
              var user = temp[i].User;
             // alert(user);
          }
          debugger;
          var temp = arrCust[1].Table1;
          for (var i = 0; i < temp.length; i++) {
              var azGroup = temp[i].azGroup;
              alert(azGroup);
          }

Posted 26-Apr-15 21:01pm

Karthik_Mahalingam

Updated 26-Apr-15 23:17pm

v2

Comments

Member hani 27-Apr-15 5:07am

[{ "Table": [{ "UserID": "1", "User": "test", "Ordering": "" }, { "UserID": "6", "User": "Moss", "Ordering": "Moss" }, { "UserID": "16", "User": "B", "Ordering": "B" }, { "UserID": "1", "User": "H", "Ordering": "H" }] }
{ "Table1": [{ "azGroup": "1", "User": "test", "Ordering": "" }, { "azGroup": "6", "User": "Moss", "Ordering": "Moss" }, { "azGroup": "16", "User": "B", "Ordering": "B" }, { "azGroup": "1", "User": "H", "Ordering": "H" }] }];
this is return from webmethod as json data then how can i access Table.User and Table1.azGroup through for loop as shown above solution..

Karthik_Mahalingam 27-Apr-15 5:17am

check the updated solution

Member hani 27-Apr-15 5:37am

no iam asking that directly loop the json data instead of creating variable arrCust , like data.Table.User and data.Table1.azGroup . but am getting error by accessing data like that please help me

Karthik_Mahalingam 27-Apr-15 5:48am

you cannot do like that

Member hani 27-Apr-15 6:17am

if i give var arrCust=data;
var temp = arrCust[0].Table;
for (var i = 0; i < temp.length; i++) {
var user = temp[i].User;
}
then also iam getting error..

Karthik_Mahalingam 27-Apr-15 7:18am

try this var ss = JSON.parse(arrCust);

Member hani 27-Apr-15 7:22am

then also iam getting error..

Karthik_Mahalingam 27-Apr-15 7:36am

var arrCust = JSON.parse(data);

Member hani 27-Apr-15 7:47am

getting error...

Karthik_Mahalingam 27-Apr-15 7:48am

what error ?
do u have teamviewer?

Member hani 27-Apr-15 7:54am

no..
error:Invalid character

Karthik_Mahalingam 27-Apr-15 7:57am

else, from c# only you pass the user value

Member hani 28-Apr-15 5:17am

got solution in web method iam using EscapeDataString like:
str.Append(string.Format("\"{0}\":\"{1}\",", ds.Tables[o].Columns[j].ColumnName, Uri.EscapeDataString(ds.Tables[o].Rows[i][j].ToString())));
but am getting un wanted characters like %20,%2,%28 are coming along with user value if any spaces are there then these characters are appending how to avoid those unwanted characters?

Karthik_Mahalingam 28-Apr-15 5:28am

no need to worry about the %20
this is nothing but the html char equivalent to the 'space'
it wont create any problem. in the request.querystring[] you will get the exact url

Member hani 28-Apr-15 8:07am

where we give request.querystring[] ? if i wont give Uri.EscapeDataString in web method then in json data will not execute properly, is there any alternative to Uri.EscapeDataString?

Karthik_Mahalingam 28-Apr-15 8:29am

are you online in GMAIL ?

Member hani 28-Apr-15 8:30am

no...

Karthik_Mahalingam 28-Apr-15 8:44am

i want to see your screen