{"id":1124,"date":"2009-04-23T19:56:13","date_gmt":"2009-04-23T10:56:13","guid":{"rendered":"http:\/\/gigasmegas.com\/?p=1124"},"modified":"2009-04-23T20:41:56","modified_gmt":"2009-04-23T11:41:56","slug":"vbnet-tips-dataset%e3%81%ab%e8%bf%bd%e5%8a%a0%e3%81%97%e3%81%9fdatatable%e3%82%92%e8%a7%a3%e6%94%be","status":"publish","type":"post","link":"http:\/\/gigasmegas.com\/?p=1124","title":{"rendered":"VB.NET Tips DataSet\u306b\u8ffd\u52a0\u3057\u305fDataTable\u3092\u89e3\u653e"},"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-0146-400x259.png\" alt=\"DataSet\u306b\u8ffd\u52a0\u3057\u305fDataTable\u3092\u89e3\u653e\" title=\"DataSet\u306b\u8ffd\u52a0\u3057\u305fDataTable\u3092\u89e3\u653e\" width=\"400\" height=\"259\" class=\"alignnone size-medium wp-image-1125\" srcset=\"http:\/\/gigasmegas.com\/wp-content\/uploads\/2009\/04\/snag-0146-400x259.png 400w, http:\/\/gigasmegas.com\/wp-content\/uploads\/2009\/04\/snag-0146.png 491w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/a><\/p>\n<address>photo by <a onclick=\"javascript:pageTracker._trackPageview('\/outgoing\/www.flickr.com\/photos\/mariaksteinsson\/');\"  href=\"http:\/\/www.flickr.com\/photos\/mariaksteinsson\/\">Maria Kristin Steinsson<\/a><\/address>\n<p>VB.NET\u3067DataSet\u306bDataTable\u3092\u8ffd\u52a0\u3057\u3066\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u306eDataSource\u306b\u767b\u9332\u3057\u3066\u8868\u793a\u3002<\/p>\n<p>\u3053\u306e\u51e6\u7406\u3092\u884c\u3063\u305f\u5f8c\u3001\u5185\u5bb9\u3092\u3059\u3079\u3066\u30ea\u30ed\u30fc\u30c9\u3059\u308b\u3068\u304d\u306bDataSet\u306b\u767b\u9332\u3057\u305fDataTable\u306b\u305d\u306e\u307e\u307e\u30ea\u30ed\u30fc\u30c9\u3092\u304b\u3051\u3001\u4e0a\u66f8\u304d\u3059\u308b\u3068\u51e6\u7406\u901f\u5ea6\u304c\u3050\u3063\u3068\u843d\u3061\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u969b\u3001DataSet.Tables \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u4f7f\u7528\u3057\u3066\u3001DataSet\u5185\u306b\u8a72\u5f53\u30c6\u30fc\u30d6\u30eb\u304c\u5b58\u5728\u3059\u308b\u304b\u78ba\u8a8d\u3057\u3001DataSet\u5185\u306e\u8a72\u5f53DataTable\u3092\u30af\u30ea\u30a2\u30fc\u3057\u3066\u304b\u3089\u518d\u767b\u9332\u3059\u308b\u3068\u901f\u5ea6\u3082\u843d\u3061\u305a\u30b9\u30e0\u30fc\u30ba\u306b\u767b\u9332\u3067\u304d\u307e\u3059\u3002<br \/>\n<a href=\"http:\/\/msdn.microsoft.com\/ja-jp\/library\/system.data.dataset.tables(VS.80).aspx\"><br \/>\nMSDN .NET Framework \u30af\u30e9\u30b9 \u30e9\u30a4\u30d6\u30e9\u30ea DataSet.Tables \u30d7\u30ed\u30d1\u30c6\u30a3<\/a><br \/>\n<!--more--><\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\n     Dim DataS As New DataSet()\r\n     Dim DataA As SqlDataAdapter\r\n \r\n     Dim table As DataTable\r\n      '\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u30ea\u30ed\u30fc\u30c9\u5bfe\u8c61\u306e\u8a72\u5f53\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308c\u3070\u30af\u30ea\u30a2\u30fc\r\n     For Each table In DataS.Tables\r\n          Console.WriteLine(table.TableName)\r\n          If table.TableName = &quot;hoge&quot; then\r\n               table.Clear()\r\n          End If\r\n     Next table\r\n\t    \t    \r\n     DataA = New SqlDataAdapter(&quot;select * from hoge&quot;, hConnection)\r\n     DataA.Fill(DataS, &quot;cust&quot;)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>photo by Maria Kristin Steinsson VB.NET\u3067DataSet\u306bDataTable\u3092\u8ffd\u52a0\u3057\u3066\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u306eDataSource\u306b\u767b\u9332\u3057\u3066\u8868\u793a\u3002 \u3053\u306e\u51e6\u7406\u3092\u884c\u3063\u305f\u5f8c\u3001\u5185\u5bb9\u3092\u3059\u3079\u3066\u30ea\u30ed\u30fc\u30c9\u3059 [&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,303,19,25,32,3,15],"tags":[306,272,355,356,250,254,304,157],"class_list":["post-1124","post","type-post","status-publish","format-standard","hentry","category-sqlserver","category-vbnet","category-wordpress","category-computer","category-database","category-hardware","category-movie","tag-net","tag-272","tag-dataset","tag-datatable","tag-sql","tag-tips","tag-vb","tag-157"],"_links":{"self":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1124","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=1124"}],"version-history":[{"count":6,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1124\/revisions"}],"predecessor-version":[{"id":1131,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1124\/revisions\/1131"}],"wp:attachment":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1124"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}