Item Needed:
With VB2010, Option Strict on,
Open a Database using the common dialog control.
Be able to Open any of the 4 types below with ODBC or oledb.
1. Open Access 2007 database
2. Open Oracle database
3. Open SQL server database
4. Open MySQL database
(Pick item 1 -4 from a drop down box)
--------------------------------------------------------
With the four above:
Add All database Tables and database Queries to a list box (or treeview)
When I click on an item in the above list box or treeview,
add The field names, field type, and length to a (Grid1)
also, add the records of the table or query to another grid. (grid2)
Be able to View records, Edit records, Add new records,
and delete the records, And save the changes or disguard
the changes. to the database.
The grid must refresh and reflect the database Changes after saving or deleting the records.
Be able to save existing grid to access database (Access 2007/2000)
Add text boxes to show the grid2 items (only first 5 Fields)
Add text boxe to show the common dialog control File and path.
Provide Install Instructions.
Provide comments to explain in detail how the code works.
I need this ASAP!
A demo is a must.
Thanks
I have developed database application for my company. The software is running successfully in four hospitals in my area. I can build the application you have requested for three databases leaving oracle (which I don't have).