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

This simple database will save all your books collection, it shows the use of ADO, DataReport and DataEnvironment, it shows how to Add, Save, Edit, Delete, View Reports. Other cool stuff it contains a toolbar and a file menu. It also shows the enable and disable functions.

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!

This is a good example to database connectivity....it's an example to match signatures ... in some institutions signatures of a person is scanned and verified by looking into the scanned image and the signature of that person...good example

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"

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.

Allows the programmer to create an MS Access table in Visual Basic where the primary key’s field data type is set to AutoNumber. It is not like creating the primary key field in Access where you can select AutoNumber date type. In VB 5 and 6 you can’t request AutoNumber for a field type in the SQL Create Table string, it does not exist. So to create a table in VB where primary key’s numeric field type will be AutoNumber, you have to do it the way the included source code shows. Hope this helps.

This is a demonstration to show you how Header Tables relate with Detail Tables. Don't forget to vote for it.

Load your categorys in a treeview, create new entries under your personal categorys. Three (!) completely different kinds of searching will help you finding any entrie you are looking for. You can create new categorys, delete or modify them. Learn how to create a better database for contacts, source code or whatever. The Treeview is resizeable ! easy by draging it to the left or right! The sample application is 90% done, fully functionally and kept without a personal note for a simple demo. (means no pics and icons you are deleting anyway ) You can easily change everything for your own needs. The database is MS Access 97 Format. (You can upgrade to MS Access 2000 without changing any code. )

This code enable you fill a DataReport with the information contained in a Recordset. In this example, I have a connection with a database and I fill the Recordset with a SQL sentence.

This code will allow you to populate a listbox control using an ADO recordset. I am using the standard VB ListBox Intrinsic control. Everything is done through code.

This document explains how you can write Oracle stored procedures, that will return ADO recordsets to your VB or ASP application.

This code creates and maintains a database of multiple users that may use your program. This supports user flags that YOU specify and define as well as a checkpoint system that YOU build! Documentation and sample projects included.

This shows how to two things, first how to pass variables to a stored procedure on a SQL server, second it shows how to handle multiple recordsets being returned from the stored procedure. This allows for a greater speed then trying to pass the entire SQL query to the server especially when you have several. Please Vote if you like it! :)

Connect to any ODBC compliant db using RDO. by the way MySQL, Oracle, FoxPro, Excel, Access, Sybase are all ODBC compatible. Use this code to connect to Unix databases, Linux databases, etc. Very simple (easy to follow) code. If you would like to see the same in ADO, or want me to add DB creation/editing capabilities let me know. Currently you can just add, update and delete records as well as run queries. Please Vote, I stayed up late working on this. Comments positive and negative welcome.

This source code was originally to predict lightning strikes. This source code is run in MATLAB and can be modified for different no of inputs. Meaning, this source code can be used for any kind of prediction!

this is a code to specifiy .MDB from your app not from properties it is just for a beginner...

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 the better way to find out whether your particular table, any table, exists in your database. Sequential is NOT the way. Check this out and let me know if you have any questions. Please give me a vote if you like this code :)

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 small program is very usefull when you want to compare destination mdb file from your development mdb. It is not only compare the database (tables, indexes and queries) schema but also Fix It !, this prog use temporary mdb to hold the schema so you just bring this prog and schema file and compare it at your customer. if you like it please give me a credit!