Results for "Category: Databases/ Data Access/ DAO/ ADO"

Using this Program one can browse for Access Database through Network or local computer, pick a table you want to make an XML file from, and finally push a button to create a file in XML format. One can also display the newly created XML file and print it into Textbox with further "copy-and-paste". For database browsing I used an API call: GetOpenFileName Lib "comdlg32.dll" instead of bulky CommonDialog Control. For getting a tablenames of the database I used OpenSchema(adSchemaTables)for create Connection and then simply added tablenames into Combobox. Then I used File access VB feature to write an XML file from access table, reading column names and columns, converting it into XML format and writing on disk. The last feature this program has to print out a newly created XML file into Textbox for analysis and, if necessary, "copy-and-paste".

Demonstrates how to add, edit, delete records in a database. Uses ADO for connection. Treeview is included to view the records alphabetically. User has the option if he wants Automatic treeview refresh or manual (see option buttons in snapshot above). NOTE: This is for real beginners.

I think Flexgrid is Important in any Database Project. I made Readable / Writable Flexgrid for convinience to Add / Edit Data.

2 functions to convert a 38 character GUID eg. {2E1EFAD8-4AD9-48A6-B9A9-75505F2B9A51} to a compact/compressed 16 character VB String eg. @#$%

Total remake of earlier submission. I'm using database to to store author,project picture and comments. The actual zip file is stored in a separate folder for easy excess. Project photos can also be saved to a separate folder if option is selected.

Enables any user that can login to a database to monitor sybase activities. You can monitor your SQL transactions, functionalityy accdate, audflags,dbname,fullname,language,name,password,pwdate,resultlimit,spacelimit,srvname,status,suid,timelimit,totcpu,totio,affinity,blocked,cmd,cpu,dbid and much much more

This is a database application. It stores information for keeping track of company inventory. The database is empty, so you will have to populate it yourself

I wrote this code when i was developing a software for an Estate Agent. The code copies the database path in the System Registry and everytime picks it from the registry. If connection fails another dialog box opens where you can specify where the Database is saved. Secondly, you can take out the report of all the data in the table using MS Word. A small routine to accomplish the task. This is basically a three in one program. Save DB Path in the registry, Create Report using MS Word and Specify the database path. Just copy extract the .zip in C:\post directory. Please rate it.

Ok, Trying this again. I think I have all the bugs worked out. This is a sample of a larger database GUI that A friend and I created thru VB for the company that we work for. If you want the full setup.exe and the cab files (you know if you don't have a full package & deployment options) then email me and I'll send it to you in zip format. (Note: this is a huge file) This is a free version so please all comments welcome as to what more to include, and etc. Please do not distribute this software on any other server other than the original upload to planet-source-code. If you think someone else is interrested or would like this program, please give them the link to this. Thank you so much. We also tried to include as much helpful information with the program as well so, if you are operating it and you have any questions please contact me. So, enjoy.

This is just a small login app you can use in your programs. It uses an access database. You can add users. Starting username: username password: password. Please give feedback. I know there are bugs.

a simply sort on de collumsheaders of a datagrid

This source code compares two database structures and wrote report or copy differences into second database. It uses DAO control and works with MDB database.

This is a small application that uses ADODC control to connect to Access, Excel etc. ODBC data sources and execute SQL statement on them. The DataGrid control are used to display returned data. The application has it's own simple SQL code keyword formatter, logging and other features. Small, efficient and robust. Could be a good example of how to use ADO object to connect to DB, execute SQL queries against data in DB and handle the returned data.

SQL Server Documenter can display, print and export to Excel a complete overview of all fields and indexes in a table. This started as a "hello world" type of thing for SQL-DMO and this is the result. It's great for debugging or documenting your databases (that's why I wrote it ;-)). Try it and any suggestions are always welcome.

ADO Recordset Paging in VISUAL BASIC !!! There are many code samples that making recordset paging available in ASP ( Web based ). This example of ADO Paging through a recordset is written in Visual Basic !!!

This is the only one ADO Boolean Search on Planet Source Code !!! [ AND / OR / NOT / AND NOT ]

This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access database. Updated with some error handling and other stuff :)

This is a Bible concordance that you can use to store bible related topics and scriptures. So like you could create a topic entiled "Abortion", with scriptures against it, and come back at a later time and view it. It uses an elaborate database of text files to store all info. Next version im going use MS Database. If you add anything cool to it, please let me know. Thanks.

Este codigo facilita las conexiones mediante el ODBC creando un DSN segun el driver (class) que se este usando (Access, Dbase, Paradox y MySQL 3.51 en esta versión). Estupenda herramienta para los programadores de aplicaciones que usan bases de datos tales como Paradox o Dbase. Duda o sugerencia favor de ponerse en cotacto conmigo. With this code, u can connect to many databases formats using ODBC, like Paradox, Access, Dbase or MySQL, with a short numbers of lines and easy. Try it :-)

This code is a great help for those people without Microsoft Access and want to administer their Databases easily. Includes full source code. Shows all records at a glance, allows editing, adding and removing. If you like this please support me.