Very straight forward, but I'm having performance problems, so I need help here:
There are two tables ( i can provide table schemas and sample data) that are used for this asp/vb.net page, in a one to many relationship. There are two current versions of this page, one using a join, one using a union between the two tables.
Basically, there is a product ID and product description field in both tables...table 1 has a product_ID that can have many matching product_IDs in table 2. I need a page created that will have a textbox on the left of the page with all the product_ids from table 1, and on the right, there will be dropdownlists for each matching product_id from table 2. Remember, each product_ID in table 1 may have 1 OR MORE matching product_IDs in table 2. Users must be able to select the correct product form the dropdownlist to match a corresponding product_ID.
I can send a sample of what I have now...It takes too long to load, and I still need the save option when users save changes to the dropdownlists.
Please let me know if you understand and are able to provide this service.
It is not a hard project, and for the right coder, it should only take an hour or two to take my existing work and make it more efficient; I am still learning ASP.NET, so I know someone with more experience will be able to optimize my code.
Thanks!
Please write back with any questions, and if you do NOT understand, please ask.
## 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--
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 with VB, NOT C#!!!