database to select item to view sub category C#

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(1,1) 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(1,1) 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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mukesh Nayak8y ago
Accepted 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(1,1) 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(1,1) 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 Raja8y ago
C sharp codes steps