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

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.

This is a ZipCode ASCII text file exported from SQL 7. First row has column names. Ready to be imported into your database of choice. Over 43,000 entries. Example: "Zip_Code","City","State","Area_Code","County"-- "00210","Portsmouth","NH","603","Rockingham" "00211","Portsmouth","NH","603","Rockingham" "00212","Portsmouth","NH","603","Rockingham" "00213","Portsmouth","NH","603","Rockingham" "00214","Portsmouth","NH","603","Rockingham" "00215","Portsmouth","NH","603","Rockingham" "00401","Pleasantville","NY","914","Westchester"

Ok, and now that you have finished your Super Multiuser Access application ,would you like to know who is logged on??? well, here is the answer and the code to do it. don´t forget to rate if you like it.

Here it comes again with a cool interface a compact one(like the msoffice taskbar) and a full one(see screenshot).It has more number of functions than you can imagine.An image viewer(not a simple one).A database using Msaccess.A calculator.A Phone Dialer.An Inbuilt internet browser.Calender,time date(you can even set the system time).Play movies or MP3's as you work.It took me many days to complete.PLEASE VOTE FOR IT.visit www.gauravcreations.com for many more cool programs .

I did not write this code by myself , i had found it at http://support.microsoft.com/support/kb/articles/Q246/3/35.ASP With this code you can transfer the contents of an ADO recordset to a Microsoft Excel worksheet by automating Excel , this code will work only with Excel 2000 or 2002 , for Execl 97 use my previous examples, or just look at this examlpe for basic knowledge at the IF statement.

In this example I try to show you how to connect the ADO object to Excel file directy , without copy any data from the Excel file to DataBase first ( like MS access) , plesae vote for me :)

This code will copy all fields from all tables in a database and add them to another identical database. My company has Rep submitting database reports all the time. I need to append the data from the reports database to a live database. At first I was running querys I had made in the database but our file structure changed and that was no long an option. This is about as simple as it gets but someone might find it useful.

This program generates code for a Microsoft Access database that the user selects. The generated code will declare the connections as well as open and close the connection. This code has a lot of examples of coding with ADO and grids. I have lots of comments in the program.

This is an ADO DB tutorial for programmers who know nothing about ADO. It is a good template to following when making your own project. I hope that it helps.

This program is designed to teach the user how to load data into a FlexGrid from an Access database and then manipulate the FlexGrid to perform typical database actions such as Add, Edit, Sort, and Delete. The database manipulations are executed with ADO methods