Making a simple webshop in SQL and C# , need heeeelp RRS feed

  • Question

  • Hey guys

    For my school I am making an assignment where I have to create a webshop, a very simple one. In SQL I have created two tables, one with the different categories, and one with all the goods the store sells. 
    Now I need to make a C# program that can delete, add, and edit the goods, that only communicates to Console. And then I have to make a program or method that can calculate the total of the goods that the costumer might want, also in C#.

    I am stuck , only got to the SQL part. I am new to this. Can anyone maybe help me or point me in a direction?

    Thank you so much
    Thursday, April 16, 2020 6:46 AM

All replies

  • Hi FefeYes,

    Thank you for posting here.

    We usually don’t help others do a complete project or do homework, this is actually harmful to you.

    We are more inclined to answer specific questions, such as how to use C # to operate the database, and how to filter out part of the data from many data according to specific conditions.

    You can start your own project, and when you encounter a specific problem, you can post it on this forum, we will be happy to answer it for you.

    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 16, 2020 9:03 AM
  • delete, add, and edit the goods

    That is typically called Create, read, update and delete (CRUD). If you search for CRUD you will get many articles and such.

    Look at the System.Data Namespace. That shows many relevant classes. You can find many articles about them.

    Also see Entity Framework (EF). There are very many articles about that. It takes more time to learn but it is what the professionals use. It is definitely worth learning.

    It is largly a matter of personal preference whether you start by learning EF or the lower-level classes.

    For the future you should post questions in the appropriate forum. Databases are not a C# question. There are many forums for using SQL Server in programs. If you are not sure what forum is best then ask in Msdn forums - Where is the Forum For…?.

    Sam Hobbs

    Thursday, April 16, 2020 7:16 PM