Basic SQL Functions for pages in an VB ASP.net system

I WILL PROVIDE DETAILED INSTRUCTIONS (LINKS, FILES, DB SCRIPT) when bid is accepted. I am currently working on a project using Visual Studio 2003, and Microsoft SQL Server 2005. The code is written in VB, ASP.net. I need some basic SQL code implemented into 3 ASP.net pages I already have created. (Please use Internet Explorer to view these pages) The pages are as follows: 1. Vendor Search page. I would like you to look at my code, and organize it and clean it up to the most efficient fashion possible. This will return a row that contains Vendor Dave Smith's main information. If you click on the "View" checkbox in the datagrid, it will redirect you to our Vendor View page, which displays ALL information. Also, there are some small HTML changes that need to be made to the page 2. Client Search page I only have an HTML layout page, which is still under construction. I would like you to edit the HTML to make it similar looking to the Vendor Search page. However, keep all of current the fields. See my database script to make sense of where this information is coming from. This Client Search page should function just as the Vendor Search page does. When you click 'Search', it should redirect you to the Search Results page containing the datagrid, and from there you can click any of the 'view' checkboxes in the datagrid to redirect you to the client view page. 3. Client View Update, and Vendor View Update You have already seen the "Client View" and "Vendor View" pages we created. This displays ALL information about a person in text boxes, etc. which you can edit. What I need is a button at the bottom of both of these pages that will update records in the database based on any changes you made to the text boxes on the view pages. I NEED THIS COMPLETE BY THIS SUNDAY, OCTOBER 22nd AT THE LATEST.

## 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

Microsoft Visual Studio 2003 Microsoft SQL Server 2005 Windows XP

.NET ASP Engineering MySQL Odd Jobs PHP Software Architecture Software Testing SQL Visual Basic

Project ID: #3871049

About the project