C#中使用MYSQL數據庫
提到mysql數據庫,好像就是Java,jsp或者Php。實際上,mysql數據庫可以在所有程序中使用。其他程序使用my sql提供的odbc敺動程序,類似jdbc的東西可以用在。網。它的名字是:MySQLDriverCS.dll把它添加到組件麪板中。Net,但如何添加不是本文的任務(')!
以下是創建數據庫鏈接的方法:
使用MySQLDriverCS
MySQL connection conn = new MySQL connection(new MySQL connectionstring(" localhost"," test"," root","")。AsString);
conn . Open();
如果您使用的是集成開發環境(Visual studio.Net)。Net,輸入一個“.”就可以看到MySQLDriverCS的name 空中的所有內容在代碼中。
以下是常見的:
MySQLCommand cmd
cmd =新的MySQLDriverCS。MySQL command(" DROP TABLE IF EXISTS test . mysqldrivercs _ test",conn);
cmd。ExecuteNonQuery();
cmd。dispose();
cmd =新MySQLDriverCS。MySQL command(" 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();
插入以下內容:
string Value =" Value
int setting id = 1;
new MySQLInsertCommand(conn,
new object[,] {{"SettingID",SettingID},{"SettingValue",Value}},
" mysqldrivercs _ test"
);
以下是更新。
Value =" Value2
new MySQL updatecommand(conn,
new object[,] {{"SettingValue",Value}},
"mysqldrivercs_test",
new object[,]{" setting id"," =",SettingID}},
null
);
以下是選擇。
DataTable dt = new MySQLSelectCommand(conn,
new string[] {"SettingID"," SettingValue"},
new string[]{" mysqldrivercs _ test" },
new object[,] {"SettingID"," =",SettingID}},
null,
null
)。表;
字符串storedValue = dt。行[0]["設置值"]。ToString();
下麪是delete
new MySQL delete命令(conn," mysqldrivers _ test",new object [,] {{"setting id"," =",setting id}},null);
關閉鏈接:
conn . Close();
怎麽樣?很方便!
0條評論