c#能用mysql吗_C#中使用MYSQL数据库

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);

关闭链接: