C#中使用MYSQL數(shù)據(jù)庫

一提起mysql數(shù)據(jù)庫,好像就是在說Java,jsp或者Php,其實(shí)在所有程序中都可以使用mysql 數(shù)據(jù)庫,其它的程序使用my sql數(shù)據(jù)庫的方法是使用my sql 提供的odbc驅(qū)動(dòng),在.Net 中可以使用類似于jdbc似的東東.它的名字是:MySQLDriverCS.dll.把它添加到.Net的組件面板里,至于如何添加,則不是本篇的任務(wù)了(')!
    下面是創(chuàng)建一個(gè)數(shù)據(jù)庫鏈接:
    using MySQLDriverCS;
    MySQLConnection conn = new MySQLConnection( new MySQLConnectionString("localhost","test","root","").AsString );
    conn.Open();
    如果你使用的是.Net的集成開發(fā)環(huán)境(visual studio.Net)那么在代碼中輸入MySQLDriverCS后再輸入一個(gè)”.”就可以看到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:
    string Value = "Value";
     int SettingID = 1;
     new MySQLInsertCommand(conn,
     new object[,] {{"SettingID",SettingID},{"SettingValue",Value}},
     "mysqldrivercs_test"
     );
    下面是update
     Value = "Value2";
     new MySQLUpdateCommand(conn,
     new object[,] {{"SettingValue",Value}},
     "mysqldrivercs_test",
     new object[,] {{"SettingID","=",SettingID}},
     null
     );
    下面是select
     DataTable dt = new MySQLSelectCommand(conn,
     new string[] {"SettingID","SettingValue"},
     new string[] {"mysqldrivercs_test"},
     new object[,] {{"SettingID","=",SettingID}},
     null,
     null
     ).Table;
     string storedValue = dt.Rows[0]["SettingValue"].ToString();
     下面是delete
     new MySQLDeleteCommand(conn,"mysqldrivercs_test",new object[,] {{"SettingID","=",SettingID}},null);
    關(guān)閉鏈接:
     conn.Close();
     怎么樣,很方便吧!