asp.net/vb page optimization-immediate help needed!

PLEASE TAKE A LOOK AT THE ATTACHED ZIP FILE! THIS WILL GIVE YOU THE CURRENT CODE AND EXACTLY WHERE THIS PAGE IS AT RIGHT NOW! Please do not ask me for the code, it is already attached! The current issues are:

1. the page loads too slow
2. the changes need to be saved back to the database.

Please only reply if you can provide this solution within a day or two! It is very straight forward, but I need help. The zip file contains both the aspx as well as the code behind file, both pasted into in 1 text file. The connections are to oracle, but if you want to run this against a local SQL server, all you need to do is change the namespace to sqlclient from oracleclient...thanks!

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.

What are you paying?

Hi,
I have more than 1 year of experience in ASP.NET and I can help you with this. If you are interested, please contact me at shahidanwar77@yahoo.com


Regards