I need an ASP.NET web page with a select box to filter what is displayed on the grid.
1. Display data in grid from SQL Server 2005 table
(The table name is transaction.)
On the grid, I want to see the following fields:
TransactionID, TransactionDate, TransactionDescription, UnitPrice, UnitsOrdered, EmployeeName *
2. Allow sort and 10 records per page.
3. At the top right corner of the screen I need a select box with a list of employees (provided in 2nd table)
I want to be able to filter the records by employee.
4. On the grid, I need a select button, when I click on the select button I want to see a summary page with the all the transaction information.
I have attached an MS Access database with both tables.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
ASP.NET, C#, Visual Studio 2005, SQL Server 2005