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

1、用MySQLDriverCS连接

: ((();

: (MyConString);

(query, MyConnection);

+

                                 "SERVER=localhost;" +

                                 "DATABASE=inv;" +

                                 "UID=root;" +

                                 "PASSWORD=831025;" +

                                 "OPTION=3";

          OdbcConnection MyConnection = new OdbcConnection(MyConString);

OdbcDataAdapter oda = new OdbcDataAdapter("select * from customer ", MyConnection);

DataSet ds = new DataSet();

          oda.Fill(ds, "employee");
          this.dataGridView1.DataSource = ds.Tables["employee"];

*/

 

           MyConnection.Close();

        }

    }

}