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条评论