C++ Database

Stored Procedures are the fastest way of manipulating data inside a database. Using stored procedures in ADO requires a little bit of extra code than a normal SQL execution. It requires the ADO Command object. This Command object can accept any valid parameter types and execute the stored procedures by applying their parameters. This article [...]

  This following sample code describes how to insert a record into a sample table in SQL Server. The sample code inserts data for each one of the following types. Number Varchar Date Money(currency)             The sample first creates a connection string for the SQL Server database. It then instantiates the _ConnectionPtr interface, with [...]

ADO is the norm of the day for database programming. It has a set of COM classes with the capability to support all kinds of database operations. This following sample code describes how to retrieve a set of records from a table. The sample first creates a connection string for the SQL Server database. It [...]