design help

Question

hi everyone i am new to c# i just want some advice no code i want to do the code myself. i want to design a simple program that  displays stock that i have and if i book something out it must automaticly subtract it from the stock and display the selected stock on a page that i can print  and i must aLSO BE ABLE TO print the stock that is still left . i must also be able to add new stock items and qty's . Can someone please tell me whati need and how to do it any help will be appreciated

Answer 1

As the others suggest one of the first things to do is to define your database. You need to define what tables you need and what fields you need in each table. It is not easy to explain how to decide what tables you need; it would help if you buy a book or some books that explain all that. A good beginner book that includes databases would help.
 
Something you can do without a book is to look at the articles in this site about database programming. I suggest reading my article Database Table Update in a DataGridView without Writing Code.

Answer 2

Hi

I think you have concentrate on designing part first as what items you want to display like Stock. Stockbooked,Stock Left and Quantity on the webpage. Then design the database based on the objects available .It's a good programming to display required objects only on the  screen what you need from the database.

[SPAM REMOVED]

Answer 3

I'd suggest using SQL if you want to store your database on a server, SQL Compact Edition or SQLite if you're only interested in storing the database on the local drive that the app will be running on.
 
Please remember to mark as answer if you found this helpful.

Answer 4

Hi tanks for your help
 yes i think i want to store it in an data base or in a file of some sorts but i think a data base should be the right thing to do

Answer 5

Are you wanting to store this information in a database?