Fórum Pesquisando (Filtrando) dados em um DataGridView CSharp e MYSQL #497019

 private void CarregarDados()
        {
            {
                try
                {
                    string MyConnection2 = "datasource=localhost;port=3306;username=root;password=";
                    //Exibir Reristros
                    string Query = "select * from dados.contatos;";
                    MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                    MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
                    //  MyConn2.Open();                  
                    MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                    MyAdapter.SelectCommand = MyCommand2;
                    DataTable dTable = new DataTable();
                    MyAdapter.Fill(dTable);
                    gContatos.DataSource = dTable; // Atribuir o Objeto dTable Para Preengrer o Grid      
                    // Fechar Minha Conexao
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                gContatos.Sort(gContatos.Columns[1], ListSortDirection.Ascending);
                gContatos.Columns[0].Visible = false;
            }
        }