|
Hello,
I need help in VB.NET.
I'm developing an asset management application.
assets have different types (Computer), and a label initial for this type (PC).
When the user wants to add an asset, he/she should select the type name (Computer) from a dropdownlist and the textbox that is under that dropdownlist will show the label initial (PC).
What I want the program to do is display automatically PC + the number of assets added for that specific type. (PC0001) if it was the 1st computer added and (PC0002) for the 2nd ..etc.
Note that the asset label initial and the asset number = label number which is the primary key of the asset table.
I managed to retreive the label initial into the textbox. But how can I add the number of that asset for each asset type? Should there be a property in the database to hold this value?
Solving this would make things very much easier. I would really appreciate if some one would help :)
|