Question

Consider the above Tables Design an ASP.Net Page as shown below

Create a Stored Procedure SPS_Insert_New_Item in MS SQL Server database (that you created in Question No. 1) to add a new Item to the Database Table.

Next, Call the Stored Procedure from ASP.Net Page in the Add Item Click Event. While saving Data to the Table, make sure that User has selected the Item Category and Sub-Category. Also, Item Name is not null or empty and Price is greater than 0 and not null. If all the validations are passed, then the new item record should be saved to database.

Take Screen shots and add to the answer Sheet of (1)- When Validations are failed; (2)- When Validations are passed; (3)- The Database Table View shows that the Record is stored for Database Table successfully.

Also, implement the Exception Handling Mechanism provided by C# language. Copy-Paste Code of .aspx and .aspx.cs files to your Answer Sheet.

tblItemsCategory Allow Nulls DESKTOP-E3H3DJ2\S...o.tblltemCategory* x Column Name Data Type ItemCategorySID int Category Title varchar(50) Sample Data is DESKTOP-E3H3DJ2\S...o.tblltemCategory X ItemCategory... Category Title Softwares 2 Hardwares 3 Stationary 1 ItemsScubCategory Allow Nulls DESKTOP-E3H3DJ2\...temsScubCategory X Column Name Data Type ItemSubCatSID int SubCatTitle varchar(50) ItemCatSID int Sample Data DESKTOP-E3H3DJ2\...temsScubCategory X ItemSubCatSID SubCatTitle ItemCatSID 1 Operating Systems 1 2 Laptops 2 3 CPUs 2 4 Books 3 5 Printers 2 6 Scanners 2 localhost:49939/Default.aspx + localhost:49939/Add Newltem.aspx license plate recog... Saif Ur Rehman, Ph... Apps ScholarOne Manus.. Emg Add New Item V Category Sub-Category Item Name Price Add Item New Item