这篇文章将通过两种方式来连接到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>