Home Latest updates Submit your article About Us Advertise on the Code Project Contact us Discussion Forums Home Home
The Code Project
The Code Project Navigation bar
KeywordAuthor
Community
.NET
Controls
General
Libraries and Projects
Multimedia
Other Platforms
GUI
Internet
Miscellany
 
Click here for Dundas Software - 3D accelerated presentation quality ASP charting

Database

ADO

ADO Data Bound Class Wizard
ADO Data Bound Class Wizard
Ly Nguyen 28 Sep 2000
Interactive SQL Tool (using ADO)
A tool that allows you to query OLE DB sources
George Poulose 18 Jan 2000

COM

Exposing tabular data from your COM object - Part 1
ADO seems to be the ideal way to expose tabular data from your own COM objects and the ATL OLE DB Provider templates can help!
Len Holgate 29 Jul 2000
Exposing tabular data from your COM object - Part 2
The ATL OLE DB Provider templates appear to rely on the fact that your data is kept in a simple array, but that's not really the case at all!
Len Holgate 29 Jul 2000
Exposing tabular data from your COM object - Part 3
Adding bookmark functionality is relatively easy and it enables our ADO recordset to be used with a greater number of data bound controls.
Len Holgate 29 Jul 2000
Making ATL OLE DB Provider templates support updating of data - Part 1
The ATL OLE DB Provider templates only seem to support read-only rowsets and making them support updating of data isn't as easy as you'd expect!
Len Holgate 21 Feb 2000
Making ATL OLE DB Provider templates support updating of data - Part 2
The ATL OLE DB Provider templates only seem to support read-only rowsets and making them support updating of data isn't as easy as you'd expect!
Len Holgate 21 Feb 2000

DAO

CByteArrayFile - storing objects in databases using DAO
A class used to serialize object into a database field
You HongJiang and Daniel Kaminski 18 Mar 2000

General

A Database Tool for Client-Server Systems
Introducing a database tool for client-server systems
Xiangyang Liu 30 Apr 2000
Advanced
Accessing the Borland Database Engine (BDE) from Visual C++ Robert Pittenger 18 Nov 1999
Asynchronous Query Execution
Two classes that provide support for asynchronous SQL execution.
Vachik Hovhannisyan 9 Dec 1999
C++ Object Oriented Database Generator Robert Pittenger 18 Nov 1999
Creating Excel Sheets using ODBC
Writing to Excel spreadsheets using only ODBC
Alexander Mikula 13 Jan 2000
How to use RecordSets without using the AppWizard at the creation of your project. Braulio Díez 18 Nov 1999
Beginner
OLE DB Templates - A light and simple Data Access Method Richard Warg 23 Nov 1999
Reading Excel files using ODBC
A discussion and demonstration of reading Excel files using ODBC
Alexander Mikula 13 Jan 2000
Stored Procedure Class Wizard (SPCW)
A tool to generate class files to implement stored procedures
George Poulose 9 Dec 1999
The CAccessReports class
A class for Printing and Viewing MS Access Reports
Tom Archer 15 Mar 2000
The CGeneric Database classes Martin-Pierre Frenette 3 Dec 1999
Using CLongBinary for BLOBs Shekar Narayanan 1 Dec 1999
Using the CDatabase class to read Excel databases
This is a very simple code snippet that demonstrates how to read a Microsoft Access database file using the CDatabase class
Zahirul Haque 21 Feb 2001
Beginner

ODBC

CODBCRecordset class
CODBCRecordset class is intended to be full replacement of all ClassWizard generated CRecordset derived classes in MFC projects.
Stefan Chekanov 7 Jan 2001
Database info tool
Explore the structure of tables (and views)
Massimo Colurcio 27 Oct 2000
Interactive SQL Tool (using ODBC)
A tool that allows you to query ODBC sources
George Poulose 18 Jan 2000
Simple ODBC classes without MFC
A collection of simple classes to connect to ODBC capable DBMS and share those connections
Justin Kirby 29 Aug 2000
The CODBCDynamic class
A class to dynamically read data from any ODBC data source
Tom Archer 15 Mar 2000

SQL

Century Date Tables
SQL DDLs for creating table structures and inserting the data for a set of tables suitable for producing pick lists for validation of the Month Names, Month Numbers, Days in each Month and Years in the 20th Century
John Bevilaqua 27 Oct 2000

SQL Server

SQL Server and Database Enumerator
A class that helps enumerate SQL servers, databases and languages.
Santosh Rao 26 Apr 2000
Tutorial on Extended Stored Procedures for MS SQL Server v7.0
An interface that can be used to build robust applications that extend the power of MS SQL Server.
Santosh Rao 10 Mar 2000

Unedited Reader Contributions

Another ADO Class
Another cool ADO class for your project!
Christopher W. Backen 31 Jan 2001
Generic Database Class Using ADO to execute Stored Procedures
I developed this class to seperate all database call hidden to other classes and tiers.
Amir Samdani 21 Feb 2001
Advanced

Links

Pooling in the Microsoft Data Access Components Microsoft 1 Mar 2000
HOWTO: Develop with ADO Version 2.5 or Later and Install on ADO Version 2.0
Developing ADO apps using #import Msado15.dll on a system with ADO 2.5 installed will not run correctly on systems running earlier versions of ADO.
Microsoft 13 Oct 2000
Fundamentals of Relational Database Design
an introduction to relational database design theory, including a discussion of keys, relationships, integrity rules, and the often-dreaded "Normal Forms."
Microsoft 18 Oct 2000

Click here for Dundas Software's TCP/IP Development Kit


last updated 23 Feb 2001
Copyright © CodeProject, 1999-2001.
All rights reserved
webmaster@codeproject.com