.net连接MySql ，获取中文字段乱码

 注意： 动软代码生成器项目里的MySql.Data.dll可以连接win2008 64位系统的Mysql，使用ByteFX.MySqlClient.dll连接winxp 32位系统的Mysql。

static void Main(string[] args)

        {
            Console.WriteLine("--------");

            string myconn = "Database='prison';Data Source=192.168.1.33;User ID=root;Password=admin;";
            //需要执行的SQL语句
            string mysql = "SELECT * from alarmmessage";
            //创建数据库连接
            MySqlConnection myconnection = new MySqlConnection(myconn);
            MySqlCommand setformat = new MySqlCommand("set names gb2312", myconnection);
            myconnection.Open();
            setformat.ExecuteNonQuery();
            setformat.Dispose();
            //创建MySqlCommand对象
            MySqlCommand mycommand = new MySqlCommand(mysql, myconnection);
            //通过MySqlCommand的ExecuteReader()方法构造DataReader对象 
            MySqlDataReader myreader = mycommand.ExecuteReader();
            while (myreader.Read())
            {
                Console.WriteLine(myreader.GetInt32(0) + "," + myreader.GetString(1) + "," + myreader.GetString(2) + "," + myreader.GetString(3) + "," + myreader.GetString(4) + "," + myreader.GetString(5) + "," + myreader.GetString(6));
            }
            myreader.Close();

            myconnection.Close();

            Console.WriteLine("--------");
            Console.Read();
        }