C#连接mysql的方法【基于vs2010】

//define the connection reference and initialize itMySql.Data.MySqlClient.MySqlConnection msqlConnection = null;msqlConnection = new MySql.Data.MySqlClient.MySqlConnection("server=localhost;user id=UserName;Password=UserPassword;database=DatabaseName;persist security info=False");//define the command referenceMySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();//define the connection used by the command objectmsqlCommand.Connection = this.msqlConnection;//define the command textmsqlCommand.CommandText = "SELECT * FROM TestTable;";try{ //open the connection this.msqlConnection.Open(); //use a DataReader to process each record MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); while (msqlReader.Read()) { //do something with each record }}catch (Exception er){ //do something with the exception}finally{ //always close the connection this.msqlConnection.Close();}