.net 訪問MySQL資料庫

用MySQLDriverCS串連MySQL資料庫  

    先下載和安裝MySQLDriverCS，地址：

    http://sourceforge.net/projects/mysqldrivercs/

    在安裝資料夾下面找到MySQLDriver.dll，然後將MySQLDriver.dll添加引用到項目中

    註：我下載的是版本是 MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe

 

主要代碼如下：

   using MySQLDriverCS;

 

　　　　try
            {
                MySQLConnection conn = null;

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

                conn.Open();

 

                string sql = "select * from users ";

                MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);

 

                DataSet ds = new DataSet();

                mda.Fill(ds, "table1");

 

                this.dataGridView1.DataSource = ds.Tables["table1"];

                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }