Webpage for Data Upload to mySQL using VB.NET

Please quote Price and delivery Time. Project Title: Webpage for Data Upload to mySQL using VB.NET Deliverables: VB.NET ASPX page with: Company File Name to upload: _____________________ Address File Name to upload: _____________________ Start button [login to view URL] code for Start button Read data from the two uploaded text files and place data in mySQL database tables. One file being uploaded contains the Company Name and CompanyID The other file contains the Company Name and the Address information (but no CompanyID). The two files need to be matched on Company Name and the linking table needs to link the Company table and Address table. There are three mySQL database tables: Company, Address and CompanyAddress The CompanyID, CompanyName and Notes should be placed in the Company table. The data from the Address file should be placed in the Address table along with a new AddressID A record should be added to the CompanyAddress table which links together the Company record and the Address record. The Company Name in the Address data should be found in the Company Table to determine the CompanyID that goes in the CompanyAddress linking table. I am running: Microsoft Visual Studio Visual Basic 7.1.3088 Microsoft .NET Framework 1.1.4322 SP1 MySQL 4.1.11 ____________________________________________________________________________ Example of data that the program should produce in the CompanyAddress table. ____________________________________________________________________________ CompanyAddressID, CompanyID, AddressID, 1,5,3 2,6,2 3,8,1 ___________________________________________ Test Data - Upload Data file [login to view URL] ___________________________________________ CompanyID,CompanyName, Notes 5,"First Factory Corporation","Use this as the main address for all employees. Call before faxing information." 6,"Acme Apple Orchard","During apple season, leave message and followup within three days." 8,"Industrial Island Inc.","Alternate bridge on Route 33. Total charges can not exceed $10.00 per month. Check with foreman before ordering." ___________________________________________ Test Data - Upload Data file [login to view URL] ___________________________________________ CompanyName,LocationName,Address1,Address2,City,State,Zip,Country,County "Industrial Island Inc.","Headquarters","321 Main Street","Suite 120","River City","NY","10101-1234","U.S.A.","Appleton County" "Acme Apple Orchard","Aardvark Farm","2000 Aardvark Avenue","","Appleville","Alabama","70809-1011","U.S.A.","Altimont County" "First Factory Corporation","Plant 101","101 First Street","Foghorn Park","Ferndale","Kentucky","60606","U.S.A.","Fernquest County" _________________________________ Script that creates mySQL tables _________________________________ # Database : db1_dev2 DROP DATABASE IF EXISTS `db1_dev2`; CREATE DATABASE `db1_dev2` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `db1_dev2`; # # Structure for table address: # DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `AddressID` int(11) NOT NULL auto_increment, `LocationName` varchar(255) NOT NULL default '', `Address1` varchar(255) NOT NULL default '', `Address2` varchar(255) NOT NULL default '', `City` varchar(30) NOT NULL default '', `State` varchar(30) NOT NULL default '', `Zip` varchar(10) NOT NULL default '', `Country` varchar(30) NOT NULL default '', `County` varchar(100) NOT NULL default '', `Latitude` double(10,5) NOT NULL default '0.00000', `Longitude` double(10,5) NOT NULL default '0.00000', `Notes` text NOT NULL, PRIMARY KEY (`AddressID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; # # Structure for table company: # DROP TABLE IF EXISTS `company`; CREATE TABLE `company` ( `CompanyID` int(11) NOT NULL auto_increment, `CompanyName` varchar(255) NOT NULL default '', `Instructions` text NOT NULL, `Notes` text NOT NULL, PRIMARY KEY (`CompanyID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; # # Structure for table companyaddress: # DROP TABLE IF EXISTS `companyaddress`; CREATE TABLE `companyaddress` ( `CompanyAddressID` int(10) unsigned NOT NULL auto_increment, `CompanyID` int(11) NOT NULL default '0', `AddressID` int(11) NOT NULL default '0', PRIMARY KEY (`CompanyAddressID`,`CompanyID`,`AddressID`), KEY `AddressID` (`AddressID`), KEY `CompanyID` (`CompanyID`), CONSTRAINT `companyaddress_ibfk_1` FOREIGN KEY (`AddressID`) REFERENCES `address` (`AddressID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `companyaddress_ibfk_2` FOREIGN KEY (`CompanyID`) REFERENCES `company` (`CompanyID`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1;