{"id":2066,"date":"2017-11-13T12:54:15","date_gmt":"2017-11-13T03:54:15","guid":{"rendered":"http:\/\/okamurax.com\/?p=2066"},"modified":"2017-11-13T12:54:15","modified_gmt":"2017-11-13T03:54:15","slug":"c-dataadapter%e5%ae%9f%e9%a8%93","status":"publish","type":"post","link":"https:\/\/appbay.org\/?p=2066","title":{"rendered":"C# DataAdapter\u5b9f\u9a13"},"content":{"rendered":"<pre class=\"lang:c# decode:true \">using System;\r\nusing System.Collections.Generic;\r\nusing System.ComponentModel;\r\nusing System.Data;\r\nusing System.Drawing;\r\nusing System.Linq;\r\nusing System.Text;\r\nusing System.Threading.Tasks;\r\nusing System.Windows.Forms;\r\n\r\nusing System.Data.OleDb;\r\n\r\nnamespace WindowsFormsApp1\r\n{\r\n    public partial class Form1 : Form\r\n    {\r\n        public Form1()\r\n        {\r\n            \/\/ DataTable\u306f\u30c6\u30fc\u30d6\u30eb\u30ad\u30e3\u30c3\u30b7\u30e5\u3067\u3001\u305d\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u304cDataSet\u3002\r\n\r\n            \/\/ DataReader\/Adapter\r\n            \/\/ DataReader\u306f\u30eb\u30fc\u30d7\u3067\u53d6\u5f97\u3057\u3001Read()\u3055\u308c\u308b\u307e\u3067\u8aad\u307f\u8fbc\u307e\u308c\u306a\u3044\u305f\u3081\u8efd\u3044\u3002\r\n            \/\/ DataAdapter\u306fFill()\u3067\u53d6\u5f97\u3057\u3066DataSet\u306b\u5168\u3066\u5165\u308b\u3002(da -&gt; ds)\r\n            \/\/ DataAdapter\u3078\u306e\u66f4\u65b0\u306fUpdate()\u3067\u51e6\u7406\u3002\r\n\r\n            \/\/ \u5b9f\u9a13\r\n            \/\/ create table tb([ID] autoincrement, [age] int);\r\n\r\n            OleDbConnection con = new OleDbConnection(\"provider=microsoft.jet.oledb.4.0;data source=\" + Application.StartupPath + @\"\\db.mdb\" + \";\");\r\n            \/\/con.Open();\r\n            \/\/\u3053\u3053\u306eOpen()\u306f\u4e0d\u8981\u3002Open()\u3059\u308b\u306a\u3089Close()\u5fc5\u8981\u3002\r\n            \/\/Open()\u3059\u308b\u3068\u63a5\u7d9a\u578b\u3068\u306a\u308b\u3002\r\n\r\n            \/\/\u30c7\u30fc\u30bf\u30a2\u30c0\u30d7\u30bf\u306e\u4f5c\u6210\uff0f\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u4f5c\u6210\r\n            OleDbDataAdapter da = new OleDbDataAdapter(\"select * from tb\", con);\r\n            DataSet ds = new DataSet();\r\n\r\n            \/\/\u3053\u308c\u304c\u306a\u3044\u3068Update()\u3067\u30a8\u30e9\u30fc\r\n            new OleDbCommandBuilder(da);\r\n\r\n            da.Fill(ds);\r\n\r\n            \/\/\u65b0\u3057\u3044\u884c\u306e\u4f5c\u6210\r\n            DataRow dr = ds.Tables[0].NewRow();\r\n            dr[1] = 10;\r\n            ds.Tables[0].Rows.Add(dr);\r\n\r\n            \/\/\u30c7\u30fc\u30bf\u30b0\u30ea\u30c3\u30c9\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3057\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u8a2d\u5b9a\r\n            DataGridView d = new DataGridView();\r\n            d.DataSource = ds.Tables[0];\r\n            Controls.Add(d);\r\n\r\n            \/\/DataAdapter\u306eUpdate()\u3092\u5b9f\u884c\u3002\r\n            Button btn = new Button();\r\n            btn.Top = Height - 100;\r\n            Controls.Add(btn);\r\n            btn.Click += new EventHandler((object sender, EventArgs e) =&gt; {\r\n                da.Update(ds.Tables[0]);\/\/\u65b0\u3057\u3044\u884c\u304c\u8ffd\u52a0\u3055\u308c\u3066\u3044\u308b\u306e\u3067Update()\u3067\u306fInsert\u304c\u5b9f\u884c\u3055\u308c\u308b\u3002\r\n            });\r\n\r\n            \/\/con.Close();\r\n            \/\/InitializeComponent();\r\n        }\r\n    }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.D &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/appbay.org\/?p=2066\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;C# DataAdapter\u5b9f\u9a13&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[9],"class_list":["post-2066","post","type-post","status-publish","format-standard","hentry","category-1","tag-c-net"],"_links":{"self":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/2066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2066"}],"version-history":[{"count":1,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/2066\/revisions"}],"predecessor-version":[{"id":2067,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/2066\/revisions\/2067"}],"wp:attachment":[{"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}