C#ÔõôÁ¬½ÓMySql£¿
C#ÔõôÁ¬½ÓMySql£¿
sqlÓï¾ä·ÅÄÄ?
½á¹û¼¯ÔõôÓã¿
Çó½â´ð
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
DBConn = new MySQLConnection(new MySQLConnectionString("Ö÷»ú","Êý¾Ý¿â","Óû§","ÃÜÂë",¶Ë¿Ú).AsString);
Ó÷¨ºÍMSSQLÒ»Ñù
˵µÄºÃ£¬µ«ÊÇÕâºÁÎÞÒâÒå
ºÇºÇ
ÎÒÒ»Ö±¶¼ÓõÄJAVA£¬¶øÇÒÁ¬µÄÊÇORCALÊý¾Ý¿â
ºÙºÙ£¬Ñ§Ï°ÁË£¡
Òª²»¼ÌÐøÁ¬OracleÈ¥£¿
ÏÂÔØÁ¬½ÓmysqlµÄÇý¶¯£ºC# code:
http://download.csdn.net/source/1077784
°²×°ºó£¬Ìí¼ÓÒýÓãºMySql.Data.MySqlClient;
È»ºó´úÂëÖУ¬°ÑSqlConnectionµÈÀà¶¼¶ÔÓ¦µÄÓÐMySqlConnection£¬Èç¹ûÄã²»»áÁ¬sql£¬»Ø¼Ò¿´Êé
¶¥
Ïà¹ØÎÊ´ð£º
ÍøÉÏ¿´Á˺ܶ࣬ºÃÏñÕâÑùµ÷ÓúܺãºExcel.Application();
µ«ÊÇÐèÒªÒýÈëʲôÃüÃû¿Õ¼ä»òÕßdll²ÅÄÜÔËÐÐExcelÕâ¸öÀàÄØ£¿
Excel.dll
Excel.dllÔÚExcel°²×°³ÌÐòÏ£¬
using Microsoft.Office.Interop.Excel;
......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
¸ßÊÖ£¬ÏÖÔÚÓöµ½Ò»¸ömysql±¸·ÝµÄÎÊÌâ¡£
ÎÒµÄÊý¾Ý¿âÀïÓÐһЩÓÃcreate function½¨Á¢µÄ×Ô¶¨Ò庯Êý¡£µ±ÎÒÓÃmysqldump±¸·Ý¸ÃÊý¾Ý¿âÈ»ºóµ¼Èëµ½ÁíÍâÒ»¸ö·þÎñÆ÷BÉÏ£¬·¢ÏÖ·þÎñÆ÷BÉÏÖ»ÓÐÊý¾Ý£¬¶øÃ»ÓÐÄÇЩ×Ô¶¨ÒåµÄº¯Êý¡£Î ......
orcle Óï¾ä create table book1(name, price) as select book_name, price form book;
¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô
create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......