By mistake I used SQL tables and as well as written c sharp whole code, but the requirement is ms access database. Actually, my application is web store, according to category name to display their products.
I used two tables:
1. Category
2. Product
Category table has been following fields
CategoryID
CategoryName
Product table has been following fields
PID
ImageName
ProductName
Price
CategoryID
I have stored procedure to get results according to category and their products.
ALTER PROCEDURE [dbo].[usp_GetProductsForCategories]
AS
SELECT * FROM Category WHERE CategoryID IN
( SELECT CategoryID FROM Product )
SELECT p.PID , p.ImageName,p.ProductName,p.Price,p.CategoryID FROM Product p
Design coding
I used nes ...
Go to the complete details ...