Members

Technology Zones

Articles

Hosted By

Info

• Index
• / Databases

• SQL Server
• MySQL

• Oracle
• Microsoft Access

Forum Messages

• No Update and no Exception posted 17 May, 12:49 by vsc33 in VB.NET

• Display Datagrid with checkboxes posted 17 May, 09:17 by Benniit in Visual Basic 6

• Top-level control cannot be added posted 17 May, 08:50 by sritanu in VB.NET

• print without dialog box posted 17 May, 06:31 by frankji in JavaScript

• print without dialog box posted 17 May, 06:26 by frankji in ASP.NET

• Web Data Gathering posted 16 May, 21:50 by mcguyvr in ASP.NET

• Re: Crystal Report Underline Problem posted 16 May, 21:04 by qüeb.cesar in C#

• Help with recursion { recursive helper function } posted 16 May, 21:04 by mibit in C/C++

• Re: INSERT,UPDATE on Attached SQL Database File not working posted 16 May, 21:01 by qüeb.cesar in C#

• Re: How to store Image into Databse and how to retrive it from Database into PIctureBox....Plzz help me.. posted 16 May, 20:55 by qüeb.cesar in 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