C#串連MySql資料庫的方法

 用MySQLDriverCS串連MySQL資料庫

    先下載和安裝MySQLDriverCS，地址：

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

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

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

    using System;

    using System.Collections.Generic;

    using System.ComponentModel;

    using System.Data;

    using System.Data.Odbc;

    using System.Drawing;

    using System.Linq;

    using System.Text;

    using System.Windows.Forms;

    using MySQLDriverCS;

    namespace mysql

    {

        public partial class Form1 : Form

        {

            public Form1()

            {

                InitializeComponent();

            }

 

            private void Form1_Load(object sender, EventArgs e)

            {

 

            MySQLConnection conn = null;

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

  

            conn.Open();

            //以下兩行很重要，不然中文顯示為亂碼

            MySQLCommand commn = new MySQLCommand("set names gb2312", conn);

            commn.ExecuteNonQuery();

 

            string sql = "select * from exchange ";

            MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);

 

            DataSet ds = new DataSet();

            mda.Fill(ds, "table1");

 

           DataGridView1.DataSource = ds.Tables["table1"];

            conn.Close();

            }

        }

    }