I am coming up to finishing an inventory project and I've saved this bit until last. Part of the system tracks a 10 x 10 grid rack and stores information in a database as to whether each grid reference is empty or has a container in it. The requirement is to show this information of 100 grid positions as a graphical grid map. The result set in the picture below only shows the first two rows of the grid, but hopefully it shows the idea.
I need to work out a way of taking the results from my query on the left and producing some sort of graphical representation on a web page. I suppose could create 100 images in a big table, loop through the dataset and set each image to ON or OFF based on the dataset but I was hoping there may be a more elegant way.
I have no experience of graphical modules in ASP.NET and I hoped ...
Go to the complete details ...