[vb.net] JSON To DataTable > vb.net

본문 바로가기

vb.net

[Controls] [vb.net] JSON To DataTable

회원사진
하나를하더라도최선을
2021-01-21 10:46 6,169 0

본문



{"Table":[        
    {"link_product_list":"\/category\/\ub514\ud4e8\uc800\/115\/","name":"\ub514\ud4e8\uc800","param":"?cate_no=115","cate_no":115,"parent_cate_no":1,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ud504\ub798\uadf8\ub7f0\uc2a4\uc5d0\uc13c\uc15c\uc624\uc77c\/116\/","name":"\ud504\ub798\uadf8\ub7f0\uc2a4\/\uc5d0\uc13c\uc15c\uc624\uc77c","param":"?cate_no=116","cate_no":116,"parent_cate_no":1,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc12c\uc720\ud5a5\uc218\/163\/","name":"\uc12c\uc720\ud5a5\uc218","param":"?cate_no=163","cate_no":163,"parent_cate_no":1,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/diy\/117\/","name":"DIY","param":"?cate_no=117","cate_no":117,"parent_cate_no":1,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc138\uc77c\/118\/","name":"\uc138\uc77c","param":"?cate_no=118","cate_no":118,"parent_cate_no":1,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc120\ubb3c\uc138\ud2b8\/119\/","name":"\uc120\ubb3c\uc138\ud2b8","param":"?cate_no=119","cate_no":119,"parent_cate_no":1,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ub3c4\ub9e4\/122\/","name":"\ub3c4\ub9e4","param":"?cate_no=122","cate_no":122,"parent_cate_no":1,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ub9c8\uc2a4\ud06c\ub9ac\ub274\/187\/","name":"\ub9c8\uc2a4\ud06c\ub9ac:\ub274","param":"?cate_no=187","cate_no":187,"parent_cate_no":1,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc77c\ubc18\ub514\ud4e8\uc800\/123\/","name":"\uc77c\ubc18\ub514\ud4e8\uc800","param":"?cate_no=123","cate_no":123,"parent_cate_no":115,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ud50c\ub77c\uc6cc\ub514\ud4e8\uc800\/125\/","name":"\ud50c\ub77c\uc6cc\ub514\ud4e8\uc800","param":"?cate_no=125","cate_no":125,"parent_cate_no":115,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc2dc\uc98c\ub514\ud4e8\uc800\/126\/","name":"\uc2dc\uc98c\ub514\ud4e8\uc800","param":"?cate_no=126","cate_no":126,"parent_cate_no":115,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ud504\ub9ac\ubbf8\uc5c4-\uc601\uad6d\ud5a5\/127\/","name":"\ud504\ub9ac\ubbf8\uc5c4 \uc601\uad6d\ud5a5","param":"?cate_no=127","cate_no":127,"parent_cate_no":116,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc5d0\uc158\uc15c\uc624\uc77c\/128\/","name":"\uc5d0\uc158\uc15c\uc624\uc77c","param":"?cate_no=128","cate_no":128,"parent_cate_no":116,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ub514\ud4e8\uc800\uc12c\uc720\ud5a5\uc218-\ub9ac\ud544\uc561\/140\/","name":"\ub514\ud4e8\uc800\/\uc12c\uc720\ud5a5\uc218 \ub9ac\ud544\uc561","param":"?cate_no=140","cate_no":140,"parent_cate_no":117,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc2a4\ud2f1\/141\/","name":"\uc2a4\ud2f1","param":"?cate_no=141","cate_no":141,"parent_cate_no":117,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ud50c\ub77c\uc6cc\uc7a5\uc2dd\/179\/","name":"\ud50c\ub77c\uc6cc\uc7a5\uc2dd","param":"?cate_no=179","cate_no":179,"parent_cate_no":117,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ub2e8\ud488\/145\/","name":"\ub2e8\ud488","param":"?cate_no=145","cate_no":145,"parent_cate_no":122,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ube14\ub799-\uc138\ud2b8\/146\/","name":"\ube14\ub799 \uc138\ud2b8","param":"?cate_no=146","cate_no":146,"parent_cate_no":122,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc2a4\ud398\uc15c-\uc138\ud2b8\/147\/","name":"\uc2a4\ud398\uc15c \uc138\ud2b8","param":"?cate_no=147","cate_no":147,"parent_cate_no":122,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uace0\uae09-\uc138\ud2b8\/148\/","name":"\uace0\uae09 \uc138\ud2b8","param":"?cate_no=148","cate_no":148,"parent_cate_no":122,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\ud504\ub9ac\ubbf8\uc5c4-\uc138\ud2b8\/150\/","name":"\ud504\ub9ac\ubbf8\uc5c4 \uc138\ud2b8","param":"?cate_no=150","cate_no":150,"parent_cate_no":122,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uadf8\ub9b0\ud5c8\ube0c\/129\/","name":"\uadf8\ub9b0&\ud5c8\ube0c","param":"?cate_no=129","cate_no":129,"parent_cate_no":127,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/citrus\/130\/","name":"CITRUS","param":"?cate_no=130","cate_no":130,"parent_cate_no":127,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/woodyspicy\/133\/","name":"WOODY&SPICY","param":"?cate_no=133","cate_no":133,"parent_cate_no":127,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/cotton\/134\/","name":"COTTON","param":"?cate_no=134","cate_no":134,"parent_cate_no":127,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/floral\/136\/","name":"FLORAL","param":"?cate_no=136","cate_no":136,"parent_cate_no":127,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/fruity\/138\/","name":"FRUITY","param":"?cate_no=138","cate_no":138,"parent_cate_no":127,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/etc\/139\/","name":"ETC","param":"?cate_no=139","cate_no":139,"parent_cate_no":127,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc12c\uc720\uc2a4\ud2f1\/142\/","name":"\uc12c\uc720\uc2a4\ud2f1","param":"?cate_no=142","cate_no":142,"parent_cate_no":141,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uc1fc\ud551\ubc31\/144\/","name":"\uc1fc\ud551\ubc31","param":"?cate_no=144","cate_no":144,"parent_cate_no":235,"design_page_url":"product\/list.html","like_count":0},        
    {"link_product_list":"\/category\/\uacf5\ubcd1\/143\/","name":"\uacf5\ubcd1","param":"?cate_no=143","cate_no":143,"parent_cate_no":235,"design_page_url":"product\/list.html","like_count":0}
]}
 
 
        T = String.Concat("{""Table"":", T, "}")
        Dim D As DataTable = JsonConvert.DeserializeObject(Of RootObject(Of DataTable))(T).Table
        DataGridView4.DataSource = D
 
    Public Class RootObject(Of T)
        Public Property Table As T
    End Class

댓글목록0

등록된 댓글이 없습니다.
게시판 전체검색