//load datagridview products
                MySqlDataAdapter ada = new MySqlDataAdapter("select products.kode_Barang,category.name,brands.name,products.name,products.qty,products.harga FROM products INNER JOIN category on products.id_category = category.id_category INNER JOIN brands ON products.id_Brands = brands.id_brands", con);
                //delete products, category, brands from products INNER JOIN category inner join brands where products.id_products = category.id_category and products.id_products = brands.id_brands
                DataSet dt = new DataSet();
                ada.Fill(dt);

                foreach(a as DataRow in dt.tables[0].Rows) {
datagridview1.rows.add(a("namatable") dst)
}