You just need to query to
Product Table and pass logged in
User Id as a parameter to the query.
The following query is something what you need.
SELECT ProductID, Productname, category
FROM
ProductTable
WHERE
UserId = @LoggedInUserId
You need to use
ADO.NET
objects and use
SQLCommand
Class and initialize that using this query.
You specify parameter and pass the Logged in
User Id
as a parameter.
Refer -
Adding Parameters to Commands[
^]
For
User Id
, you can use
Session to store and retrieve.