Not able to access JSON datas

Question

I am trying to loop through the JSON object and create an input type dynamically in a div

here is the Jquery function

$(document).ready(function (){
     $.ajax({
     type: "POST",
     url: "Tables.aspx/TotaTable", 
     contentType: "application/json; charset=utf-8",
     dataType:'JSON',        
     success: function(data) { 
     //var data= $.parseJSON(data);
     $.each(data,function(index,jsonobj)
          {
             alert(jsonobj.OTID);
          }
          );
         }

    });

});

Here is the server side code that return the JSON values I am using json.net framework to convert my datatable to JSON

[System.Web.Services.WebMethod(EnableSession=true)]
   public static string TotaTable()
   {
       LoginData lData = (LoginData)HttpContext.Current.Session["LData"];
       ClsDataAccess cData = new ClsDataAccess();
       DataTable dt = cData.GetTable("Select otid,ottableno from      FBOUTLETTABLES where otoutletid=1");
       string val=JsonConvert.SerializeObject(dt).ToString();
       return val;
   }

here is the JSON value that is sent to the client side

[{"OTID":76.0,"OTTABLENO":222.0},{"OTID":3.0,"OTTABLENO":3.0},{"OTID":4.0,"OTTABLENO":4.0},{"OTID":5.0,"OTTABLENO":5.0},{"OTID":6.0,"OTTABLENO":6.0},{"OTID":7.0,"OTTABLENO":7.0},{"OTID":8.0,"OTTABLENO":8.0},{"OTID":9.0,"OTTABLENO":9.0},{"OTID":2.0,"OTTABLENO":2.0},{"OTID":1.0,"OTTABLENO":1.0}]

My problem is alert(jsonobj.OTID); shows 'undefined'

I did try changing the server side function to return a List

like

public static List<Tables> Tables()
{
 List<Tables> myList=new List<Tables>();
 //Code to get datas from the database
 foreach(DataRow row in dt.Rows)
 {
   myList.Add(new Tables{
   tabID=row["tabID"].ToString();
   tables=row["tab"].ToString();
   });
 }
 return myList;
 }

but I am facing the same issue..

You are passing an _array_ of values back, but then trying to access the value of the first element directly. — stuartd, Jun 29 '16 at 11:06
try developer console (normally by pressing F12) from your browser. you can put a breakpoint into your code and see what jsonobj actually ... might get a hint what is wrong — vidriduch, Jun 29 '16 at 11:09
Thanks for you reply,, but the solution still returns undefined!!! — Ben john, Jun 29 '16 at 11:10
Possible duplicate of [How to return JSON with ASP.NET & jQuery](http://stackoverflow.com/questions/18244696/how-to-return-json-with-asp-net-jquery) — fahadash, Jun 29 '16 at 11:11
i did a console.log(jsonobj) and did check the browser console. It showed the following [{"OTID":76.0,"OTTABLENO":222.0},{"OTID":3.0,"OTTABLENO":3.0},{"OTID":4.0,"OTTABLENO":4.0},{"OTID":5.0,"OTTABLENO":5.0},{"OTID":6.0,"OTTABLENO":6.0},{"OTID":7.0,"OTTABLENO":7.0},{"OTID":8.0,"OTTABLENO":8.0},{"OTID":9.0,"OTTABLENO":9.0},{"OTID":2.0,"OTTABLENO":2.0},{"OTID":1.0,"OTTABLENO":1.0}] — Ben john, Jun 29 '16 at 11:12
Two things you need to look at : The first was mentioned by @stuartd, you are dealing with arrays and therefore need to access an element in the array - jsonobj[0].OTID; The second thing to check is the actual type of the JSON - You might need to parse the response first using JSON.parse(response); — donners45, Jun 29 '16 at 11:20
Trying to parse threw an error in the developer console Uncaught SyntaxError: Unexpected token o in JSON at position 1 — Ben john, Jun 29 '16 at 11:28
That probably means your data is already an Object rather than a string, this is fine - you can leave the parse step out and access the objects within the array. — donners45, Jun 29 '16 at 11:33

score 0 · Accepted Answer · answered Jun 30 '16 at 13:17

Finally Got It working

Here is the Jquery Code

var obj={};
obj.ID=id;   
 $.ajax({
    type:"POST",
    url:"Tables.aspx/ItemsFromCategory",
    data: JSON.stringify(obj),
    contentType: "application/json; charset=utf-8",
    dataType:'json'    

      }).done(function(res) {  

     var resultAsJson = res.d;
 $.each(resultAsJson, function (index, resObject) {
 alert(resObject.ID);  
});
}
});

I did also change the server side code to this

   public static List<ItemClass> ItemsFromCategory(string ID)
   {
       LoginData lData = (LoginData)HttpContext.Current.Session["LData"];

       System.Web.Script.Serialization.JavaScriptSerializer ser = new System.Web.Script.Serialization.JavaScriptSerializer();
       List<ItemClass> myList = new List<ItemClass>();

      if (lData != null)
       {
           ClsDataAccess cData = new ClsDataAccess();
           DataTable dt = cData.GetTable("Select itmid,ITMNAME from FBITEMDETAILS where itmtype='I' and itmisprimary='N' and itmoutletid=" + lData.fbOutLetid + " and itmgrpid=" + ID);
          // DataTable dt = cData.GetTable("Select itmid,ITMNAME from FBITEMDETAILS where itmtype='I' and itmisprimary='N' and itmgrpid=" + ID);
           foreach (DataRow row in dt.Rows)
           {
               myList.Add(new ItemClass
               {
                   ID = row["itmid"].ToString(),
                   itemName=row["ITMNAME"].ToString(),

               });

           }
          // result = ser.Serialize(myList);
       //    return result;
           return myList;
       }
      // return string.Empty;
       return myList;


   }

Not able to access JSON datas

1 Answers1