C#中连接MySQL数据库

这篇文章将通过两种方式来连接到MySQL数据库，也许会有很多种连接的方法，但是我们在这里只用其中的两种：
一种是第三方写的类：ByteFX，另一种是通过OdbcConnection来完成。

首先必须确定你的机器安装了MySQL,并且正确运行

ByteFX.Data.MySqlClient;

...
...
...

myConnectionString ="DSN=MySQL;UID=root;PWD=root";
MySqlConnection myConnection = new MySqlConnection(myConnectionString);
string myInsertQuery = "Select * from Authors";
MySqlCommand myCommand = new MySqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
MySqlDataReader objReader = myCommand.ExecuteReader();
int nResultCount = 0;
while (objReader.Read())
{
++nResultCount;
}

另一种方法就是通过Odbc来完成：

using System.Data.Odbc;
...
...

string myConnectionString ="DSN=MySQL;UID=root;PWD=root";
OdbcConnection MyConn;
OdbcCommand MyCmd = new OdbcCommand();
MyConn = new OdbcConnection(myConnectionString);
MyConn.Open();
MyCmd.Connection = MyConn;
StringBuilder SQL = new StringBuilder();
SQL.Append("SELECT ");
SQL.Append("*");
SQL.Append("FROM ");
SQL.Append("Authors");
MyCmd.CommandText = SQL.ToString();
OdbcDataReader result = MyCmd.ExecuteReader(CommandBehavior.CloseConnection);
int nResultCount = 0;
while (result.Read())
{
++nResultCount;
}

<script language="javascript" src="http://count.dbk2008.com/?dbUser=baicle" type="text/javascript"></script>