I have a below table structure. I am using c# and asp.net to achieve this but did not get success.


I have created userid and associate category and items with it. I would like to create a form below for data entry when user log in. I have also associated items with the user therefore only associated items would appear in the form. If a user has 7 items, 7 items would be appeared. the numbers below are the sales user is entering in different cities, the user would save the data in above table, this can be done with the textbox and grid but I am unable to create the form.

User ID. 111111 Category. Data 1
Cities Item-1 Item-2 Item-3

City 1 100 50 30

City 2 30 35 70

City 3 50 70 30