Change .aspx - [login to view URL] page so that it runs one SQL Select and One Update from MYSQL Instead of SQL

I have a small bit of screen scrape code that I wrote that connects to a Microsoft SQL database. It does a read

string strConnTxt = "Server=(local);Database=mls;User ID=mls;password=test;";

const string strSQL2 = "select * from tbl_listings where listprice is null";

SqlDataReader rdListing = [login to view URL]

It then does a screen scrape and then runs an update query

[login to view URL](strConnTxt, [login to view URL], strSql);

----

The change that is required is to change this code so that it connects to a MYSQL database instead. I will provide the server name and password information etc.

-----

The second part of the project is currently when the screen scrape runs it saves a single image from the screen scrape to my PC. I need to change that code so that it FTPs the image instead to a remote site. It is a very small image so there shoudl not be issues of timing out.

----

I have attached the full set of code to this bid request so you can look at it before bidding

LINE 35 has the connection string and the SQL select

LINE 1219 saves the picture locally. Code to FTP the picture goes here

LINE 1238 runs the SQL update.

---

The table and field names all a remaining the same so there will be no changes requierd to the SQL statement other then allow it to connect to a MYSQL database.

This should be a really quick good product for someone..

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

.net/aspx/mysql

.NET ASP Engineering MySQL PHP Software Architecture Software Testing

Project ID: #3911529

About the project