Consider the following information to solve the problems given below:

a) Build Windows Forms Design for above information using appropriate Controls.

b) A function named void RetreiveCategories() to display list of categories from Items_Category Table and display in Control cmbPrograms comoboBox(ADO.NET).

c) A function int InsertData() that inserts the values of the controls of above mentioned table into the Items Table and returns 1 if the insertion is success, otherwise returns 0(ADO.NET)?

d) Show Items_Name and Barcode in Gridview(ADO.NET).

Item_Categories * 7 Category_ID Category_Name Active Date Added Items * 7 Item_ID Category_ID Barcode Item_Name Purchase_Price Sale Price Opening Stock Current_Stock Active Date Added Table Name: Items Constraints Primary Key Foreign Key Field Name Data Type Item ID int Category_ID int Barcode Varchar(50) Items Name Varchar(50) Purchase_Price Varchar(50) Sale_Price Varchar(50) Opening Stock Varchar(50) Current_Stock Varchar(50) Active Varchar(1) Date Added Datetime Table Name: Items_Category Field Name Data Type Constraint(s) Category_ID Int Primary Key Category_Name Varchar(50) Active Varchar(1) Date_Added Datetime Item_Categories * 7 Category_ID Category_Name Active Date Added Items * 7 Item_ID Category_ID Barcode Item_Name Purchase_Price Sale Price Opening Stock Current_Stock Active Date Added Table Name: Items Constraints Primary Key Foreign Key Field Name Data Type Item ID int Category_ID int Barcode Varchar(50) Items Name Varchar(50) Purchase_Price Varchar(50) Sale_Price Varchar(50) Opening Stock Varchar(50) Current_Stock Varchar(50) Active Varchar(1) Date Added Datetime Table Name: Items_Category Field Name Data Type Constraint(s) Category_ID Int Primary Key Category_Name Varchar(50) Active Varchar(1) Date_Added Datetime