{"id":24,"date":"2008-04-05T14:48:12","date_gmt":"2008-04-05T14:48:12","guid":{"rendered":"http:\/\/tw.newtonstudio.com\/?p=24"},"modified":"2008-04-05T14:48:12","modified_gmt":"2008-04-05T14:48:12","slug":"%e5%be%9ephp%e5%b9%b3%e8%87%ba%e6%90%ac%e7%a7%bb%e5%88%b0net-mysql%e7%9a%84%e8%b3%87%e6%96%99%e8%a9%b2%e6%80%8e%e9%ba%bc%e8%be%a6","status":"publish","type":"post","link":"https:\/\/tw.newtonstudio.com\/?p=24","title":{"rendered":"\u5f9ePHP\u5e73\u81fa\u642c\u79fb\u5230.NET, MYSQL\u7684\u8cc7\u6599\u8a72\u600e\u9ebc\u8fa6?"},"content":{"rendered":"<p>\u5982\u679c\u5404\u4f4d\u8ddf\u6211\u4e00\u6a23, \u6709\u5f9ePHP\u5e73\u81fa\u642c\u79fb\u5230.NET\u7684\u7d93\u9a57, \u4e00\u5b9a\u6703\u5361\u5728\u8cc7\u6599\u5eab\u7684\u79fb\u8f49\u554f\u984c.<br \/>\n\u6211\u5011\u77e5\u9053Microsof SQL SERVER \u5f88\u597d\u7528, \u800c\u4e14\u865f\u7a31\u8ddf.NET\u5e73\u81fa\u7d50\u5408\u5f97\u5929\u8863\u7121\u7e2b,<br \/>\n\u4f46\u662f\u5982\u679c\u6211\u4ee5\u524d\u7684\u8cc7\u6599\u90fd\u5b58\u653e\u5728MYSQL, \u90a3\u8a72\u600e\u9ebc\u8fa6?<\/p>\n<p>\u65b9\u6cd5\u5176\u5be6\u6709\u5169\u7a2e,<\/p>\n<p>\u65b9\u6cd5\u4e00(\u5982\u679c\u60a8\u5805\u6301\u8981\u642c\u8cc7\u6599\u5eab)<br \/>\n\u53ef\u4ee5\u5148\u4f7f\u7528PHPMYADMIN\u4f86\u505a\u532f\u51faEXCEL\u6216CSV\u7684\u52d5\u4f5c,\u00a0 \u7136\u5f8c\u518d\u901a\u904e.NET\u7684\u7a0b\u5f0f\u628a\u8cc7\u6599\u9001\u5165,<br \/>\n\u9019\u500b\u65b9\u5f0f\u9700\u8981\u5728MSSQL\u91cd\u65b0\u5efa\u7acb\u8cc7\u6599\u8868, \u7136\u5f8c\u518d\u628a\u8cc7\u6599\u6279\u6b21\u9001\u5165, \u9019\u6a23\u505a\u5c31\u53ef\u4ee5\u628aMYSQL\u7684\u8cc7\u6599\u5b8c\u5168\u79fb\u8f49\u5230MSSQL, \u4f46\u9019\u6a23\u505a\u65e2\u8cbb\u6642, \u53c8\u8981\u5beb\u7a0b\u5f0f, \u800c\u4e14\u4e5f\u96e3\u4fdd\u4e0d\u6703\u6709\u8cc7\u6599\u907a\u5931.<\/p>\n<p>\u65b9\u6cd5\u4e8c<br \/>\nMYSQL \u5176\u5be6\u5df2\u7d93\u5e6b\u60a8\u60f3\u597d\u4e86\u89e3\u6c7a\u65b9\u6848, \u5728<a href=\"http:\/\/www.mysql.com\">http:\/\/www.mysql.com<\/a> \u7684\u5b98\u7db2\u4e2d\u5176\u5be6\u5df2\u7d93\u63d0\u4f9b\u4e86\u514d\u8cbb\u7684NAMESPACE, .dll, \u8b93\u60a8\u76f4\u63a5\u5b89\u88dd\u5728VISUAL STUDIO(VS)\u4e0a, \u5f9e\u6b64\u4f60\u5c31\u53ef\u4ee5\u7528VS \u4f86\u7de8\u8f2fMYSQL\u8cc7\u6599\u5eab, \u4ed6\u7684ConnectionString, DataAdapter, DataCommand\u7b49\u5ba3\u544a\u65b9\u5f0f\u8ddfMSSQL\u662f\u5927\u540c\u5c0f\u7570\u7684, \u56e0\u6b64\u60a8\u53ef\u4ee5\u8f15\u8f15\u9b06\u9b06\u5b58\u53d6MYSQL\u7684\u8cc7\u6599, \u53c8\u4e0d\u5fc5\u64d4\u5fc3\u6703\u6709\u8cc7\u6599\u907a\u5931\u7684\u554f\u984c.<\/p>\n<p>\u4e0b\u8f09\u7684\u539f\u4ef6\u540d\u7a31\u70ba: CONNECTOR ADO.NET 5.1<br \/>\n\u7db2\u5740: <a href=\"http:\/\/dev.mysql.com\/downloads\/connector\/net\/5.1.html\">http:\/\/dev.mysql.com\/downloads\/connector\/net\/5.1.html<\/a><br \/>\n\u5b89\u88dd\u65b9\u6cd5: \u76f4\u63a5\u6253\u958b msi\u6a94\u5c31\u6703\u81ea\u52d5\u5b89\u88dd\u5230VISUAL STUDIO\u7684NAMESPACE FOLDER\u88e1<\/p>\n<p>\u9644\u4ef6\u9084\u5305\u62ec\u4e86MYSQL CLASSES\u7684\u904b\u7528\u65b9\u6cd5\u8207\u7bc4\u4f8b, \u8b93\u60a8\u8f15\u9b06\u5b78\u7fd2\u4e0a\u624b<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u679c\u5404\u4f4d\u8ddf\u6211\u4e00\u6a23, \u6709\u5f9ePHP\u5e73\u81fa\u642c\u79fb\u5230.NET\u7684\u7d93\u9a57, \u4e00\u5b9a\u6703\u5361\u5728\u8cc7\u6599\u5eab\u7684\u79fb\u8f49\u554f\u984c. \u6211\u5011\u77e5\u9053Microso [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-24","post","type-post","status-publish","format-standard","hentry","category-mysql-"],"_links":{"self":[{"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=24"}],"version-history":[{"count":0,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=\/wp\/v2\/posts\/24\/revisions"}],"wp:attachment":[{"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=24"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=24"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tw.newtonstudio.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}