0

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

3
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by xanawa
0

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

0

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.

0

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

yes

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.