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; }