hey guys, i am trying to program an auction in C#, using Microsoft SQL Server 2012. i have a table of users with all of their details, and a table of goods with their main price. users should be able to price the goods in their profile, and then the admin of application can check the total results of what they have done in one grid view, it should be like an Excel sheet which has a name column , goods name column, and other columns count must be depended to number of codes of goods available. i mean a dynamic one.
but since i'm new to such stuffs i'm a little confused what is the best way to do this.
What I have tried:
i thought it's better to have another table which has the id of user, id of good, and users suggested price, but then i didn't know how to use them.
Submit an article or tip