{"id":952,"date":"2018-06-13T05:30:39","date_gmt":"2018-06-12T20:30:39","guid":{"rendered":"https:\/\/prg.waou.biz\/?p=952"},"modified":"2019-01-20T11:09:10","modified_gmt":"2019-01-20T02:09:10","slug":"%e3%83%87%e3%83%bc%e3%82%bf%e5%85%a5%e5%8a%9b","status":"publish","type":"post","link":"https:\/\/prg.waou.biz\/?p=952","title":{"rendered":"FireBird\u3067\u30c7\u30fc\u30bf\u3092\u65b0\u898f\u5165\u529b"},"content":{"rendered":"<h2>FireBird\u3067\u30c7\u30fc\u30bf\u30fc\u3092\u30a4\u30f3\u30b5\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002\u30b3\u30de\u30f3\u30c9\u3092\u4f5c\u6210\u3057\u3001\u30b3\u30de\u30f3\u30c9\u6587\u3067INSERT\u3057\u307e\u3059\u3002<\/h2>\n<pre class=\"lang:default decode:true\"> using (var con = new FbConnection(gro.conString))\r\n            {\r\n                try\r\n                {\r\n\r\n\r\n                    using (FbCommand cmd = con.CreateCommand())\r\n                    {\r\n                        con.Open();\r\n\r\n                        \/\/ \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u958b\u59cb\r\n                        var tran = con.BeginTransaction();\r\n                        cmd.Transaction = tran;\r\n\r\n\r\n                        cmd.CommandText = @\"INSERT INTO BaseTable (name,nihongo,eigo,isData) VALUES (@name,@nihongo,@eigo,@isData)returning id\";\r\n\r\n                     \r\n                        cmd.Parameters.Add(\"@name\", FbDbType.VarChar).Value = \"eeee\";\r\n                        cmd.Parameters.Add(\"@nihongo\", FbDbType.VarChar).Value = \"ffffff\";\r\n                        cmd.Parameters.Add(\"@eigo\", FbDbType.VarChar).Value = \"gggggggggg\";\r\n\r\n                        cmd.Parameters.Add(\"@isData\", FbDbType.VarChar).Value = \"true\";\r\n                          \r\n                        \r\n                        \/\/ \u30c7\u30fc\u30bf\u767b\u9332\r\n                        \r\n                        cmd.Parameters.Add(new FbParameter() { Direction = System.Data.ParameterDirection.Output });\r\n                       ;\r\n\r\n                        cmd.ExecuteNonQuery();\r\n\r\n                        \/\/ \u3053\u3053\u3067\u30b3\u30df\u30c3\u30c8\r\n                        tran.Commit();\r\n\r\n\r\n                    }\r\n\r\n                   \r\n\r\n\r\n                }\r\n                catch (Exception ex)\r\n                {\r\n                    noby.Message(ex.ToString(), m.Stop);\r\n\r\n                }\r\n                finally\r\n                {\r\n                    con.Close();\r\n                }\r\n\r\n           \r\n            \r\n            \r\n            }\r\n\r\n            string sqlp = @\"select * from BaseTable \";\r\n\r\n            gcMultiRowKamoku.DataSource = DB.DataDisplaya(sqlp);\r\n        }\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>FireBird\u3067\u30c7\u30fc\u30bf\u30fc\u3092\u30a4\u30f3\u30b5\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002\u30b3\u30de\u30f3\u30c9\u3092\u4f5c\u6210\u3057\u3001\u30b3\u30de\u30f3\u30c9\u6587\u3067INSERT\u3057\u307e\u3059\u3002 using (var con = new FbConnection(gro.conString)) { try {  [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","_lightning_design_setting":[],"footnotes":""},"categories":[22],"tags":[],"class_list":["post-952","post","type-post","status-publish","format-standard","hentry","category-firebird"],"_links":{"self":[{"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/posts\/952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=952"}],"version-history":[{"count":4,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/posts\/952\/revisions"}],"predecessor-version":[{"id":1071,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/posts\/952\/revisions\/1071"}],"wp:attachment":[{"href":"https:\/\/prg.waou.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}