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

the following information to solve the problems given below: Item_Categories * Category_ID

[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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!