C# Winform 连接MySql数据库

创建一个 加载数据库信息的函数

public void Database_connect()
        {
            //与数据库连接的信息
            MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
            //用户名
            builder.UserID = "root";
            //密码
            builder.Password = "123456";
            //服务器地址
            builder.Server = "localhost";
            //连接时的数据库
            builder.Database = "pad14301";
            //定义与数据连接的链接
            connection = new MySqlConnection(builder.ConnectionString);

            
        }

然后在建一个 操作的命令

            try
            {
                //打开这个链接
                connection.Open();
                //新建一个指令 ，把Sql 语句 放进去
                MySqlCommand mySqlCommand = new MySqlCommand(s, connection);
                

//方法一：

                
                //新建一个 MySqlDataAdapter
                //新建一个 DataSet

                ad1 = new MySqlDataAdapter(mySqlCommand);
                ad1.Fill(set1, "robot_detail");

                //dataGridView 是否自动匹配列
                dataGridView1.AutoGenerateColumns = false;

                //将结果绑定到databiew
                dataGridView1.DataSource = set1;
                dataGridView1.DataMember = "robot_detail";

                if (dataGridView1.Rows.Count == 0)
                {
                    MessageBox.Show("暂无子数据!");
                }

//方法二： 读取，然后遍历，拿出来
                //建一个 reader
                /* MySqlDataReader dr = mySqlCommand.ExecuteReader();
                 while (dr.Read())
                 {
                     MessageBox.Show("姓名：" + dr[1].ToString() + ",性别：" + 
                     dr[2].ToString());
                 }*/
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                //最后关闭连接
                connection.Close();
            }