I need a small web app that keeps track of Software Name, Software Version and Serial Number, Owner, Activation Code(if any) and Date of Activation(if any). I would like the program to be written in ASP with a SQL backend database to hold all the data. There would be 3 main pages and they are as follows:
1. Main Start Page ??" Choice to either lookup serials or enter a new serial
2. Search Page ??" Page where you can type in name, then select submit and results are returned (if no input or fields are left blank, the whole list is returned in #3
3. Results Page ??" After lookup, the page that displays the results of the search. Each column will have a header that if clicked will sort that column.
Database layout as follows:
Fields or Columns = software_name, software_ver, product_id, owner, act_code, date_of_act
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
This needs to run on a Win2k Server running IIS with the latest service packs. Also, please design for IE5+.