ComboBox Request Failure occur after store reload Status Code: 200, Status Text: OK

  1. #1

    ComboBox Request Failure occur after store reload Status Code: 200, Status Text: OK

    Hi, experts, me again. Sorry for bother you so much. My company is considering build a new project with EXT .NET.
    I need to prepare a demo to them and so I have many problem to ask these days.

    One of my combobox pop up a "Request Failure" window after the store reload.

    The message is Status Code: 200, Status Text: OK and following by the data that should be returned.

    The rare thing is when I input more text in the combobox and the return data is less, the "Request Failure" window did not appear.

    Is it my return records too long?

    The .ashx is responsed as Jason. I quite sure the Jason string have no problem, as I have another combobox have no such problem.
    Even in this combobox problem did not occur if fewer records are returned.

    I use following code to write the response. Actually I have try different method to write, but still not work.
                HttpContext.Current.Response.Write(s);
                //HttpContext.Current.Response.End();
                HttpContext.Current.Response.Flush();
                //HttpContext.Current.Response.Close();
                HttpContext.Current.ApplicationInstance.CompleteRequest();
  2. #2
    Hi @Vinci,

    It is not a problem that you are asking us. Thank you for your activity on the forums.

    Regarding the problem.

    Could you provide a test case to reproduce?
  3. #3
    Quote Originally Posted by Daniil View Post
    Hi @Vinci,

    It is not a problem that you are asking us. Thank you for your activity on the forums.

    Regarding the problem.

    Could you provide a test case to reproduce?
    Thank you for your kindly help.

    It is difficult to provide a complete program, as the function is separated into different module...
    I will show the major parts, please tell me it is enough or not.

    This is the function to convert dataset to jason
    public static string DataSetToJson(DataSet ds)
            {
                JsonHelper jsonHelp = new JsonHelper();
                jsonHelp.success = true;
                Dictionary<string, string> colNames = new Dictionary<string, string>();
                var cols = ds.Tables[0].Columns;
                for (int i = 0; i < cols.Count; i++)
                    if (colNames.ContainsKey(cols[i].Caption))
                        throw new Exception("Duplicate caption (" + cols[i].Caption + ") in DataTable when using the method DataSetToJson!");
                    else
                        colNames.Add(cols[i].Caption, cols[i].Caption);
                const string keyword = "_id";
                if (colNames.ContainsKey(keyword))
                    throw new Exception("Duplicate caption (" + keyword + ") in DataTable when using the method DataSetToJson!");
                int n = 0;
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    jsonHelp.AddItem(keyword, n.ToString());
                    n++;
                    foreach (var c in colNames)
                    {
                        jsonHelp.AddItem(c.Value, dr[c.Key].ToString());
                    }
                    jsonHelp.ItemOk();
                }
                jsonHelp.totlalCount = ds.Tables[0].Rows.Count;
                string str = jsonHelp.ToString();
                return str;
            }
    
     public override string ToString()
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("{");
                sb.Append("totalCount:" + totlalCount.ToString() + ",");
                sb.Append("success:" + _success.ToString().ToLower() + ",");
                sb.Append("error:\"" + _error.Replace("\"", "\\\"") + "\",");
                sb.Append("singleInfo:\"" + singleInfo.Replace("\"", "\\\"") + "\",");
                sb.Append("data:[");
    
                int index = 0;
                sb.Append("{");
                if (arrData.Count <= 0)
                {
                    sb.Append("}]");
                }
                else
                {
                    foreach (string val in arrData)
                    {
                        index++;
    
                        if (val != "<BR>")
                        {
                            sb.Append(val + ",");
                        }
                        else
                        {
                            sb = sb.Replace(",", "", sb.Length - 1, 1);
                            sb.Append("},");
                            if (index < arrData.Count)
                            {
                                sb.Append("{");
                            }
                        }
    
                    }
                    sb = sb.Replace(",", "", sb.Length - 1, 1);
                    sb.Append("]");
                }
    
                sb.Append("}");
                return sb.ToString();
            }
    The proxy is defined as
            public static AjaxProxy GetProxy(string url)
            {
                AjaxProxy proxy = new AjaxProxy
                {
                    Url = url                  
                };
     
                proxy.ActionMethods.Read = HttpMethod.GET;
     
    
                JsonReader reader = new JsonReader
                {
                    Root = "data",
                    TotalProperty = "totalCount"
                };
    
                proxy.Reader.Add(reader);
                
                return proxy;
            }
    Here is the return jason that cause problem
    "{totalCount:94,success:true,error:\"\",singleInfo:\"\",data:[{\"_id\":\"0\",\"ITMITMNO\":\"*All\",\"ITMNAM\":\"\",\"SYCDESC\":\"\",\"ITMTYPE\":\"\",\"ITMSTATUS\":\"\",\"ITMSTPFLG\":\"\"},{\"_id\":\"1\",\"ITMITMNO\":\"00000001\",\"ITMNAM\":\"ITEM NAME FOR TESTING----------------------------X\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"2\",\"ITMITMNO\":\"00000013\",\"ITMNAM\":\"Huchison by Lot\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"3\",\"ITMITMNO\":\"00000019\",\"ITMNAM\":\"Swire A by Lot\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"4\",\"ITMITMNO\":\"00000653\",\"ITMNAM\":\"B'jour\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"5\",\"ITMITMNO\":\"00000729\",\"ITMNAM\":\"Sky Thunder\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"6\",\"ITMITMNO\":\"00001398\",\"ITMNAM\"
    :\"ICBC\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"7\",\"ITMITMNO\":\"60020003\",\"ITMNAM\":\"IBM 160GB 7,200 rpm SATA HDD (39M4504)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"8\",\"ITMITMNO\":\"60020004\",\"ITMNAM\":\"IBM 160GB 7,200 rpm SATA HDD (09N4254)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"9\",\"ITMITMNO\":\"60020005\",\"ITMNAM\":\"IBM 160GB 7,200 rpm Hot Swap SATA HDD (39M4522)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"10\",\"ITMITMNO\":\"60020006\",\"ITMNAM\":\"IBM 160GB 7,200 rpm SATA-150 HDD (73P8003)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"11\",\"ITMITMNO\":\"60030001\",\"ITMNAM\":\"IBM 250GB 7,200rpm SATA HDD (39M4526-01)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"12\",\"ITMITMNO\":\"600400
    01\",\"ITMNAM\":\"IBM 250GB 7,200rpm SATA HDD (39M4526)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"13\",\"ITMITMNO\":\"60120011\",\"ITMNAM\":\"DB500 KEYMAT ASSY\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"14\",\"ITMITMNO\":\"60120013\",\"ITMNAM\":\"DB500 WINDOW ASSY\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"15\",\"ITMITMNO\":\"60120014\",\"ITMNAM\":\"DB500 B COVER ASSY (GREY)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"16\",\"ITMITMNO\":\"60140001\",\"ITMNAM\":\"DB500 VOLUME SWITCH\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"17\",\"ITMITMNO\":\"60170003\",\"ITMNAM\":\"E0064BA/EPDM RUBBER\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"18\",\"ITMITMNO\":\"60170005\",\"ITMNAM\":\"M800\",\"SYCDESC\":\"Model\",\"ITMTYPE\
    ":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"19\",\"ITMITMNO\":\"60170011\",\"ITMNAM\":\"E0050G-2A\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"20\",\"ITMITMNO\":\"60230007\",\"ITMNAM\":\"CHIP RESISTOR (MCR18EZPF1000)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"21\",\"ITMITMNO\":\"60230014\",\"ITMNAM\":\"Seagate 160GB 2.5\" 5,400rpm IDE HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"22\",\"ITMITMNO\":\"60230016\",\"ITMNAM\":\"Seagate 160GB 2.5\" 5,400rpm SATA HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"23\",\"ITMITMNO\":\"60240001\",\"ITMNAM\":\"Seagate 160GB 3.5\" 7,200rpm IDE HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"24\",\"ITMITMNO\":\"60240002\",\"ITMNAM\":\"Seagate 160GB 3.5\" 7,200rpm SATA HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\"
    ,\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"25\",\"ITMITMNO\":\"60240006\",\"ITMNAM\":\"Seagate 40GB 7,200rpm IDE HDD (ST340014A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"26\",\"ITMITMNO\":\"60240012\",\"ITMNAM\":\"Seagate 80GB 2.5\" 5,400rpm IDE HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"27\",\"ITMITMNO\":\"60240013\",\"ITMNAM\":\"Seagate 80GB 7,200rpm IDE HDD (ST380011A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"28\",\"ITMITMNO\":\"60240014\",\"ITMNAM\":\"Seagate 80GB 7,200rpm IDE HDD (ST380215A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"29\",\"ITMITMNO\":\"60240015\",\"ITMNAM\":\"Seagate 80GB 7,200rpm SATA HDD (ST380815AS)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"30\",\"ITMITMNO\":\"60240016\",\"ITMNAM\":\"Toshiba 80GB 5,400rpm IDE HDD\",
    \"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"31\",\"ITMITMNO\":\"60240017\",\"ITMNAM\":\"Western Digital 40GB 7,200rpm IDE HDD (WD400)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"32\",\"ITMITMNO\":\"60260001\",\"ITMNAM\":\"Western Digital 80GB 7,200rpm IDE HDD (800BB)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"33\",\"ITMITMNO\":\"60260003\",\"ITMNAM\":\"Casio Laser Hand Held Terminal (DT900M60E)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"34\",\"ITMITMNO\":\"74806001\",\"ITMNAM\":\"プリント基板001\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"35\",\"ITMITMNO\":\"90010002\",\"ITMNAM\":\"CF0036001 WATER PROOF PACKING TOOLING\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"36\",\"ITMITMNO\":\"90100020\",\"ITMNAM\":\"Lenovo ThinkVisi
    on L1900p 19\" LCD Monitor\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"37\",\"ITMITMNO\":\"90100024\",\"ITMNAM\":\"3Com Fast Ethernet 10/100 PCI Card (3C905CX-TX-NM)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"38\",\"ITMITMNO\":\"90100030\",\"ITMNAM\":\"3Com 10/100 PCMCIA Card\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"39\",\"ITMITMNO\":\"90170002\",\"ITMNAM\":\"HP Laserjet 1200 Printer (HP-C7044A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"40\",\"ITMITMNO\":\"90170003\",\"ITMNAM\":\"HP Laserjet 1300 Printer (HP-Q1334A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"41\",\"ITMITMNO\":\"90170004\",\"ITMNAM\":\"HP Laserjet 1300N Printer (HP-Q1335A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"42\",\"ITMITMNO\":\"9017000
    7\",\"ITMNAM\":\"HP Laserjet 2200DN Printer (HP-C7063A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"43\",\"ITMITMNO\":\"90170008\",\"ITMNAM\":\"HP Laserjet 2300 Printer (HP-Q2472A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"44\",\"ITMITMNO\":\"90170009\",\"ITMNAM\":\"HP Laserjet 2300D Printer (HP-Q2474A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"45\",\"ITMITMNO\":\"90170010\",\"ITMNAM\":\"HP Laserjet 2300DN Printer (HP-Q2475A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"46\",\"ITMITMNO\":\"90170011\",\"ITMNAM\":\"HP Laserjet 2300DTN Printer (HP-Q2476A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"47\",\"ITMITMNO\":\"90170012\",\"ITMNAM\":\"HP Laserjet 2300N Printer (HP-Q2473A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_
    id\":\"48\",\"ITMITMNO\":\"90170016\",\"ITMNAM\":\"HP Color Laserjet 2500 Printer (HP-C9706A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"49\",\"ITMITMNO\":\"90170017\",\"ITMNAM\":\"HP Color Laserjet 2600N Printer (HP-Q6455A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"50\",\"ITMITMNO\":\"90170022\",\"ITMNAM\":\"HP Color Laserjet 3500N Printer (HP-1320A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"51\",\"ITMITMNO\":\"90170023\",\"ITMNAM\":\"HP Color Laserjet 3600N Printer (HP-Q5987A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"52\",\"ITMITMNO\":\"90170024\",\"ITMNAM\":\"HP Color Laserjet 3800N Printer (HP-Q5982A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"53\",\"ITMITMNO\":\"90170025\",\"ITMNAM\":\"HP Laserjet 4200 Printer (HP-Q2425A)\",\"SYCDESC\":\"Model\",\"ITM
    TYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"54\",\"ITMITMNO\":\"90170026\",\"ITMNAM\":\"HP Laserjet 4200DTN Printer (HP-Q2428A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"55\",\"ITMITMNO\":\"90170027\",\"ITMNAM\":\"HP Laserjet 4200N Printer (HP-Q2426A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"56\",\"ITMITMNO\":\"90230001\",\"ITMNAM\":\"HP Laserjet 4200TN Printer (HP-Q2427A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"57\",\"ITMITMNO\":\"90230002\",\"ITMNAM\":\"HP Laserjet 4250 Printer (HP-Q5400A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"58\",\"ITMITMNO\":\"90230006\",\"ITMNAM\":\"HP Laserjet 4300 Printer (HP-Q2431A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"59\",\"ITMITMNO\":\"90230007\",\"ITMNAM\":\"HP Laserjet 4300DTN Printer (HP-Q24
    34A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"60\",\"ITMITMNO\":\"90230008\",\"ITMNAM\":\"HP Laserjet 4300N Printer (HP-Q2432A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"61\",\"ITMITMNO\":\"90230009\",\"ITMNAM\":\"HP Laserjet 4300TN Printer (HP-Q2433A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"62\",\"ITMITMNO\":\"90230013\",\"ITMNAM\":\"HP Color Laserjet 4600 Printer(HP-C9660A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"63\",\"ITMITMNO\":\"90230014\",\"ITMNAM\":\"HP Color Laserjet 4600DN Printer (HP-C9661A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"64\",\"ITMITMNO\":\"90230015\",\"ITMNAM\":\"HP Laserjet 5100 Printer (HP-Q1860A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"65\",\"ITMITMNO\":\"90240001\",\"IT
    MNAM\":\"HP Laserjet 5100TN Printer (HP-Q1861A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"66\",\"ITMITMNO\":\"90240002\",\"ITMNAM\":\"HP Laserjet 5200 Printer (HP-Q7543A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"67\",\"ITMITMNO\":\"90240003\",\"ITMNAM\":\"HP Laserjet 5200N Printer (HP-Q7544A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"68\",\"ITMITMNO\":\"90240004\",\"ITMNAM\":\"HP Laserjet 5200TN Printer (HP-Q7545A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"69\",\"ITMITMNO\":\"90240005\",\"ITMNAM\":\"HP Color Laserjet 5500 Printer (HP-C9656A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"70\",\"ITMITMNO\":\"90240019\",\"ITMNAM\":\"HP Laserjet P3005 Printer (HP-Q7812A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":
    \"71\",\"ITMITMNO\":\"90240020\",\"ITMNAM\":\"HP Laserjet P3005D Printer (HP-Q7813A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"72\",\"ITMITMNO\":\"90240021\",\"ITMNAM\":\"HP Laserjet P3005DN Printer (HP-Q7815A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"73\",\"ITMITMNO\":\"90240042\",\"ITMNAM\":\"GOMUBANE 1 903-A00020\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"Y\"},{\"_id\":\"74\",\"ITMITMNO\":\"90240043\",\"ITMNAM\":\"GOMUBANE 2 (903-A00030)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"75\",\"ITMITMNO\":\"90240044\",\"ITMNAM\":\"SPRING GOMU 268-A00040\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"76\",\"ITMITMNO\":\"90240049\",\"ITMNAM\":\"903-A00070 & 71 MOLD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"77\",\"ITMITMNO\":\"902400
    58\",\"ITMNAM\":\"GOMUBANE 903-A00070 (40p)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"78\",\"ITMITMNO\":\"90240063\",\"ITMNAM\":\"512MB PC2100 ECC DDR SDRAM (10K0069)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"79\",\"ITMITMNO\":\"90240076\",\"ITMNAM\":\"1X512MB RAM for IBM X3200 (41Y2726)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"80\",\"ITMITMNO\":\"90240077\",\"ITMNAM\":\"2X512MB RAM for IBM X3400 (39M5782)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"81\",\"ITMITMNO\":\"90240078\",\"ITMNAM\":\"2X1GB Chipkill RAM for X3400 (39M5785)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"82\",\"ITMITMNO\":\"90240079\",\"ITMNAM\":\"2X1GB Chipkill RAM for IBM X3400 (46C7418)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"83\",\
    "ITMITMNO\":\"90240080\",\"ITMNAM\":\"1 X 2GB DDR3 SDRAM (2R x8) for X3400M2 (44T1481)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"84\",\"ITMITMNO\":\"90240083\",\"ITMNAM\":\"256MB RAM for NEC 5800/110Ed2 (RMC133/256)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"85\",\"ITMITMNO\":\"90240084\",\"ITMNAM\":\"128MB RAM for NEC 5800/110Ee (KVR133X72RC3/128)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"86\",\"ITMITMNO\":\"90240085\",\"ITMNAM\":\"256MB RAM for NEC 5800/110Ee (KVR133X72RC3/256)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"87\",\"ITMITMNO\":\"90240086\",\"ITMNAM\":\"512MB RAM for NEC 5800/110Ee (KVR133X72RC3/512)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"88\",\"ITMITMNO\":\"90240087\",\"ITMNAM\":\"128MB RAM for NEC 5800/110Eg (D1664B250)\",\"SYCDESC\":\"Mode
    l\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"89\",\"ITMITMNO\":\"90310001\",\"ITMNAM\":\"256MB RAM for NEC 5800/51La (FIFO)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"90\",\"ITMITMNO\":\"90330001\",\"ITMNAM\":\"512MB 400MHz DDR RAM (KVR400X64C3A/512)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"O\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"91\",\"ITMITMNO\":\"CD-SC-221\",\"ITMNAM\":\"RL OF 10,000 PCS\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"92\",\"ITMITMNO\":\"N1000-GE-FE1108-U\",\"ITMNAM\":\"N1000 GE FE1108\",\"SYCDESC\":\"Parts\",\"ITMTYPE\":\"P\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"93\",\"ITMITMNO\":\"SM0120L100\",\"ITMNAM\":\"SM 1.2\" 100M\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"}]}"
    And this have no problem
    "{totalCount:15,success:true,error:\"\",singleInfo:\"\",data:[{\"_id\":\"0\",\"ITMITMNO\":\"*All\",\"ITMNAM\":\"\",\"SYCDESC\":\"\",\"ITMTYPE\":\"\",\"ITMSTATUS\":\"\",\"ITMSTPFLG\":\"\"},{\"_id\":\"1\",\"ITMITMNO\":\"00000001\",\"ITMNAM\":\"ITEM NAME FOR TESTING----------------------------X\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"2\",\"ITMITMNO\":\"00000013\",\"ITMNAM\":\"Huchison by Lot\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"3\",\"ITMITMNO\":\"00000019\",\"ITMNAM\":\"Swire A by Lot\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"4\",\"ITMITMNO\":\"00000653\",\"ITMNAM\":\"B'jour\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"5\",\"ITMITMNO\":\"00000729\",\"ITMNAM\":\"Sky Thunder\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"6\",\"ITMITMNO\":\"00001398\",\"ITMNAM\"
    :\"ICBC\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"7\",\"ITMITMNO\":\"60230007\",\"ITMNAM\":\"CHIP RESISTOR (MCR18EZPF1000)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"8\",\"ITMITMNO\":\"90240042\",\"ITMNAM\":\"GOMUBANE 1 903-A00020\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"Y\"},{\"_id\":\"9\",\"ITMITMNO\":\"90240043\",\"ITMNAM\":\"GOMUBANE 2 (903-A00030)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"10\",\"ITMITMNO\":\"90240044\",\"ITMNAM\":\"SPRING GOMU 268-A00040\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"11\",\"ITMITMNO\":\"90240049\",\"ITMNAM\":\"903-A00070 & 71 MOLD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"12\",\"ITMITMNO\":\"90240058\",\"ITMNAM\":\"GOMUBANE 903-A00070 (40p)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"IT
    MSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"13\",\"ITMITMNO\":\"CD-SC-221\",\"ITMNAM\":\"RL OF 10,000 PCS\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"14\",\"ITMITMNO\":\"N1000-GE-FE1108-U\",\"ITMNAM\":\"N1000 GE FE1108\",\"SYCDESC\":\"Parts\",\"ITMTYPE\":\"P\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"}]}"
  4. #4
    I guess a JSON can be invalid.

    Please try to serialize a DataTable with:
    JSON.Serialize(dataTable);
  5. #5
    Quote Originally Posted by Daniil View Post
    I guess a JSON can be invalid.

    Please try to serialize a DataTable with:
    JSON.Serialize(dataTable);
    Thanks.
    I directly return JSON.Serialize(dataTable); and change the JSON reader root ="COMMON" and it works now.

    But the root return by JSON.Serialize(dataTable) is default "COMMON" and I cannot add totalConut in this case.

    I have tried this demo.

    It returns
    context.Response.Write(string.Format("{{total:{1},'plants':{0}}}", JSON.Serialize(plants.Data), plants.TotalRecords));
    In this demo, the plants.Data used in JSON.Serialize() is a List and the result JSON string don't have the default root "COMMON". How can I do the same thing with datatable?

    Do I need to use IContractResolver to achieve this? Any sample for using IContractResolver?

    And what is the purpose for totalConut? If I just ignore it, will it has any problems?
  6. #6
    Quote Originally Posted by Vinci View Post
    And what is the purpose for totalConut? If I just ignore it, will it has any problems?
    It is required to get pagination working.

    Quote Originally Posted by Vinci View Post
    In this demo, the plants.Data used in JSON.Serialize() is a List and the result JSON string don't have the default root "COMMON". How can I do the same thing with datatable?
    Probably, you replace
    'plants':{0}
    with
    'COMMON':{0}
    or, otherwise, change a Reader's Root.

Similar Threads

  1. [CLOSED] Request Failure Error Status Code 200
    By bayoglu in forum 2.x Legacy Premium Help
    Replies: 9
    Last Post: Nov 26, 2013, 8:37 PM
  2. Replies: 0
    Last Post: Aug 09, 2012, 1:27 PM
  3. Replies: 4
    Last Post: Feb 09, 2012, 6:06 AM
  4. Replies: 16
    Last Post: Oct 04, 2011, 5:17 PM
  5. status text status code CUSTOM
    By threewonders in forum 1.x Help
    Replies: 0
    Last Post: Sep 26, 2011, 1:29 PM

Tags for this Thread

Posting Permissions