dcsimg
Results 1 to 10 of 10

Thread: How to convert Json data to ADO RecordSet?

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Sep 2012
    Posts
    1,847

    How to convert Json data to ADO RecordSet?

    I'm learning jpbro's FastCGI Framework, and now I can get json data from my web database via FastCGI:
    http://www.vbforums.com/showthread.p...FastCGI-Server

    Code:
    {"RecordCount":26,"Fields":[{"Name":"code","Type":"TEXT","PrimaryKey":false,"Nullable":false,"DefaultValue":"NULL"},{"Name":"value1","Type":"INTEGER","PrimaryKey":false,"Nullable":false,"DefaultValue":"NULL"},{"Name":"value2","Type":"INTEGER","PrimaryKey":false,"Nullable":false,"DefaultValue":"NULL"},{"Name":"value3","Type":"REAL","PrimaryKey":false,"Nullable":false,"DefaultValue":"NULL"}],"RowsCols":[["A",90,42,412038147449493],["B",29,79,796712756156921],["C",44,95,721228301525116],["D",48,20,432099103927612],["E",30,95,385743200778961],["F",42,98,226647019386292],["G",93,89,423794209957123],["H",57,14,821462154388428],["I",28,35,939591228961945],["J",19,11,22318971157074],["K",49,31,60527628660202],["L",43,5,291807413101196],["M",0,56,990513384342194],["N",79,82,341699719429016],["O",14,9,833484590053558],["P",82,42,324763298034668],["Q",20,77,597042381763458],["R",97,1,314293742179871],["S",38,69,903768241405487],["T",78,79,258403539657593],["U",7,91,693687498569489],["V",88,46,221721291542053],["W",64,71,198390424251556],["X",60,96,584122180938721],["Y",31,28,7.53095746040344E-02],["Z",6,70,915239691734314]]}
    Now I want to convert the Json data into an ADO Recordset and load it into the FlexGrid. I wonder if there is any way to convert Json data directly to an ADO RecordSet or load Json data directly into FlexGrid?
    Last edited by dreammanor; Feb 22nd, 2018 at 03:04 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width