Send a suggestion!

Members

Technology Zones

IBM Learning Center

Articles

Hosted By

Info

• Index
• / Databases

• SQL Server
• MySQL

• Oracle
• Microsoft Access

Forum Messages

• To use VB as a middleware posted 27 Sep, 12:56 by sumitdipsite2005 in Visual Basic 6

• Error while Launching web application posted 27 Sep, 09:59 by Kedar pathak in C#

• datagridview highlighting current rows posted 27 Sep, 09:08 by kangkungkernitz1081 in VB.NET

• MYSQL6 USER DEFINED FUNCTION posted 27 Sep, 07:02 by Pratheej in MySQL

• Re: Support.vb lib posted 27 Sep, 06:23 by konikula in VB.NET

• Re: How to select the rows only whose checkbox are checked posted 27 Sep, 03:30 by konikula in VB.NET

• Re: Dividing with remainder posted 26 Sep, 22:38 by curiaquita in C/C++

• atoi(string); function posted 26 Sep, 22:19 by curiaquita in C/C++

• Re: Dividing with remainder posted 26 Sep, 22:14 by Mohammad Rastkar in C/C++

• Take a look at .NET posted 26 Sep, 21:57 by Mohammad Rastkar in C/C++

• More Forum Posts...

Articles & Tutorials

• Visual Basic 6.0 - Exporting a DataReport to Microsoft Word

  by John D.

  This article is a simple yet effective way to export a DataReport to MIcrosoft Word using the DataEnvironment and DataReport. This walk-through starts with creating a simple database in Microsoft Access and then creating a User Interface in Visual Basic 6.0. .

• SQL Injection Attacks by Example

  by SJFriedl

  Steve Friedl takes a look at how your site could be vulnerable to SQL injection attacks - complete with numerous examples - and the action you can take to prevent them..

• Identifying Your New Records

  by LACanadian

  While the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. This article reveals two techniques for retrieving the value of an AutoNumber/Identity field..

• SQL Distributed Management Objects

  by Carvin Wilson

  How to use the SQL Distributed Management Objects from ASP.

• SQL Server Locks

  by streamload

  SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK.

Sample Code

• Access AutoNumber Reset

  by Apoc

  This is some sample code that shows how to programmatically reset all AutoNumber fields in an Access Database to a correct value (whether it be 0 or the max value + 1). In addition, it contains code for Compacting and Repairing an MS Access Database. This is perfect for people who are working with a complicated Access Database and have experienced AutoNumber bugs!.

• Form filter example

  by tlosekoot

  An example of filtering the data displayed in Microsoft Access Forms using VBA..

• Getting Started with Database Programming

  by gigsvoo

  This is a conceptual idea of how I start to do database programming. In this article, I had highlighted a few points that become vital to understand for any new comers to do database programming..

Reviews

• Review of SQL Server 2000 Programming

  by James Crowley

  SQL Server 2000 Programming claims to be a comprehensive guide to SQL Server 2000, and at a hefty 1390 pages, you can't argue with that. Being a programming guide, it concentrates only on issues that affect an SQL Server developer, but it still covers topics such as Database Administration to a reasonable level..

Products

• EasyQuery.NET (WebForms)

  EasyQuery.NET WebForms provides your ASP.NET web-site with user-friendly data searching and filtration interface and gives your users an ability to describe their requests in natural language instead of complicated SQL or QBE statements.

• .NET Database, Matisse 6.0

  A Post Object-Relational Database, like Matisse, represents the best of both worlds: The ability to map objects from .NET directly to the database with the support of a standard query language (SQL-99) and a scalable, enterprise capabilities implemented in relational products.

• SQLBoss Developer 1.3.1

  SQLBoss Developer - The fastest SQL Database Development & Content Management Tool for many SQL databases like mySQL, PostgreSQL, Oracle, FrontBase, OpenBase, 4D, via ODBC and many more. Windows 98/Me/NT/2000/XP, Mac OS Classic and Mac OS X. Free serial.

• Store Images in a Database

  Inserting image into database as well as retrieving image from database using this DLL.

Web Sites

• Microsoft Access 2002 Product Guide

  Microsoft Access 2002 Product Guide

• Microsoft Access Assistance Center

  A whole collection of ready-to-use solutions for Microsoft Access

• Why use Stored Procedures?

  An article explaining the pros and cons of stored procedures.

Search

Code Samples

New Members