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

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

to make library more compact!

This sample shows how to secure Access database using ADOX and SIDs. In apps where database is created on-the-fly from code its only way to prevent your database from being modified.

This sample shows how create Excel file using ADOX. In database apps when ADO and ADOX is used it's simple way to create 'Excel reports'. Using ADOX is about 3 times faster than Excel Automation. If you find this code useful, please vote...

This tutorial will help, preventing more then one instance of any application, which contains this code in form_load event.

A simple application which shows how to call and manipulate Access Database records through ADO using Visual basic. Also, shows the proper GUI design for a transaction application. Please Rate :)....

This is a nice program for Browsing through the MS Access file i.e. *.mdb. It works quiet fast comparatively. This shows you the number of tables present in the selected Database. Further it will show the fields in the selected table.Theres also a provision for seeing the whole selected table in the grid. Its quiet a good thing for using & even for the users who are not well known with the usage of Access Databases & dealing with the uncertainity tables into it.

SQL Navigator is a very good Demonstration of Viewing the Tables, Views & Procedures present in SQL just with the help of some SQL in-built functions through ADO. It will show you the data in the table & even the text of the Procedure which you had made in SQL. Might be unknown to someone how to use the SQL functions through VB just by passing them into the recordsets. It can be used very well by making an application. It is very small easy to understand, fast & hey.. dont forget to rate my code...!!!