C# Á¬½ÓMySqlµÄ·½·¨

1.´Óhttp://prdownloads.sourceforge.net/mysqldrivercs/MySQLDriverCS-n-EasyQueryTools-3.0.18.exe?downloadÉÏÏÂÔØMySQLDriverCS. 
2.°ÑMySQLDriverCS.dll.Ìí¼Óµ½.netµÄ×é¼þ 
3.ʹÓ÷½·¨ 
 ÏÂÃæÊÇ´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó:
ÏÂÃæÊÇ´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó:
using MySQLDriverCS;
MySQLConnection conn =  new MySQLConnection( new MySQLConnectionString("localhost","test","root","").AsString );
conn.Open();
Èç¹ûÄãʹÓõÄÊÇ.netµÄ¼¯³É¿ª·¢»·¾³(visual studio.net)ÄÇôÔÚ´úÂëÖÐÊäÈëMySQLDriverCSºóÔÙÊäÈëÒ»¸ö”.”¾Í¿ÉÒÔ¿´µ½MySQLDriverCSÃû³Æ¿Õ¼äÖеÄËùÓеĶ«Î÷ÁË.
ÏÂÃæÊÇcommond:
MySQLCommand cmd; 
   cmd = new MySQLDriverCS.MySQLCommand("DROP TABLE IF EXISTS test.mysqldrivercs_test",conn); 
   cmd.ExecuteNonQuery(); 
   cmd.Dispose();
 
   cmd = new MySQLDriverCS.MySQLCommand("CREATE TABLE test.mysqldrivercs_test("+ 
    "SettingID tinyint(3) unsigned NOT NULL auto_increment,"+ 
    "SettingValue text, "+ 
    "PRIMARY KEY  (SettingID), UNIQUE KEY SettingID(SettingID),  KEY SettingID_2 (SettingID))"+ 
    " TYPE=MyISAM COMMENT='MySQL test table'",conn); 
    
   cmd.ExecuteNonQuery(); 
   cmd.Dispose();
ÏÂÃæÊÇinsert:    
·½·¨Ô­ÐÍ£º 
public MySQLInsertCommand( 
   MySQLConnection conn, 
   object[,] FieldsAndValues, 
   string Table 
);
string Value = "Value"; 
   int SettingID = 1;
    
   new MySQLInsertCommand(conn, 
    new object[,] {{"field1",SettingID},{"field2",Value}}, 
    "mysqldrivercs_test" 
    );
mysqldrivercs_test ÊDZíÃû 
 
ÏÂÃæÊÇupd