c# 连接MySql数据库的两种方法

1、用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"
, "inv"
, "root"
, "831025"
).AsString);
           
conn.Open();
 
           
MySQLCommand
commn = new
MySQLCommand
("set names gb2312"
, conn);
           
commn.ExecuteNonQuery();
 
           
string
sql = "select * from exchange "
;
           
MySQLDataAdapter
mda =