Hi all,
I used to program asp.net back at 2.0 i think it was, i have had a long break from programming in general and am now tryin to get back into it with a small (in my head :P) project.
I have a band and i want to make a small inventory manager for our merchandise (cd's, tshirts, stickers etc.) Im really using this as a way to relearn asp, but i think it will be a helpful little tool as well hopefully. I want to be able to show how much stock of each item i have, i want to be able to add and remove stock ITEMS(so a new cd for example), and also increase and decrease stock LEVELS(to be used for selling stock for example)
I have a test mySQL database, and i can connect to it fine, and i have a page that can display a tables contents, but im not sure how to handle multiple stock items within the database. Is it common to just have a seperate table for each stock item? so a table for tshirts, that has fields like [color],[size],[sex],[design] etc? because this s ...
Go to the complete details ...