{"id":662,"date":"2020-09-11T01:06:00","date_gmt":"2020-09-10T16:06:00","guid":{"rendered":"http:\/\/tindevil.com\/?p=662"},"modified":"2024-06-05T15:40:27","modified_gmt":"2024-06-05T06:40:27","slug":"simple-c-%ea%b0%80%ea%b3%84%eb%b6%80mdb%eb%a5%bc-%eb%a7%8c%eb%93%a4%ec%9e%90-01-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4%ec%97%b0%ea%b2%b0","status":"publish","type":"post","link":"https:\/\/tindevil.com\/?p=662","title":{"rendered":"[SIMPLE C#] \uac00\uacc4\ubd80(MDB)\ub97c \ub9cc\ub4e4\uc790 (01\/\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5f0\uacb0)"},"content":{"rendered":"\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"[SIMPLE C#] \uac00\uacc4\ubd80(MDB)\ub97c \ub9cc\ub4e4\uc790 (01\/\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5f0\uacb0)\" width=\"1200\" height=\"900\" src=\"https:\/\/www.youtube.com\/embed\/egemcHnA8RA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Table of Contents<\/h2>\n\n\n\n<p>Day 01 : \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0<br>Day 02 : \ub2e8\ucd95\ud0a4 \ubc0f \uac80\uc0c9<br>Day 03 : \ubcf4\uace0\uc11c \ucd94\uac00<br>Day 04 : \ubcf4\uace0\uc11c \ub2e4\uc911\uc120\ud0dd, \ucc28\ud2b8<br>Day 05 : \ub9c8\uac10\uc791\uc5c5<br>Day 06 : \uc124\uce58\ud504\ub85c\uc81d\ud2b8 \uc791\uc131<br>Day 07 : \ucd5c\uc885\ub9c8\ubb34\ub9ac<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Description<\/h2>\n\n\n\n<p>MDB \ud30c\uc77c\uacfc Tableadapter \ub97c \ud65c\uc6a9\ud55c \uc608\uc81c.<br>TableAdapter(\uc774 \ud558 \uc904\uc5ec\uc11c TA\ub85c \ud569\ub2c8\ub2e4)\ub97c \ud1b5\ud574\uc11c Databse -&gt; Dataset \ubcc0\ud658\uc774 \uc77c\uc5b4\ub098\uba70, \uae30\uc874 DataSet \uc608\uc81c\ub97c \ud1b5\ud574\uc11c \ud504\ub85c\uadf8\ub7a8\uc744 \uac1c\ubc1c \ud569\ub2c8\ub2e4.<br>TableAdapter : Database &lt;-&gt; Dataset \uc758 \uad50\ud658 \uc791\uc5c5\uc744 \uc790\ub3d9\uc73c\ub85c \ucc98\ub9ac \ud569\ub2c8\ub2e4.<br>TA\uc758 \ub300\uc0c1\uc774 Microsoft Access Database \uac00 \uc544\ub2cc MSSQL \uc744 \uc9c0\uc815\ud55c\ub2e4\uba74 \ud574\ub2f9 Database \ub3c4 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br>OLEDB\ub97c \ud1b5\ud574\uc11c Oracle, MySQL, Maria DB\ub4f1\ub3c4 \uc5f0\uacb0 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>DB\uc5f0\uacb0\uc2dc OLEDB.ACE \uad00\ub828 \uc624\ub958\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uba74 \uc544\ub798 \uc0ac\uc774\ud2b8\ub97c \ucc38\uace0 \ud558\uc138\uc694.<br><a href=\"http:\/\/tindevil.com\/?p=679\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft.ACE.OLEDB.12.0 (http:\/\/tindevil.com\/?p=679)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Code<\/h2>\n\n\n<p>\/\/\ub370\uc774\ud130\ub97c \uac00\uc838\uc62c\ub54c\ub294 fill \uba85\ub839\uc744 \uc0ac\uc6a9 \ud569\ub2c8\ub2e4.<br \/>\ntaData.Fill(this.dataSet1.Data, \uc2dc\uc791\uc77c, \uc885\ub8cc\uc77c);<\/p>\n<p>\/\/\ubcc0\uacbd\ub41c \uc790\ub8cc\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc801\uc6a9\ud560\ub54c\uc5d0\ub294 Update \uba85\ub839\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<br \/>\ntaData.Update(this.dataSet1.Data);<\/p>\n<p>\/\/TableAdapter \uc5d0 insert,update,delete\ub97c \uc9c1\uc811 \ud638\ucd9c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\nta.Insert(&#8220;admin&#8221;, &#8220;1234&#8221;);<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Files<\/h2>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-ac878605-cf37-4972-9cac-8a8bd00ce419\" href=\"http:\/\/tindevil.com\/wp-content\/uploads\/2020\/09\/MoneyBookMDB_Day01.zip\">MoneyBookMDB_Day01<\/a><a href=\"http:\/\/tindevil.com\/wp-content\/uploads\/2020\/09\/MoneyBookMDB_Day01.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-ac878605-cf37-4972-9cac-8a8bd00ce419\">\ub2e4\uc6b4\ub85c\ub4dc<\/a><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Library<\/h2>\n\n\n\n<p>\ud504\ub85c\uadf8\ub7a8\ub85c\uadf8(arLog) : <a href=\"http:\/\/tindevil.com\/?p=153\">http:\/\/tindevil.com\/?p=153<\/a><br>\ud658\uacbd\uc124\uc815(arSetting) : <a href=\"http:\/\/tindevil.com\/?p=155\">http:\/\/tindevil.com\/?p=155<\/a><br>\uc790\uc8fc\uc4f0\ub294\uc720\ud2f8\ub9ac\ud2f0(StaticClass) : <a href=\"http:\/\/tindevil.com\/?p=190\">http:\/\/tindevil.com\/?p=190<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Table of Contents Day 01 : \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0Day 02 : \ub2e8\ucd95\ud0a4 \ubc0f \uac80\uc0c9Day 03 : \ubcf4\uace0\uc11c \ucd94\uac00Day 04 : \ubcf4\uace0\uc11c \ub2e4\uc911\uc120\ud0dd, \ucc28\ud2b8Day 05 : \ub9c8\uac10\uc791\uc5c5Day 06 : \uc124\uce58\ud504\ub85c\uc81d\ud2b8 \uc791\uc131Day 07 : \ucd5c\uc885\ub9c8\ubb34\ub9ac Description MDB \ud30c\uc77c\uacfc Tableadapter \ub97c \ud65c\uc6a9\ud55c \uc608\uc81c.TableAdapter(\uc774 \ud558 \uc904\uc5ec\uc11c TA\ub85c \ud569\ub2c8\ub2e4)\ub97c \ud1b5\ud574\uc11c Databse -&gt; Dataset \ubcc0\ud658\uc774 \uc77c\uc5b4\ub098\uba70, \uae30\uc874 DataSet \uc608\uc81c\ub97c \ud1b5\ud574\uc11c \ud504\ub85c\uadf8\ub7a8\uc744 \uac1c\ubc1c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":[],"rop_publish_now_history":[],"rop_publish_now_status":"pending","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[42],"tags":[],"class_list":["post-662","post","type-post","status-publish","format-standard","hentry","category-c---mdb"],"_links":{"self":[{"href":"https:\/\/tindevil.com\/index.php?rest_route=\/wp\/v2\/posts\/662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tindevil.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tindevil.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tindevil.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tindevil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=662"}],"version-history":[{"count":7,"href":"https:\/\/tindevil.com\/index.php?rest_route=\/wp\/v2\/posts\/662\/revisions"}],"predecessor-version":[{"id":692,"href":"https:\/\/tindevil.com\/index.php?rest_route=\/wp\/v2\/posts\/662\/revisions\/692"}],"wp:attachment":[{"href":"https:\/\/tindevil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tindevil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tindevil.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}