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
Jump to PostYour terminology is a bit confusing. Are we talking about menus in an application or menus from a restaurant?
Jump to Post1. 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?
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.