MYSQLÔÚvisual studioÏÂÔõôÁ¬½ÓÄØ£¿
ÎÒн¨ÁËÒ»¸öÍøÕ¾£¬ÔÚweb.configÀïÃæµÄ <appSettings> <!-- ÉèÖÃÊý¾Ý¿âÁ¬½Ó×Ö·û´®ÅäÖà --> <add key="ConnectionString" value="server=localhost;uid=root;pwd=;database=proto_management" /> </appSettings> µ«ÊÇÌáʾÎÒ£ºÓû§ 'root' µÇ¼ʧ°Ü¡£ ÕâÊÇʲôÔÒòÄØ£¿ÊÇVS²»Ö§³ÖMYSQLµÄÁ¬½ÓÂ𣿻¹ÊÇÎÒͬʱװÁËMSSQL Ëû²»ÖªµÀÁ´½ÓÄĸöÊý¾Ý¿âÂð£¿ÒªÔÚ¹ÜÀí¹¤¾ßµÄÊý¾ÝÔ´ÀïÃæÉèÖÃϵͳDSNÂ𣿠ÎÒ¿´ÁíÍâÒ»¸ö¹ÜÀí³ÌÐò È˼ÒÀïÃæµÄÊý¾Ý¿âÁ´½ÓÒ²ÊÇÕâÑùдµÄ°¡¡£ÎÒ³¢ÊÔÁËÏÂÒ²ÊÇÁ¬½Ó²»ÁË¡£
<add name="conn" connectionString="server=hostName(ip); user id=user; password=password; database=dbName;" providerName="MySql.Data.MySqlClient"/> string dbConnectionString = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString; MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = dbConnectionString ; oMySqlConn.Open(); ʹÓÃÊý¾Ý¿â²Ù×÷Àà ÎÒÏëÎÊÏÂMySql.Data.MySqlClientÊÇÒªÒýÓõÄÂð£¿ÎÒÕÒ²»µ½Õâ¸öÎļþŶ¡£ÎÒÓõÄÊÇMYSQL5.1 ÐÐ 15: connectingstring = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString; ±àÒë´íÎóÊÇÔõô»ØÊÂÄØ£¿ÒýÓà ÎÒÏëÎÊÏÂMySql.Data.MySqlClientÊÇÒª
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£ ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......