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

This SW allows you to create complex SQL sentences, working with the Dictionary of the Data Base in use. This sentences can be saved to use it later. IMPORTANT: This SW was made in Spanish. As I drop the source code, change it to English is easy. Advances: -Works like the ISQL command. -You can select the number of records to be recalled, and the timeout. -The response will be separated by ASCII 9. Pass it to an Excel Worksheet to work with the results. -You can create the masks for: insert, select, update, delete of the tables. -You have a create table/index template. -The sentence can be converted to a string to pass it trough the clipboard onto your VB project. -You have an internal buffer, to work with two 'clipboards'.

This Project is an example of how to open a file into a byte array and save that byte array to an Access database, and to extract binary data from the Access database back into a byte array and save it back to a file. This example uses .bmp and .jpg graphics files but with minor modifications any type of file can be saved in binary format to a database. again this is only an example application. I threw this togethor in a couple of hours so there are some minor bugs in the code. a little bit of error handling should clear them up. Hope you find this usefull

This is a prefabricated database browser to be used with bookmark- and clone-supporting SQL databases (MS-Access for example). It lets the user browse a database or search for specific entries and then select an entry for further processing. The appearance and contents are customizable. Everything above the blue line is part of the OCX Control. Simply stick it in a form, set a few properties and you're go with a commercial quality browser/record selector. A cross linked help file is included. Download is only 20.5 kB.

Ever wanted to configure ODBC Programmatically, from your code without any client configuration?. Here is how to do it. Please tell me what do you think ?! Please note that the code loads odbccp32.dll, that must be available at the Windows\System directory or on the search path, this DLL is installed by default with ODBC32.

Ever be in the middle of coding a program and you forgot the name of a field in your database? You had to open MS Access, find the database, open the table and get the name of the field. Then you had to go back to VB. Well this program gets rid of all that hassel. You start the program, open the database and it stays on top. It displays all of the fields and tables as well as field types and properties. It will also allow you to modify information in the database. No more going back and forth, just put it off to the side and all the info is right there. Check out a sleeker version of this software here http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=33286&lngWId=1.

Do you hate trying to remember fields in your database? Do you wish you could view/modify your data on a mainframe using an access-like interface? Well now you can! DataFX2 allows you to open any ODBC data source and view the contents of the database. The fields will be displayed in a list from which you can drag and drop right into your code! Never have to remember or type those long field names again! Whats even better is that you can open a table and add, delete, and modify data in a simple access-like interface. And every window has the stay on top or fall behind feature which allows you to make a window always appear in front of other windows so you can view your field names and data while you are coding. On the datasheet, you can filter records using SQL. One of the nicest thing about this program is that it shows you how to prompt the user with the ODBC data source dialog window (I couldn't find this anywhere on PSC). The program also has the ability to open databases using either ADO OR DAO!!! The recent file list also keeps track of which databases or datasources you have recently opened so you can quickly open a frequently used datasource. The recent file menu shows which items are ADO or DAO. Another nice thing about this project is that its a good way for beginners to compare ADO to DAO because almost every line of ADO code has the DAO equivilent below it. The program is also commented and easy to read. Please leave comments and suggestions!

Ever be in the middle of coding and forget the field names in your database? Well this little tool is for you. Open an Access Database and it will display all of your fields as well as the description and ALL of the properties for each field. You can Drag field names right from the list into your code. Never have to memorize (or type) those long field names again. Click the stay in front button and the application will stay on top, click it again and it will fall behind other windows when it loses focus. You can also search for a field name. If enough people like this I will convert it from DAO to ADO. Please leave comments. :) Sorry for the missing .bas file. Its there now. *** 3/20/02 - Added recent file list *** 3/21/02 - Added datasheet option which allows you to open the selected table and add, delete, modify, and view data from the selected table. You can use SQL to filter the datasheet and it also has the "Stay on Top" feature. You can open as many DataSheets as you want. ADO Version coming soon!

Manipulate databases via Microsoft’s ActiveX ADO Libraries. A sample database has been included. Get schema and data information as well as load, store and save blob info to a file. Note: Works with Access 97/2000, Oracle 8i (drivers required), and Microsoft SQL Server 6.5 and 7.0. ---See Readme.txt!---

Counts all valid curly brackets in a c++ source file. Tells where a file's brackets may be out of balance OR tells the user if the brackets are in balance.

To show how to ADD / EDIT / DELETE information from an access Database. Fully Functional - Ready to be used in your programs!!!

Store and extract MS Word Documents (or such other file) in binary mode into a DataBase.

Connect to SQL Server Database ,and see all tables and columns in Treeview , Datagrid. All Stored Procedures ( Names and Texts of SP ) , Triggers ( Names and Texts of Triggers ) Views ( Names and Texts of Views ), Defaults ( Text and Name ) , Constraints ( Text and Name ) Primary Keys ( relationships ) , Foreign Key ( relationships ). Search Engine , Combo1 > TableName | Combo2 > Column Name , Criteria >> with each letter (or any other character ) you type , you will narrow the result. Direct Connection to Enterprise Manager ( with SQL Namespace object lib ) . You can perform full administration and implementation of SQL server and every Database ( if you have those rights ) : Create Trigger , Stored Procedure , Role , Rule , Default , User def. Type. Find out about Table Properties, Permissions , Dependencies,Delete Table. You can use EM interface for Generate Scripts , Manage Indexes . You can call EM interface for managing SQL server security, New Db user, and use EM's wizards for Import and Export DTS . Everything is commented and Constants are attached in two Word .doc files. With Query Builder you can perform very complex queries , Create tables , Update , Insert , Delete . It supports T-SQL commands , so you can perform (almost) everything as you can with Query Analyzer. Sample Queries , are attached as comments inside module. How to manipulate , easy , with more recodsets at the same time. Practically , this is simple console for administration and implementation SQL Server database ,with using full power of EM. I hope that You can find this app. useful . If so , vote. Thanks.

This video rental program with printing capabilities and Flexgrid to Excel feature is usefull for stand-alone PC. This is my first database programming experience in visual basic 6.0 Service Pack 5. So please bear with my coding techniques. Here you will learn how to use ADO and DAO to access a Password Protected database and how to use SQL techniques. Some of the snippets were also taken from PSC submissions. If you like my program please vote for it. I would appreciate any suggestions or comments. However i may not be able to answer emails since i'm busy most of the time. Thnx!

This is a brilliant program from which the beginner can learn .Program include HANDELING DATABASE files ,SEARCHING in databases ,PRINTING your databases ,The DATE TIME PICKER control and a good illistration of the COMBOBOX loading from the database.There is also a great example of creating your OWN DIALOGBOX... PLEASE VOTE if you Like it.

Provides a set of tools for creating and using an ado connection

This code takes an Access 2000 database and creates a VB 6 class. Greatly reduces the amount of time you spend creating classes based off of your databases!

This project uses ADO connection and recordset to get the sales from an Access Database. The data is then presented in a Chart with the sales grouped by days of the week. The display is in spanish, when you read the code you will know what Lunes, martes, etc. is. Hope it will be of use to some of you.

I recently developed a database application and wanted to use only ADO and no DAO. I soon found out that compacting the Jet database was impossible using ADO (until 2.1+ came along that is). This code requires a reference to Microsoft Jet and Replication objects 2.1+ Library (which comes with ADO 2.1+). You can download this update from http://www.microsoft.com/data.

This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access database.

This code will take data from the Northwind database and write it to an Excel spreadsheet. Code can be modified to do more complex reports, but the basics are included here.