Develop a build document and a demo VB2008 application that connects to an MSSQL 2000 database on the same intranet. The documentation should allow an engineer to build the application and expand the application as the data set grows.
The application will allow the user to filter rows from 3 - 5 tables, 5 ??" 10, and columns within the same DB.
The application will compile the filtered data and export that data to a Microsoft Excel 2007 file.
One table stores the path and file name of pictures associated with the data that is stored on the server’s hard drive. The photos also need to be exported to the Excel file.
The application should filter on a primary key.
The application should return a maximum number of results (500). The program will calculate the numbers of results and if it exceeds the set maximum an error with the total will be returned.
?
The application should ask the user for an IP of the server to connect and a username and password to authenticate to windows and sql. The windows account will have read access to the photos directory.
The data set is not very large. Information such as occupation, date of birth, date created, employee ID, badge number, photo, first name, last name, and location, are the typical columns in the tables.? ?
Will submit an example database and photos.
?
? ? ? ? ?