C#连接mysql数据库，并查询，C#查询mysql数据库

用c#连接MySQL数据库需要用到mysql-connector-net，这个组件网上查找就可以下载，安装直接按next，按默认路径安装。

using System;
using System.Data;
using MySql.Data.MySqlClient;

namespace mysql_test
{
	class Program
	{
		private static bool IsCanConnectioned = false;
		
		public static void Main(string[] args)
		{
			
			Console.WriteLine("开始测试连接mysql数据库!");
			//以下三种方式都是可以的
			//MySqlConnection connection=new MySqlConnection("Host =localhost;Database=TD_OA;Username=root;Password=myoa888;Port=3336");
			//MySqlConnection connection=new MySqlConnection("Server=127.0.0.1;Database=TD_OA;Uid=root;Pwd=myoa888;Port=3336");
			MySqlConnection connection=new MySqlConnection("server=localhost;user id=root;password=myoa888;database=TD_OA;Port=3336");
			try
            {
                //Open DataBase
                //打开数据库
                connection.Open();
                IsCanConnectioned = true;
                Console.WriteLine("连接成功1！");
                String query1="select * from user";
                MySqlCommand mySqlCmd=connection.CreateCommand();
             
                mySqlCmd.CommandType=CommandType.Text;
                mySqlCmd.CommandText=query1;
                MySqlDataReader mySqlReader;
                mySqlReader=mySqlCmd.ExecuteReader();
                while(mySqlReader.Read()){
                	Console.WriteLine(mySqlReader[4].ToString());
                	Console.WriteLine(mySqlReader["USER_NAME"].ToString());
                }
               
			}
            catch
            {
                //Can not Open DataBase
                //打开不成功 则连接不成功
                IsCanConnectioned = false;
            }
			if(IsCanConnectioned){
			Console.WriteLine("连接成功2！");
			}
			
			
			connection.Close();
			
			
			Console.Write("Press any key to continue . . . ");
			Console.ReadKey(true);
		}
	}
}