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

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....................

Generates DBMS Scripts (SQL Server Query Analyser) or VB6 Source Code from a database. Uses either ADO or DAO to connect to database depending on the output required. Query Analyser scripting is useful for migrating a Jet (Access) database to SQL Server. It migrates Tables, Indexes & Constraints (for Default Values etc). The VB6 code generator produces ADO or DAO Object based code to create the database in code or create Class Objects to encapsulate the Tables. Also creates Project & module to integrate all the build code. I intend to expand the langauges and DMBS it can script to. Hope it may be useful to some! Feedback welcome and votes always nice ;) - 23 Nov 05 New Upload

Hello To All This module demonstrates how to perform common operations with ADO. This bas is essential if you want to do any database access with ADO. It shows how to perform common task as well as complex task using ADO. The notes on top of each function is self explanatory. The important feature is that it shows comparison with DAO (the older database access technology)and instructs how to perform similar task in ADO and which parameter to use. Please Rate it. Thanks and Enjoy..