C#连接MySQL查看数据

C#连接MySQL查看数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            string str = "user=root;pwd=****.;server=127.0.0.1;database=数据库名;";
            MySqlConnection conn = new MySqlConnection(str);
            try
            {
                conn.Open();
                Console.WriteLine("连接成功！");
                
                //设置查询命令（可自由输入sql查询语句）
                MySqlCommand co = new MySqlCommand("select * from 表名;",conn);
                
                //创建查询结果读取器，执行查询，并将结果返回给读取器
                MySqlDataReader re = co.ExecuteReader();
                if (re.HasRows)
                {
                    while(re.Read())
                    {
                    	//读取三列数据
                        Console.WriteLine(re[0]+"  "+re[1]+"  "+re[2]);
                    }
                }
                re.Close();
            }
            
            catch(MySqlException e)
            {
                Console.WriteLine(e.Message);
            }
            finally
            {
                conn.Close();
            }
        }
    }
}