How to Display Data from MySql Database on DataGridView in C#

Question

Hi Guys

I really need some help here, I have used the following to code to display information from my database into visual Studio DataGridView but it displays the attributes and not the actual data values. I don't understand why:

        public void BindCustomerDataToGrid()
        {

           
            MySqlConnection cn = new MySqlConnection("SERVER=localhost;" + "DATABASE=clientmanagement;" + "UID=root;" + "PASSWORD=qwerty;");
            {
                DataTable customerTable = new DataTable();
                string query = "select c.customer_name, c.phone, a.ytd_sale from customer c, account a where c.customer_id = a.customer_id;";
                MySqlDataAdapter dataAdaptar = new MySqlDataAdapter(query, cn);
                MySqlCommandBuilder cmd = new MySqlCommandBuilder(dataAdaptar);

              
                customerTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
                dataAdaptar.Fill(customerTable);
                BindingSource customerDataBindingSource = new BindingSource();

                customerDataBindingSource.DataSource = customerTable;
                dataGridView1.DataSource = customerDataBindingSource;             
              
              
            }
        }

Your Help will be really much appreciated.