C# 应用 mysql数据在datagrideview上显示

核心代码如下
1、引用动态链路库文件
2、添加dataGridView1控件与botton控件

using MySql.Data.MySqlClient;
 private void button1_Click(object sender, EventArgs e)
        {
            GetMessage();
        }    

       private DataTable GetMessage() {
            string P_Str_ConnectionStr = string.Format("server={0};user id = {1};password = {2};port = {3};database=jeecg;pooling = false;", "10.8.100.156", "xixismile","12345678", 3306);
            string P_Str_SqlStr = string.Format("select id as 序列ID,create_name as 用户名 from beijian_record");
            MySqlDataAdapter adapter = new MySqlDataAdapter(P_Str_SqlStr,P_Str_ConnectionStr);
            DataTable P_dt = new DataTable();
            adapter.Fill(P_dt);
            this.dataGridView1.DataSource = P_dt;
            return P_dt;
        }