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

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

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.

Improved code production, index/relation handling and now supports Queries. Database Coder analyses an Access Database and produces the code to create a blank copy of it. Supports Tables, Fields, Indexes, Relations and Queries. Interested in comments. Updated 26 May 2000: Improved handling of default field values and minor bug fix.

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.

I started this application in order to gather somewhere all the code I receive every day from Planet Source Code (actually I gather the URL’s). There are a lot of improvements in this version, plus some bug fixes. Some of these are: importing PSC e-mails directly from the net, importing PSC e-mails from Outlook, better error handling and trace routines. Check out readme.htm for more details. The database now contains e-mails from Dec 14 1999 until Jun 19 2000. I have change (again) the database, so be careful.

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.