{"id":439,"date":"2017-04-18T16:50:26","date_gmt":"2017-04-18T07:50:26","guid":{"rendered":"http:\/\/csharp.ihavenomoney.co.kr\/?p=439"},"modified":"2023-08-10T16:27:50","modified_gmt":"2023-08-10T07:27:50","slug":"c-mysqlconnection","status":"publish","type":"post","link":"https:\/\/csharp.ihavenomoney.co.kr\/?p=439","title":{"rendered":"C# MySqlConnection"},"content":{"rendered":"\n

NuGet – MySqlConnector \uc124\uce58<\/h2>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

\ubc29\ubc951. \ud3ec\ud2b8\uc5f0\uacb0\uc740 : \uc544\ub2c8\uace0 , <\/h2>\n\n\n\n
using System.Data;\nusing MySql.Data.MySqlClient;\n \nstatic string connectionString = \"server=localhost,3306;user id=testuser;database=testdb;Pwd=password;allowuservariables=True\";\n \n        public static string SelectALL()\n        {\n            string US_ID = \"\";\n            MySqlConnection conn = new MySqlConnection(userconnectionString);\n                        \n            try\n            {\n                string DOC_HIS = \"\";\n                \n                conn.Open();\n                MySqlCommand cmd = conn.CreateCommand();\n                cmd.CommandText = \"SELECT * FROM mc  Limit 1;\";\n \n                MySqlDataAdapter adap = new MySqlDataAdapter(cmd);\n                DataSet ds = new DataSet();\n \n                MySqlDataReader reader = cmd.ExecuteReader();\n                \n                while (reader.Read())\n                {\n                    US_ID = reader[\"US_ID\"].ToString();\n                }\n \n                reader.Close();\n                return US_ID;\n            }\n \n            catch (Exception ex)\n            {\n                \/\/\ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uac8c \uc608\uc678\ub97c \ub358\uc9c4\ub2e4.\n                \/\/\/throw ex;\n                string Err = ex.ToString();\n                return US_ID;\n            }\n \n            finally\n            {\n                if(conn.State == ConnectionState.Open)\n                {\n                    conn.Close();\n                }\n            }\n        }<\/pre><\/div>\n\n\n\n
Insert<\/h2>\n\n\n\n
using MySqlConnector;\nusing System.Data;\n\n:::\uc911\ub7b5 ::\n\n        static void Main(string[] arges)\n        {\n            var connString = \"Server=111.222.333.111,3306;User ID=admin;Password=1223231;Database=Code1\";\n\n            MySqlConnection conn = new MySqlConnection(connString);\n\n            var sSQLText = \"INSERT INTO Code1.LOG_FILE \" +\n                            \"(SERVERTYPE,\" +\n                            \"CCP,\" +\n                            \"SERVICE,\" +\n                            \"PATH,\" +\n                            \"FILENAME)\" +\n                            \" VALUES\" +\n                            \"(@SERVERTYPE,\" +\n                            \"@CCP,\" +\n                            \"@SERVICE,\" +\n                            \"@PATH,\" +\n                            \"@FILENAME)\";\n\n            try\n            {\n                conn.Open();\n\n                var cmd = new MySqlCommand();\n                \/\/using (var cmd = new MySqlCommand())\n                \/\/ {\n                   cmd.Connection = conn;\n                    cmd.CommandText = sSQLText;\n                    cmd.Parameters.AddWithValue(\"@SERVERTYPE\", 0);\n                    cmd.Parameters.AddWithValue(\"@CCP\", \"AAAA\");\n                    cmd.Parameters.AddWithValue(\"@SERVICE\", \"LOWFARE\");\n                    cmd.Parameters.AddWithValue(\"@PATH\", \"FileName\");\n                    cmd.Parameters.AddWithValue(\"@FILENAME\", \"Hello world\");\n\n                    cmd.ExecuteNonQuery();\n                \/\/}\n            }\n            catch(Exception ex) {\n\n                Console.WriteLine(ex.Message.ToString());\n\n            }\n            \n            if (conn.State == ConnectionState.Open)\n            {\n                conn.Close();\n            }\n\n\n\n            Console.WriteLine(\"ok\");\n\n            Console.ReadLine();\n\n        }<\/pre><\/div>\n\n\n\n
\ubc29\ubc952.<\/h2>\n\n\n\n
 Asp.net Web.config<\/h2>\n\n\n\n
<configuration>\n\n  <connectionStrings>\n    <!-- MySqlConnection -->\n    <add name=\"REG_RULE\" connectionString=\"Server=YOURSERVER;User ID=YOURUSERID;Password=YOURPASSWORD;Database=YOURDATABASE\" \/>\n  <\/connectionStrings>\n\n:: \uc911\ub7b5 ::\n\n<\/configuration><\/pre><\/div>\n\n\n\n
Core<\/h2>\n\n\n\n
{\n  ....\n  \"ConnectionStrings\": {\n    \"Default\": \"Server=YOURSERVER;User ID=YOURUSERID;Password=YOURPASSWORD;Database=YOURDATABASE\"\n  }\n}<\/pre><\/div>\n\n\n\n
\ucc38\uc870 : https:\/\/mysqlconnector.net\/tutorials\/connect-to-mysql\/<\/p>\n\n\n\n
Error :<\/h2>\n\n\n\n
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''TYPE','CCC','PATH','FILENAME') VALUES(0,'LOWFARE','FileName','He' at line 1\nok\n<\/pre><\/div>\n\n\n\n
\uc6d0\uc778 :  MysqlBench \uc5d0\uc11c \ub098\uc624\ub294  \ucffc\ub9ac\uc5d0\uc11c ‘(\uc2f1\uae00\ucffc\ud14c\uc774\uc158)\uc744 \ub2e4 \ube7c\uc57c\uc9c0 \ub41c\ub2e4. \/ C# \ud558\uace0  java \uc758 \ubb38\ubc95\uc801 \ucc28\uc774 <\/h2>\n\n\n\n
INSERT INTO `BasicCode`.`LOG_FILE`\n('TYPE`,\n`CC`,\n`SERVICE`,\n`PATH`,\n`FILENAME`,\n`REGI_DATE`)\nVALUES\n(<{TYPE: }>,\n<{CC: }>,\n<{SERVICE: }>,\n<{PATH: }>,\n<{FILENAME: }>,\n<{REGI_DATE: CURRENT_TIMESTAMP}>);<\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"
NuGet – MySqlConnector \uc124\uce58 \ubc29\ubc951. \ud3ec\ud2b8\uc5f0\uacb0\uc740 : \uc544\ub2c8\uace0 , Insert \ubc29\ubc952. Asp.net Web.config Core \ucc38\uc870 : https:\/\/mysqlconnector.net\/tutorials\/connect-to-mysql\/ Error : \uc6d0\uc778 : MysqlBench \uc5d0\uc11c \ub098\uc624\ub294 \ucffc\ub9ac\uc5d0\uc11c ‘(\uc2f1\uae00\ucffc\ud14c\uc774\uc158)\uc744 \ub2e4 \ube7c\uc57c\uc9c0 \ub41c\ub2e4. \/ C# \ud558\uace0 java \uc758 \ubb38\ubc95\uc801 \ucc28\uc774<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[74],"tags":[],"class_list":["post-439","post","type-post","status-publish","format-standard","hentry","category-c-form"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=439"}],"version-history":[{"count":12,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/439\/revisions"}],"predecessor-version":[{"id":867,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/439\/revisions\/867"}],"wp:attachment":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}