C# 连接MySql的方法

1.从 http://prdownloads.sourceforge.net/mysqldrivercs/MySQLDriverCS-n-EasyQueryTools-3.0.18.exe?download上下载MySQLDriverCS. :p X7 ?Y
2. 把 MySQLDriverCS.dll.添加到.net的组件 SAF)Rns"%
3.使用方法 )>+ s rt 

下面是创建一个数据库链接:

下面是创建一个数据库链接:

using MySQLDriverCS;

MySQLConnection conn =  new MySQLConnection( new MySQLConnectionString("localhost","test","root","").AsString );

conn.Open();

如果你使用的是.net的集成开发环境(visual studio.net)那么在代码中输入MySQLDriverCS后再输入一个”.”就可以看到MySQLDriverCS名称空间中的所有的东西了.

下面是commond:

MySQLCommand cmd; ](0- 3~@
   cmd = new MySQLDriverCS.MySQLCommand("DROP TABLE IF EXISTS test.mysqldrivercs_test",conn); ~m7 yZjj
   cmd.ExecuteNonQuery(); g#rTR\f
   cmd.Dispose();

aZEH7L "9U
   cmd = new MySQLDriverCS.MySQLCommand("CREATE TABLE test.mysqldrivercs_test("+ MB2paRvKN
    "SettingID tinyint(3) unsigned NOT NULL auto_increment,"+ n #7o=c9+
    "SettingValue text, "+ N-bZs[*
    "PRIMARY KEY  (SettingID), UNIQUE KEY SettingID(SettingID),  KEY SettingID_2 (SettingID))"+ V?33xH
    " TYPE=MyISAM COMMENT='MySQL test table'",conn); g zJr ?
   >!pr6BKB6
   cmd.ExecuteNonQuery(); SC vCm\
   cmd.Dispose();

下面是insert:   {O) ti%V$ 

方法原型： :sGA6V

public MySQLInsertCommand( K$~.W<p9Ek
   MySQLConnection conn, \1QtRI6i!B
   object[,] FieldsAndValues, RWdlqqba
   string Table xYQS9"}?
);

string Value = "Value"; RVN5^>r9a\
   int SettingID = 1;

   |p?~~2X
   new MySQLInsertCommand(conn, BaTKMN9'
    new object[,] {{"field1",SettingID},{"field2",Value}}, r9B ^f6vA#
    "mysqldrivercs_test" kCT|YJY
    );

mysqldrivercs_test 是表名 S9 8,*  :/f|OJi

下面是update

方法原型： BFKN+|8b5"
public MySQLUpdateCommand( &r=["j h
   MySQLConnection conn, gwKR>zJ .#
   object[,] FieldsAndValues, vqoEZ2
   string Table, @.?$*`
   object[,] WhereParamFields, V,k2tL4
   string[,] WhereNoparamFields '%J,C4Um4
); +P){b<Zc" IWazX A

   Value = "Value2"; HoNCK6i
   new MySQLUpdateCommand(conn, dr,xR;Jl0
    new object[,] {{"SettingValue",Value}}, 'k~Tp9&V
    "mysqldrivercs_test",  u^=?~l
    new object[,] {{"SettingID","=",SettingID}}, ]6b0+) &
    null E8 tO::e
    );

下面是select

   DataTable dt = new MySQLSelectCommand(conn, ?t@q8Qx{oY
    new string[] {"SettingID","SettingValue"}, K2A)~mI
    new string[] {"mysqldrivercs_test"}, Y!yb V
    new object[,] {{"SettingID","=",SettingID}}, wcK^AI:#R
    null, ~.jYHHX
    null O1"F?]R
    ).Table; bD 3^
   string storedValue = dt.Rows[0]["SettingValue"].ToString(); UpU5Ex^27
 

   下面是delete D{3 % ~=
   new MySQLDeleteCommand(conn,"mysqldrivercs_test",new object[,] {{"SettingID","=",SettingID}},null);

关闭链接:

    conn.Close();