C#操作Mysql

首先下载下来Mysql.data.dll

然后将其参照到工程里。

......

using MySql.Data.MySqlClient;

......

试验用代码：

MySqlConnection myConn = new MySqlConnection();
   MySqlCommand myCom = new MySqlCommand();
   try
   {
    myConn.ConnectionString = "Server=serverIP;Database=test;Uid=user; Pwd=password;";
    myConn.Open();
    myCom.CommandText = "select * from products";
    myCom.Connection = myConn;
    MySqlDataReader myReader = myCom.ExecuteReader();
    Console.WriteLine("Old result is :");
    while(myReader.Read())
    {
     Console.WriteLine(myReader[0] + "   " + myReader[1]);
    }
    myReader.Close();
    Console.WriteLine("Now update start.");
    myCom.CommandText = "update products set productName = \"new name\" where productCD = 1";
    myCom.ExecuteNonQuery();

    Console.WriteLine("New result is :");
    myCom.CommandText = "select * from products";
    myReader = myCom.ExecuteReader();
    while(myReader.Read())
    {
     Console.WriteLine(myReader[0] + "   " + myReader[1]);
    }
   }
   catch(Exception ex)
   {
    Console.WriteLine(ex.Message);
   }
   finally
   {
    myConn.Close();
   }