I have two datagridviews:
-> dgvMenu
-> dgvMenuItem

dgvMenu:
will display all the menus that are in the database.

dgvMenuItem:
Will display all the items of the menu selected in the dgvMenu.


How can i get the items of the menu?

My DataBase
tblMenus:
-> ID (PK)
-> Name
-> Description
-> DateAdded

tblMenuItem
-> ItemID (FK)
-> MenuID (FK)

tblItems
-> ID (PK)
-> Name
-> Type
-> Price
-> Picture

Your terminology is a bit confusing. Are we talking about menus in an application or menus from a restaurant?

1. Create a select statement to get all the Menus to 1st dgv.
2. Create a select statement with a where clause depending of the dgv1 selection.

In both use DataTables, which can be bound to the dgv controls. As simple as that.

Your terminology is a bit confusing. Are we talking about menus in an application or menus from a restaurant?

yes

So it is appli and resto? Because you said yes=true?

forget it!! : ) i figured it out alone thx anyway