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

The Grading System helps maintain and organize a secure and dynamic database in an educational institution. This program was mainly a project for my VB class. I'd like anyone to give their opinions/ideas/advice on this program.

This tutorial aims to provide an intermediate Visual Basic 6 user with the basic skills required to retrieve and manipulate data from many commercial databases and any ODBC compliant database using the Active Data Objects technology. It includes a sample project and a full tutorial in Word format. The html version can be seen at http://users.tpg.com.au/jaqmar/adotutorial.htm.

It explains the basics on Database managing with ADO using Datagrid.

I am doing a project for a retail system. In the design time, I need a command button for simulate the pageup and pagedown function for flexgrid. I have found no code reference for this function, so I post my own code here to share with you. Your feedback is welcome!

ADO Example: To Coneection Visual Basic to Any Database(MS Access[mdb], SQL Server etc.,)

Add any BLOB you like to an Access database. For example, add pdfs, docs, mdbs,zips etc. All the different types are displayed in a tree view and you can view them by dragging into a frame and launching their respective application.

Recovers an Access 2000 password

Opens MSAccess 97 and 2000, works with databases with passwords. it allows the user to add, edit, delete modify RECORDS from any access database, also added defrag database function. Please Vote. :D

This project is a database opener which basically opens any MSAccess database w/o knowing the password. The main purpose of the program is to open a passworded database, and retrieve the password. This is helpful for databases with forgoten passwords. The program requires a "Character Set"- this is where the program retrieves several combinations for unlocking the password. if you suspect the database to include numbers and special characters simply include them in the Character Set. the program runs perfectly on high-end machines, but using it on lower-end machines do take awhile. please feel free to comment & vote! :) special thanks to §e7eN for the bruteforce class! =)

An application that allows you to open a Microsoft Access or Foxpro Database and then run/execute sql queries through them. uses ADO,datagrid and common dialog box. Please vote! tnX! =)

This code allows you to connect to your mysql database using vb and execute mysql queries. Displays list of tables and fields contained in your database. Good Tutorial to help you connect to your mysql database using visual basic. Please Vote! =) Thanks!

View the contents of a dBASE file (.DBF). Good example of how to use ListView and ADO together. Code can be easily modified to handle MSAccess files or even CSV files. Only thing particular about dBASE as opposed to other databases is the manner in which the Connection and SELECT strings are created. oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _ "DriverID=277;" & _ "Dbq=c:\somepath" Then specify the filename in the SQL statement: oRs.Open "Select * From user.dbf", oConn, , ,adCmdText Hope someone finds this useful ... Cheers

The Code auto-resizes all columns of a DataGrid. The longest string of a gridcolumn is the new width of the column. Similar to this ListView- or FlexGrid- feature. I havn't found anything similar here, so I just want to put it in the codebase.

A must for Help Desk and Customer Support. A fully functionnal knowledgebase where you can insert a problem and a solution will appear based on the words you have entered!

Update: I fixed some bugs thx Mario Villanueva and changed some icons. Update: I put a new options. Now: - You can load a principal info of the readme file of PSC. - You can search and the PSC website and take the principal data of the post (test version). - Compact, restore and create backup of Database. - Load another database in the folder Database. Thanks to: GetDragon and Territop for the ideas. This's a Database program, with this program you can organize more better the code of PSC contributor, you can search, add, modify and remove codes. Please comment any problem with this small program. You need the Unzip32.dll, you can download in this site: http://home.modemss.brisnet.org.au/~mlevoi/infozip.zip Credits and Thanks Alexander Anikin (ASPictureBox Usercontrol) Genghis Khan (GpTabStrip Usercontrol) Carles P.V. (ucTreeView Usercontrol) LaVolpe (Transparent class) Raymond L. King, Christian Spieler (vbZip File) [CodeId=24532] [CodeId=59307] [CodeId=57047]

UPDATED code to show ADO connection to MS Access with SEARCH, ADD, EDIT, DELETE to and from the database. Two type of reports can be created 1. Excel, 2. Text file. This program is meant as a tutorial with maticulous coding comments. PLEASE VOTE

This is designed as a solution for business-to-business sales. Easy-to-access features include customer and supplier contact management, order processing, accepting delivery, and producing sales & inventory management reports.

Hi everybody, This is for a database programming lovers especially those beginners...There will be no module so you will understand the flow of the program....Not Fully documented yet co'z I have no time for that....Maybe in my next update !....You will enjoy while using this program co'z there are lots of animations in this program....I hope you have learned from my codes co'z that was I wanted for beginners....Have fun coding ! If you like this program please vaote for me or just rate it...Thanks ! For comments email !

Document your Access database structures with ease.

This is just experimental code. The database not included because is very large (8Mb), but can you create one for this aplication (table name=T, fields name see in code...)... This phone book is like a cmd.exe app., example you search a phone number: find *michael*-*street8* Enjoy. Sory for my english....................