{"id":11403,"date":"2017-01-20T00:16:38","date_gmt":"2017-01-19T15:16:38","guid":{"rendered":"http:\/\/agrimo.jp\/wp\/?page_id=11403"},"modified":"2017-01-20T00:41:40","modified_gmt":"2017-01-19T15:41:40","slug":"%e3%82%b5%e3%83%b3%e3%83%97%e3%83%ab%ef%bc%91%ef%bc%94","status":"publish","type":"page","link":"https:\/\/agrimo.jp\/wp\/?page_id=11403","title":{"rendered":"\u30b5\u30f3\u30d7\u30eb\uff11\uff14"},"content":{"rendered":"

JSON\u30c7\u30fc\u30bf\uff08\u6587\u5b57\u5217\uff09\u304b\u3089DataTable\u3092\u4f5c\u6210\u3059\u308bc#\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002<\/p>\n

\uff1cVisual Studio \u5185\u3067\u3084\u308b\u3053\u3068\uff1e<\/p>\n

\u30fb\u53c2\u7167\u306e\u8ffd\u52a0\u3067\u3001Newtonsoft.Json.dll \u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n

\u203bDLL\u5165\u624b\u5143\uff1ahttp:\/\/www.newtonsoft.com\/json<\/a><\/span><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\uff1c\u30b5\u30f3\u30d7\u30eb\u30d7\u30ed\u30b0\u30e9\u30e0\u3000c#\uff1e<\/p>\n

using System;\r\nusing System.Collections.Generic;\r\nusing System.Data;\r\nusing System.Linq;\r\nusing System.Text;\r\nusing System.Threading.Tasks;\r\nusing Newtonsoft.Json;\r\n\r\nnamespace HikariCTI_Sample_014\r\n{\r\n    class Program\r\n    {\r\n        static void Main(string[] args)\r\n        {\r\n            \/\/JSON\u30c7\u30fc\u30bf\r\n            string rcv_jsonData = \"\";\r\n\r\n            \/\/\u5909\u6570rcv_jsonData \u306b\u4e0b\u306e\u3088\u3046\u306aJSON\u30c7\u30fc\u30bf\u3092\u4f55\u3089\u304b\u306e\u65b9\u6cd5\u3067\u8aad\u307f\u8fbc\u3080\r\n            \/\/\r\n            \/\/{\r\n            \/\/    \"\u30c7\u30fc\u30bf\": \r\n\u3000\u3000\u3000\u3000\u3000\u3000  \/\/    [    \r\n            \/\/        {\r\n            \/\/            \"id\": 0,\r\n            \/\/            \"path\": \"C:\\\\Users\\\\marusato\\\\Documents\\\\Hikari Denwa CTI\\\\db_backup\\\\hd_cti.sdf\",\r\n            \/\/            \"cre_date\": \"2017-01-19T23:38:33.9477002\",\r\n            \/\/            \"upd_date\": \"2017-01-20T00:25:35.8546082\",\r\n            \/\/            \"acc_date\": \"2017-01-19T23:38:33.9477002\",\r\n            \/\/            \"length\": 282624\r\n            \/\/        },\r\n            \/\/        {\r\n            \/\/            \"id\": 1,\r\n            \/\/            \"path\": \"C:\\\\Users\\\\marusato\\\\Documents\\\\Hikari Denwa CTI\\\\gazoutemp\\\\1_1.jpg\",\r\n            \/\/            \"cre_date\": \"2016-08-27T08:51:57.4827828\",\r\n            \/\/            \"upd_date\": \"2016-08-27T13:13:24.8515149\",\r\n            \/\/            \"acc_date\": \"2016-08-27T08:51:57.4827828\",\r\n            \/\/            \"length\": 64492\r\n            \/\/        }\r\n            \/\/    ]\r\n            \/\/}\r\n\r\n            string message = \"\";\r\n\r\n            \/\/JSON\u30c7\u30fc\u30bf\u3092DataTable\u306b\u5909\u63db\u3059\u308b\r\n            DataTable dt = JSON_to_DataTable(rcv_jsonData);\r\n            if (dt.Rows.Count > 0)\r\n            {\r\n                message = \"\u30c7\u30fc\u30bf\u500b\u6570\uff1a\" + dt.Rows.Count;\r\n            }\r\n            else\r\n            {\r\n                message = \"\u30c7\u30fc\u30bf\u7121\u3057\";\r\n            }\r\n\r\n            Console.WriteLine(message);\r\n\r\n            Console.ReadLine();\r\n        }\r\n\r\n        \/\/JSON\u30c7\u30fc\u30bf\u3092DataTable\u306b\u5909\u63db\u3059\u308b\r\n        static DataTable JSON_to_DataTable(string text)\r\n        {\r\n            DataTable dt = null;\r\n\r\n            try\r\n            {\r\n                DataSet dataSet = JsonConvert.DeserializeObject<DataSet>(text);\r\n                dt = dataSet.Tables[\"\u30c7\u30fc\u30bf\"];\r\n            }\r\n            catch\r\n            {\r\n                dt = new DataTable(\"\u30c7\u30fc\u30bf\");   \/\/\u7a7a\u306e\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\r\n            }\r\n\r\n            return dt;\r\n        }\r\n    }\r\n}<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
JSON\u30c7\u30fc\u30bf\uff08\u6587\u5b57\u5217\uff09\u304b\u3089DataTable\u3092\u4f5c\u6210\u3059\u308bc#\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002 \uff1cVisual Studio \u5185\u3067 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-11403","page","type-page","status-publish","hentry"],"wppr_data":[],"_links":{"self":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/11403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11403"}],"version-history":[{"count":5,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/11403\/revisions"}],"predecessor-version":[{"id":11410,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/11403\/revisions\/11410"}],"wp:attachment":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}