it seems to me that for one dataGridView, it can only be used to display for only ONE table from a database, is it true? I want to implement something such that when user press different buttons, it will display on the dataGridView different table values. Is that possible?

When I implement the Fruits button alone, it is able to display the Fruit values.
When I implement both the Fruits and Bread buttons, it is only able to display the Bread values.

private void Fruits_button_Click(object sender, EventArgs e)
{
this.allfruitsTableAdapter.Fill(this.productcatalogDataSet.allfruits);
}

private void Bread_button_Click(object sender, EventArgs e)
{
this.allbreadsTableAdapter.Fill(this.productcatalogDataSet1.allbreads);
}