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 [login to view URL] 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.