ÈçºÎÓÃC#»ñÈ¡MySQLÊý¾Ý¿âÃû
ÎÒÓõÄÊÇMySQLDriverCSµÄ½Ó¿Ú£¬ÍøÉϵĻù±¾Á¬½Ó·½·¨Ò²»á£¬µ«ÊÇÎÒµÄÐèÇóÊÇÒªÔÚδ֪Êý¾Ý¿âÃûµÄÇé¿öÏ£¬ÒÑÖªlocalhost£¬Óû§Ãû£¬ÃÜÂ룬Á¬½ÓÉÏÊý¾Ý¿â²¢»ñÈ¡MySQLÏÖÓеÄÊý¾Ý¿âÃû¡£ÇëÖªµÀµÄ¸ßÊÖ³öÀ´»Ø´ðһϰɣ¡Ð¡µÜÏÈллÄãÃÇÁË£¡
×Ô¼ºÏȶ¥Ò»Ï£¬Ï£Íû¸ßÊÖ³öÀ´»Ø´ð£¡£¡ Ôõô¶¼Ã»Æð´²Â𣿠ΪʲôûÈËÀíÎÒ°¡£¡£¡£¡£¡ °ï¶¥£¬Õâ¸ö²»»á¡£ Á¬½Ómysql show databases; public string StrConn="server=±¾»úÃû£¨.£©;uid=Óû§Ãû£»pwd=ÃÜÂ룻database=Êý¾Ý¿âÃû"£»ÒýÓà static void Main(string[] args) { string connctionString = "server = localhost; database = MySql; user id = root; password = ******;"; MySqlConnection connetion = new MySqlConnection(connctionString); try { string sql = "show databases"; MySqlCommand command = new MySqlCommand(sql); command.Connection = connetion; connetion.Open(); using (MySqlDataReader reader = command.ExecuteReader())
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO; using Syst ......