database to select item to view sub category C#

Question

hai friends....

database to view listbox item
list box select to sub category view
Ex

briyani

soup

chips

starters

juices

Juices select to other form open to lemon juice,apple juices open to listbox view

Mukesh Nayak · Answer

Hi Bharathi For above requirement we can have 2 table in database. One(FoodCategory) for storing main categories such as soups chips  biryani etc. Other(FoodSubCategory) for storing sub categories such as for soup the table will have veg soup  chicken soup  tomato soup . For briyan it will have checken biryani etc. GO /****** Object: Table [dbo].[FoodCategory] Script Date : 12/25/2017 12:38:32 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FoodCategory]( [ID] [ bigint ] IDENTITY(11) NOT NULL  [ Name ] [nvarchar](200) NULL  CONSTRAINT [PK_FoodCategory] PRIMARY KEY CLUSTERED ( [ID] ASC ) WITH (PAD_INDEX = OFF  STATISTICS_NORECOMPUTE = OFF  IGNORE_DUP_KEY = OFF  ALLOW_ROW_LOCKS = ON  ALLOW_PAGE_LOCKS = ON ) ON [ PRIMARY ] ) ON [ PRIMARY ] GO /****** Object: Table [dbo].[FoodSubCategory] Script Date : 12/25/2017 12:38:32 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FoodSubCategory]( [ID] [ bigint ] IDENTITY(11) NOT NULL  [CategoryID] [ bigint ] NULL  [ Name ] [nvarchar](200) NULL  CONSTRAINT [PK_FoodSubCategory] PRIMARY KEY CLUSTERED ( [ID] ASC ) WITH (PAD_INDEX = OFF  STATISTICS_NORECOMPUTE = OFF  IGNORE_DUP_KEY = OFF  ALLOW_ROW_LOCKS = ON  ALLOW_PAGE_LOCKS = ON ) ON [ PRIMARY ] ) ON [ PRIMARY ] GO ALTER TABLE [dbo].[FoodSubCategory] WITH CHECK ADD CONSTRAINT [FK_FoodSubCategory_Category] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[FoodCategory] ([ID]) GO ALTER TABLE [dbo].[FoodSubCategory] CHECK CONSTRAINT [FK_FoodSubCategory_Category] GO Regards Mukesh Nayak

Bharathi Raja · Answer

C sharp codes steps