{"id":1120,"date":"2009-04-23T17:27:46","date_gmt":"2009-04-23T08:27:46","guid":{"rendered":"http:\/\/gigasmegas.com\/?p=1120"},"modified":"2009-04-23T17:27:56","modified_gmt":"2009-04-23T08:27:56","slug":"sql-server-compact-35%e3%81%aesqlcedatareader%e3%82%92%e3%83%aa%e3%83%bc%e3%83%89%e3%81%99%e3%82%8b%e3%81%a8%e7%95%b0%e5%b8%b8%e3%81%ab%e9%81%85%e3%81%84%e2%80%a6","status":"publish","type":"post","link":"http:\/\/gigasmegas.com\/?p=1120","title":{"rendered":"SQL Server Compact 3.5\u306eSqlCeDataReader\u3092\u30ea\u30fc\u30c9\u3059\u308b\u3068\u7570\u5e38\u306b\u9045\u3044\u2026"},"content":{"rendered":"<p><a onclick=\"javascript:pageTracker._trackPageview('\/outgoing\/rokuz.com\/?p=');\"  href=\"http:\/\/rokuz.com\/?p=\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/rokuz.com\/wp-content\/uploads\/2009\/04\/snag-0145-400x228.png\" alt=\"SqlCeDataReader\u3092\u30ea\u30fc\u30c9\u3059\u308b\u3068\u7570\u5e38\u306b\u9045\u3044\" title=\"SqlCeDataReader\u3092\u30ea\u30fc\u30c9\u3059\u308b\u3068\u7570\u5e38\u306b\u9045\u3044\" width=\"400\" height=\"228\" class=\"alignnone size-medium wp-image-1121\" srcset=\"http:\/\/gigasmegas.com\/wp-content\/uploads\/2009\/04\/snag-0145-400x228.png 400w, http:\/\/gigasmegas.com\/wp-content\/uploads\/2009\/04\/snag-0145.png 489w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/a><\/p>\n<address>photo by <a onclick=\"javascript:pageTracker._trackPageview('\/outgoing\/www.flickr.com\/photos\/visbeek\/');\"  href=\"http:\/\/www.flickr.com\/photos\/visbeek\/\">B\u0435n<\/a><\/address>\n<p>SQL Server Compact 3.5\u306eSqlCeDataReader\u3092\u4f7f\u7528\u3057\u3066\u3001\u201dWhile\u201d\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3067\u30eb\u30fc\u30d7\u51e6\u7406\u3092\u884c\u3044\u3001\u30c7\u30fc\u30bf\u3092\u30ea\u30fc\u30c9\u3002<\/p>\n<p>SQL Server 2008 Express\u3067\u306fSqlDataReader\u3092\u4f7f\u7528\u3057\u3066\u3001\u540c\u69d8\u306e\u51e6\u7406\u3092\u884c\u3048\u307e\u3059\u304c\u51e6\u7406\u6642\u9593\u304c\u7570\u5e38\u306b\u9055\u3044\u307e\u3059\u3002<\/p>\n<p>\u306a\u306b\u304b\u3001\u8a2d\u5b9a\u304c\u5fc5\u8981\u306a\u306e\u304b\uff1f\u3068\u3044\u3063\u3066\u3082\u3001SqlCeDataReader\u306b\u306fSeek\u3050\u3089\u3044\u3057\u304b\u898b\u3042\u305f\u3089\u306a\u3044\u3057\u2026\u2026<\/p>\n<p><!--more--><\/p>\n<p>\u9867\u5ba2\u30c7\u30fc\u30bf\u3092\u305f\u3063\u305f800\u4ef6\u3001FlexGrid\u306b\u8868\u793a\u3057\u3066\u3044\u304f\u3068\u3044\u3046\u51e6\u7406\u3092\u884c\u3063\u305f\u306e\u3067\u3059\u304c\u3001<\/p>\n<p>SQL Server 2008 Express\u3067\u306fSqlDataReader\u3067\u3001\u7d040.7\u79d2<\/p>\n<p>SQL Server Compact 3.5\u306eSqlCeDataReader\u3067\u3001\u7d04\uff17\uff5e\uff18\u79d2<\/p>\n<p>10\u500d\u8fd1\u304f\u9055\u3044\u307e\u3059\u2026\u2026<\/p>\n<p>\u305f\u3063\u305f\u306e800\u4ef6\u3067\u3059\u304b\u3089\u30014000\u4ef6\u306b\u306a\u3063\u305f\u3068\u4eee\u5b9a\u3059\u308b\u30685\u500d\u306e\u7d04\uff13\uff15\uff5e40\u79d2\u3063\u3066\u3001\u4f7f\u3048\u306a\u3044\u3088\u3053\u308c\u3058\u3083\uff5e\u3002<\/p>\n<p>\u3068\u308a\u3042\u3048\u305a\u3001\u89e3\u6c7a\u7b56\u304c\u307f\u3064\u304b\u308b\u307e\u3067SqlCeDataReader\u306e\u4f7f\u7528\u306f\u8efd\u3044\u3068\u3053\u3060\u3051\u3067\u4f7f\u7528\u3057\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u306eDataSource\u306bSqlCeDataAdapter\u306b\u30bb\u30c3\u30c8\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u3092\u30bb\u30c3\u30c8\u3059\u308b\u3053\u3068\u3068\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306eDataSource\u3068SqlCeDataAdapter\u3092\u4f7f\u3063\u305f\u65b9\u6cd5\u3060\u3068\u30010.3\u79d2\u3067\u51e6\u7406\u3067\u304d\u308b\u306e\u3067\u3001\u306a\u306b\u304b\u8a2d\u5b9a\u3057\u3060\u3044\u3067SqlCeDataReader\u3067\u3082\u901f\u304f\u306a\u308b\u306e\u304b\u3001\u3082\u3068\u3082\u3068\u9045\u3044\u306e\u304b\u73fe\u6bb5\u968e\u3067\u3001\u306f\u3063\u304d\u308a\u3057\u307e\u305b\u3093\u3002<\/p>\n<p>\u3053\u306e\u4ef6\u3067\u3001\u306a\u306b\u304b\u5206\u304b\u308c\u3070\u307e\u305f\u30a8\u30f3\u30c8\u30ea\u30fc\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>photo by B\u0435n SQL Server Compact 3.5\u306eSqlCeDataReader\u3092\u4f7f\u7528\u3057\u3066\u3001\u201dWhile\u201d\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3067\u30eb\u30fc\u30d7\u51e6\u7406\u3092\u884c\u3044\u3001\u30c7\u30fc\u30bf\u3092\u30ea\u30fc\u30c9\u3002 SQL Server 2008 Expr [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,32],"tags":[272,252,251,37,250,354,157],"class_list":["post-1120","post","type-post","status-publish","format-standard","hentry","category-sqlserver","category-database","tag-272","tag-252","tag-compact","tag-express","tag-sql","tag-sqlcedatareader","tag-157"],"_links":{"self":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1120"}],"version-history":[{"count":2,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1120\/revisions"}],"predecessor-version":[{"id":1123,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1120\/revisions\/1123"}],"wp:attachment":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1120"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}