Question: [Use C# (c sharp programming) Visual Studio] Coding plus screenshots Consider the following information to solve the problems given below: Item_Categories * Category_ID Category_Name Active
![[Use C# (c sharp programming) Visual Studio] Coding plus screenshots Consider](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f3c6e853771_19966f3c6e7c5cff.jpg)

[Use C# (c sharp programming) Visual Studio] Coding plus screenshots Consider the following information to solve the problems given below: Item_Categories * 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 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). 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 (ADO.NET)? d) Show Items_Name and Barcode in Gridview(ADO.NET). [Use C# (c sharp programming) Visual Studio] Coding plus screenshots Consider the following information to solve the problems given below: Item_Categories * 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 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). 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 (ADO.NET)? d) Show Items_Name and Barcode in Gridview(ADO.NET)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
