In Progress

SQL Update App

This app NEEDS to be able to connect to ANY MSSQL database.

It should act a lot like sql management studio would. When i first open it, it should ask for connection address and port number. IE [url removed, login to view] and port 1434.

Then it should ask for user name and password.

Then it should display a list of databases on the server available to the user name supplied.

After selecting the data base it should then display a list of tables associated with this database

After selecting this table it would display a list of columns associated with this table.

The first column selected would be what I would call the primary key column.

The next columns selected would be what I would call the fill columns.

So now if I select the following columns:

Primary key column certificate#

fill column rock#

fill column corn#

fill column veg#

The program would look at the column for certificate# and if it had data it would then look at the columns rock#, corn# and veg#. If any one of these columns were blank it would display all four columns and allow manual input of data into any of the "Fill Columns". If the primary key column does not have data or if all of the fill columns have existing data, the program would simply ignore that line.

In the event that rock# and corn# had data but veg# did not it would display all three columns as shown in the picture below:

Any of the data in the fill columns should be able to be edited and submitted back to the database. They will of course have to follow the formatting for the sql database.

I should also be able to select anywhere from 1-1000 fill columns but only ever one primary key column.

Skills: Microsoft, PHP, Software Architecture

See more: Veg, app studio, app manual, app user manual, anywhere connection, connection anywhere, php connect sql server, connect sql anywhere, manual formatting, sql management base, php sql update, course app, app event management, corn sql, corn, open table app, sql management, update sql excel web app, event data base, sql connection, sql server connection, update existing software, fill address line, 1000 app, sql management software

About the Employer:
( 4 reviews ) United States

Project ID: #5291484

Awarded to:

consus

Hi Working on it and finalizing it in few hours to update you I will send you the setup which you can install on your computer Thanks Adnan

$257 USD in 3 days
(46 Reviews)
7.7

5 freelancers are bidding on average $153 for this job

Alex1x23

With more than 3 years experience, we are specialized to WEB DESIGN AND DEVELOPMENT, WE ARE EXPERTS IN WORDPRESS CMS INTEGRATIONS, we are focused on delivering on time all projects with excellent quality and 100% satis More

$144 USD in 3 days
(239 Reviews)
7.3
NayaPakistan

A proposal has not yet been provided

$70 USD in 5 days
(203 Reviews)
6.3
diegou

Hello Thank you for posting this project Im expert please check my reviws Ready to start Best Diego

$250 USD in 10 days
(40 Reviews)
6.0
ittopman

Dear, sir. I read your project detail carefully. I am expert of mysql and php programming. I have many experience of similar to your project. If you hire me, you will get good result. I will wait your good reply. More

$45 USD in 2 days
(2 Reviews)
0.0