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

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

This sample project enumerate all active SQL servers in LAN using ODBC function SQLBrowseConnect. This method is working both for NT and 9x based OSes. The behaviour of this ODBC function is changed in MDAC 2.6 to include all SQL Server instances found on each machine. In MDAC prios 2.6 it's enumerating servers listening on named pipes while after this release its using NetBIOS broadcasts over TCP/IP to receive response from the active servers. The code is compactly written in decoupled module and a form. The module is easy to be recycled in projects of yours and the form can be studied as a sample GUI to it. Enjoy!

Just select your databasename, sourcetable and see... (Please vote....)

DbaMgr2k provides a graphic management interface for MS Msde 2000 installations. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Enterprise Manager provides, rather than via the standard oSql.exe command line utility: an alternative inexpensive console/management tool for Microsoft Sql Server 2000/Msde 2000. In addition to traditional Sql Server objects management and permissions, DbaMgr2k adds HTML documentation generation tool, attach/detach visual interface, a query interface, and a visual interface for BCP operation, extended objects properties support. Provided with built-in English and Italian language localization, supports user defined language translation. It needs ADO 2.6 installed, as long as SqlServer 2000 Client Components (Sql-DMO). SqlServer 7.0/Msde1.0 version available too

...for storing your websites,emails and passwords. High security: connect to an user/password restricted ms access 2000 ado-jet database.Bulletproof: Store all your passwords ONLY in their encrypted hex value. Please check the 2 textfiles for more infos about the encryption used (Buisness strength) and the database.

The reason of doing is because I need to install my application together with database (schema & lookup data) at the client site. Of course we can do this using different approach like BACKUP/RESTORE, or MS Access upsizing. In my case, I need to script all the schema and the lookup data to have a better control to the setup file. Download VB6x LIbrary before using this program. http://www.geocities.com/adhadi/HadiLIb.zip

Allows an interface to generic CSV files. It will allow you to load the file into memory, alter field values by defined name, the fields stored, rename fields in the header line,... with relative ease! HEAVILY commented -- good for learning from. This is was incorporated into an application that shared its information with perl scripts. This was updated on 12/3/02 for bug fixes (sorry if you already downloaded it).

Read from and write to a database on a web site via simple ASP pages from within a VB program, if you do not count DIM statements then this is all done with just 4 lines of VB code (+ 25 or so in the ASP scripts). Uses ADO & XML. REQUIREMENTS: CLIENT PC: MS Internet Explorer 5.0 /5.5 (IE4 will not do) ADO 2.5+ XML (3.0 preferred) SERVER: IIS4+ or PWS ADO 2.5+ XML 3.0

Populating a standard combo box with data from a recordset of 15,000 records or more seems to take forever. I used API calls instead of the AddItem method and my test results shows my function is at least 3 times faster than the AddItem Method. This download does not come with a database file, so if you'd like to test it then provide your own db. Please post the number of records in your ADODB recordset object, the time it takes to populate the combo box with the Additem method (just uncomment a line in my test project, it comes with a timer), and the time it takes using my RecsetToCombo function which is made up of a couple of API calls.

Demonstrates many common VB controls, ADO databound controls, Datagrid, and input validation in a VHS movies library. Hopefully demonstrates good code style.

This program uses Data environment to edit, add, delete recordset and it can also prints a specific recordset that you wanted.

The purpose of this program is to compute the salary of each of employee.

Treeview Database sorry it is in German and my first Submission. If you like it I will put it up again in English.

My Address Book(AnyAddress) allows you to add the persons name, email,Homepage ,Address, phone number and so many other fields. It also have good GUI. It is fully User friendly So u can easily use it. I have used Microsoft Access as Database Sql for searching the records.

ics1 is a inventory control system. this my first project in vb.

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.