Results for "Category: Databases/ Data Access/ DAO/ ADO"
A complete database application. Sorry, but the program is in Portuguese(brazil), I'm uptade to English soon. It is Intermediate because the code is not commented. Please vote for me or leave a feedback!
Add Your data to Access Database/Edit/Delete/Add to the main DB.
This code will import textfiles into a MS Access database using different kind of seperators. A MUST SEE CODE! It works great and can be used for a lot of things!
This COM app was developed as a drop-in module to access databases across the corporate network in a variety of applications. I'm posting it here to get feedback - am i doing the right thing, could i change it in any way? make it better? all comments (constructive!!) appreciated!
A simply utility to search US postal database. You can search by city, state, areacode, zipcode, or county.
Planet source code cd visual basic jumbo 2002 Suppport this beautifull site by purchasing the full cd of visual basic 2002 jumbo this cd contain many great usefull source codes as well as many tutorials with graphics, for me i try this cd and purchase it beleive me its very beautifull work by lan ippolito Website: http://www.exhedra.com/Exhedra/ProductCatalog/Download/PSCCD_2002VB.aspx
SQL Server Enterprise Manger clone (demo only, not complete). This demo can demonstrate that how to use SQLDMO to create your own SQL Server Enterprise Manager which may perform every job the Enterprise Manager can do. In this demo, the following things are included Enumirating SQL servers on the network Logging on to any Selected Server using Windows Authentication or User Name and PWD Getting List of all Data Bases Getting List of all Tables Getting List of all Stored Procedures Getting List of all Users Getting List of all Views Getting List of all Roles Getting List of all Rules Getting List of all Defaults Getting List of all User Defined Functions Getting List of all User Defined Data Types Getting List of all Accessing properties of each object listed above like date creation, owner etc. Creating New Database Creating New Table Creating New Stored Procedure Deleting Database Creating Table Creating Backup of Database Restoring Backup More things can be done by understanding the way these things work. Not very hard, just simple It will work only if you have SQLDMO Library, If you have SQL Server installed, then it will work definatelly Sameers (theAngrycodeR)
Simple program that views a database, transacts custom SQL statements in SQL Server 2000. The SQL-VB connection established here is the foundation of many front-end applications in RDBMS nowadays. This project uses ADO programming techniques.
We had a client who 'accidently' copied one databse table into itself causing duplicate records. Unfortunately Access only allows 10 columns in its De Duplicate wizard and we had twenty! This code allows you to pick the database you want deduplicating, lists the tables and the fields within the table so that you can chose the 'key' fields to deduplicate on. Then it creates a table within the database which contains all of the deleted duplicates from the table you chose. It assumes that you don't mind which instance of a duplicate record you want to keep and it uses Jet 4.0. Also if you run the appliaction twice on the same table you will loose all of the deleted records from the first session (it dosent create a second instance of the deleted table). It also dosen't contain Error trapping as I use Aivostso's VB Watch addin that creates error trapping for you. However, leaving that in would add superflous code so I have omitted it here. This code was wriiten on the quick but it has ben used in anger with correct results. Any constructive comments will be appriciated.
Exports an ADO recordset to Microsoft Excel.
I have worked out all the bugs in this realse, I changed the UI a little but it's still the great looking employee database. PLEASE RATE IT IF YOU LIKE IT . Any comments are welcome. The User Name and Password is "admin"
This is an excellent database program the screen shot speaks for itself has a lot off features. Basicly for storing and keeping track of employees. "PLEASE RATE IT IF YOU LIKE IT" it also has a custom CD Player built in. I will be uploading version 2.0 in 1 week so keep an eye out for it cause if you like this you'll love version 2.0. Still a littly buggy but it's still in its beta stage. Thanks PSC
To show how to get table name and query name using ADO . This code also shows the connectivity with EXCEL
The code demonstrate the use of ADOX (Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security). This will be a series of sample codes that will demonstrate the use of ADOX. For this sample the code will access an mdb file and display its tables and related fields in the listbox. Also supports password protected mdb file.
A simple hospital system. Can add, update, retrieve and delete records like patient, ward, employee... I think it's helpful for those who want to know about how to update and delete record. Please give your comment so that I can improve on it.
Please check it out. It is a good tool.
To generate Payslips
update from my previus posting. This my sample code how to manipulate Datareport without using DataEnvironment this sample included datashape concept and how to link image dynamicly.
vb6 Form.show method in vb.net
A very fast way to fill or populate a MSFlexGrid control with a Recordset 18,000 Records / 2 Sec.