CodeProject: Database. Free source code and programming articles

4.85

A set of ADO classes - version 2.20

Updated: 6 Sep 2005

Simple database access using an ADO class.

4.81

A set of ADOX Classes
Updated: 20 Jun 2002

Simple database catalog access using a set of ADOX classes

4.71

Using MS DataGrid control with ADO

Updated: 3 Sep 2001

Use the MS DataGrid control in your C++ app with ADO

4.69

Loading image files from a database, using ADO
Updated: 28 Jan 2006

Putting and retrieving images files to and from a database, via ADO.

Bahrudin Hrnjica

4.68

Interactive SQL Tool (using ADO)

Updated: 18 Jan 2000

A tool that allows you to query OLE DB sources

George Poulose

4.61

ADO Data Bound Class Wizard

Updated: 28 Sep 2000

ADO Data Bound Class Wizard

Ly Nguyen

4.44

ADO at a glance
Updated: 11 Jun 2001

A simple introduction to using ADO

M. Shokuie Nia

4.39

Another Simple ADO Class

Updated: 14 Mar 2001

Another simple yet cool ADO class for your project - from zCoders.com!

Christopher W. Backen

4.08

Efficient data processing with ADO in C++: Method GetRows

Updated: 6 Jul 2005

Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.

VitalyTomilov

4.00

ADO : 101-level tutorial
Updated: 3 May 2004

101-level tutorial on ActiveX Data Objects

Kevin Wittmer

3.82

Two ADO Wrapper Classes
Updated: 5 Apr 2001

Make ADO operations easier with 2 simple classes

Dogu Tumerdem

3.69

Generic Database Class Using ADO to execute Stored Procedures

Updated: 4 May 2001

Use this class to separate all database calls hidden to the callers. Nobody has to take care of how database retrieval is going on!

Amir Samdani

3.63

Use XSLT to convert ADO Recordsets into delimited files

Updated: 30 Oct 2001

Transform any XML persisted ADO Recordset into a delimited text file.

simulant

3.60

ADO MFC Wrapper classes
Updated: 12 Aug 2002

ADO classes that closely resemble CDatabase and CRecordset.

Tim Kohler

3.46

How to return Disconnected ADO Recordset from COM
Updated: 19 Mar 2002

An article on how to return disconnected ADO Recordset from COM using VC.

Siau Tan Long

3.33

Light ORM Library for .NET

Updated: 5 Nov 2007

This article is about the Light Object-Relational Mapping library.

Sergey Busel

4.73

Declarative Transactions using ADO.NET and without Enterprise Services.

Updated: 27 Oct 2001

Sometimes it is nice to prototype up a simple database application. This code may help, by providing the automatic transactional model of COM+ in a non-COM+ environment. This example uses "Interception" to provide automatic transactioning support for non-COM+ classes.

Sandy Place

4.70

Edit Almost Anything in a DataGrid
Updated: 27 Feb 2005

Allow your DataGrid to edit pictures and a whole range of other data types.

Declan Brennan

4.69

Custom DataBindable BusinessObjects and The Typed DataSet
Updated: 4 Jan 2007

An article about Custom Businessobjects in conjunction with the DataSet to Retrieve Data

Emmanuel71

4.68

DataGrid Copy Helper Component
Updated: 28 Jul 2005

A component providing Copy functionality to a Windows Forms DataGrid. Copied data can then be pasted in Excel or a text editor.

patgrape

4.67

DatabaseAccessor

Updated: 23 Aug 2007

A simple base class that encapsulates basic database access functionality

PIEBALDconsult

4.67

Use SQL Parameters to Overcome Ad Hoc Performance Issues

Updated: 12 Jan 2007

Defining (rather loosely) ad hoc queries as SQL commands built as strings by an SQL client application and submitted to SQL Server.

Mark J. Miller

4.66

Programmatically using ADO.NET and XML
Updated: 16 Sep 2004

With ADO.NET, a database can be regarded as a virtual XML document. XPath query and XSLT transformation are naturally available.

Xinjie ZHANG

4.65

C# 2.0 Nullable Data Readers
Updated: 20 Jan 2006

An article on nullable data readers for .NET 2.0 nullable types.

Steve Michelotti

4.60

Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005
Updated: 29 Dec 2006

This article shows how to use CLR integration to compress data in SQL Server 2005

yolousa72

4.60

Component to access databases in the .NET environment

Updated: 1 Jun 2004

An extremely flexible and easy-to-use library that retrieves data in XML format, supports simple parameterized queries, stored procedures, and transactions. It can also be used as a web service.

4.59

Object Mapping Part I - The Row Cursor
Updated: 17 Dec 2006

A row cursor implementation suitable for synchronizing and navigating a DataView against with object-mapped instance.

Marc Clifton, J. Dunlap

4.58

DataSet Watch 2.0

Updated: 29 Dec 2006

An enhanced DataSet Visualizer for Visual Studio 2005.

Osama Abbas

4.54

Using ADO.NET for beginners

Updated: 12 Sep 2005

ADO.NET for beginners.

Huseyin Altindag

4.53

Accesing CommandTimeout properties in a TableAdapter
Updated: 9 Feb 2006

Describes adding public properties to a TableAdapter to access the CommandTimeouts of the private DataAdapter.

PIEBALDconsult

4.53

Inserting relational data using DataSet and DataAdapter
Updated: 16 Mar 2003

This article describes the process of inserting data in a DataSet and then submitting this changes to the database. It targets the issue when having IDENTITY/AutoNumber columns in the database.

Mauricio Ritter

4.50

ADO.NET for the Object-Oriented Programmer – Part Two
Updated: 19 Jan 2006

In this second part of the article series, we will revisit the ADO.NET CRUD operations. Only this time, we will use an application with far better architecture. Once that is done, we will move on to data binding with objects.

4.48

Fill a DataSet from delimited text files
Updated: 19 Apr 2004

Explains how to fill a dataset with the information stored in a delimited text file

Dave - O

4.44

.NET DataSet to ADODB Recordset Conversion
Updated: 8 Mar 2006

A description of how how to convert a .NET DataSet to an ADODB Recordset.

KRucker

4.32

ADO.NET for the Object-Oriented Programmer – Part One

Updated: 19 Jan 2006

This article will show how to accomplish these goals—use ADO.NET as a thin data transport layer, while still taking advantage of the data-binding capabilities of .NET user interface controls. As it turns out, it’s pretty easy.

4.31

ADO.NET for the Object-Oriented Programmer – Part Three
Updated: 10 Feb 2006

In this article, we will see how to use ADO.NET to serialize an object model. Once we have finished with serialization, we will look at how to bind our object model to user controls.

4.27

Build database independent ADO.NET programs with Mimer Provider Manager
Updated: 1 Apr 2004

Write database independent ADO.NET applications

fral

4.25

Object Mapping Part II - Schema Code Generator
Updated: 17 Dec 2006

Generate an object mapping class from a schema definition.

Marc Clifton, J. Dunlap

4.22

The ADO.NET OleDbDataReader class

Updated: 23 Aug 2003

Accessing database information using the DataReader class from ADO.NET in C#

Chris Maunder

4.17

Auto Saving DataGridView Rows to a SQL Server Database
Updated: 26 Jan 2006

Saving a changed row in the DataGridView automatically to the database seems to be a basic task, but is challenging to implement. Read here why the most intuitive approaches fail and how to get it working.

Peter Huber SG

4.16

Inherit from ADO.NET DataSet to create your own business objects

Updated: 27 Oct 2004

Extend generated Strong Typed Datasets, add your own business-specific functionality to a real DataSet object. Binding to forms and updating to a database is all done by the .NET framework. This is built on Shawn Wildermuth's a.k.a. ADO Guy's DataSetGenerator.

Pinx

4.13

A Filter Dialog for a DataGridView

Updated: 28 Sep 2006

This is a dialog window that allows filtering a DataGridView. It can build filters with any depth of parentheses.

nauthiz69_3

4.09

WQL DataProvider for ADO.NET

Updated: 2 Sep 2004

WQL DataProvider for ADO.NET

Maxim Kazitov

4.07

How to avoid writing SQL for ADO.NET DataAdapter

Updated: 18 Jan 2005

Automatic creation of SQL for CRUD operations when Strongly Typed DataSets are used.

Dejan Grujic

4.04

ADO.NET Primer using Managed C++
Updated: 31 Jul 2002

A primer on using ADO.NET with Managed extensions for Visual C++ .NET

Bill Ferreira

4.00

SQL Bulk Copy with C#.Net

Updated: 25 Jan 2007

An article about copying data to SQL within your application.

Kadir Camoglu.

3.93

Using ADO.NET in MFC Projects
Updated: 10 Aug 2003

Mixing managed and unmanaged code and using .NET library in MFC projects

Majid Shahabfar

3.90

Convert XML to Strongly Typed DataSets

Updated: 4 Dec 2003

An example of using an XML document to generate a typed DataSet and load it.

Paperless

3.90

Compressing Persisted DataSets

Updated: 20 Jun 2005

Using .NET 2.0 DeflateStream and GZipStream to compress persisted DataSets.

Adrian_Moore

3.77

ADO.NET – Get the notification events from Managed Providers
Updated: 4 May 2001

How to use the event handlers for various ADO.NET connection & data objects.

Naveen K Kohli

3.74

Simple ADO.NET Database Read, Insert, Update and Delete using C#.
Updated: 31 May 2001

An easy introduction to accessing databases using the ADO classes. It includes how to read and write integers, strings and dates.

John McTainsh

3.70

Bulk Record Insert for Access
Updated: 5 Jan 2007

This article demonstrates how perform a bulk 'Insert' with MS Access.

~~_{jason_lakewhitney}~~

3.69

Add custom validation to data columns in ADO.NET
Updated: 14 Nov 2005

This article describes how to add custom validation to a data column in ADO.NET.

Karthik Krishnaswami

3.67

A generic data reader with ILGenerator
Updated: 1 Mar 2007

Generating a delegate at runtime that reads from a DataReader. By reflection, it’s possible to bind directly a simple query to a list of objects.

Henri G Demers

3.40

AutoIncrement in a disconnected DataSet
Updated: 26 Sep 2005

Working with disconnected DataSets that contain autoincrement count.

balazs_hideghety

3.20

Working with DataGrid in VC++.NET
Updated: 16 Dec 2004

This article demonstrates the DataGrid , ADO.NET components, and storing data into the database and retrieving from the same.

Arul Nayagam C A

3.00

DataTable Generator Using Attributes
Updated: 29 Jan 2007

This article demonstrates the first version of a DataTable Generator. This generator uses information found in custom attributes on any class and transforms the class, or several instances of it, to a System.Data.DataTable.

TeX HeX

3.00

Schema.ini override and bulk upload using SQLXML

Updated: 15 Mar 2007

Schema.ini override and bulk upload using SQLXML

Aravind Rajagopal K

3.00

The SqlReader Object

Updated: 30 Dec 2006

Cutting your code time in half using a smart SQL frontend.

David Morton

2.92

Recommended ADO.NET Data Access Strategies
Updated: 16 Sep 2002

ADO.NET provides two basic strategies for how you work with the disconnected data model

reddy123987

2.89

DLinqEntityGenerator – SqlMetal-like DLinq entities generator, using XSL templates
Updated: 2 Jan 2007

This article explains how to generate DLinq entities mapped on SQL Server database objects, using an Add-In application on VS.NET.

Dan Radu

2.76

Localizable DataSet
Updated: 23 Nov 2004

Put language-dependent column captions in the DataSet itself and use it in your code wherever you need it!

Pinx

2.25

ADO.NET 2.0 Features
Updated: 24 Nov 2007

This article summarises the new and updated features of ADO.NET 2.0, which ships with .NET Framework 2.0.

Murali Krishna .Y

2.10

SQL Classes Encapsulation (simplified stored procedure calls, queries and DataSet returns with .NET)
Updated: 30 Jul 2005

A class that encapsulates SQL connection classes to make queries and stored procedures very easy to run in .NET. Contains methods like ExecuteStoredProcedure and ExcuteSelectStatement to return DataSets.

Xodiak

1.73

Exposing tabular data from your COM object - Part 3

Updated: 29 Jul 2000

Adding bookmark functionality is relatively easy and it enables our ADO recordset to be used with a greater number of data bound controls.

4.82

Making ATL OLE DB Provider templates support updating of data - Part 1
Updated: 21 Feb 2000

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!

4.60

Exposing tabular data from your COM object - Part 1

Updated: 29 Jul 2000

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!

4.33

Exposing tabular data from your COM object - Part 2

Updated: 29 Jul 2000

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!

4.26

Making ATL OLE DB Provider templates support updating of data - Part 2
Updated: 21 Feb 2000

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!

3.60

CByteArrayFile - storing objects in databases using DAO
Updated: 18 Mar 2000

A class used to serialize object into a database field

Daniel Kaminski

4.39

DAO library extension
Updated: 5 Mar 2002

My added DAO functionality makes database reading and writing easier

Kevin Smith

3.47

Using CompactDatabase function with AppWizard's database application
Updated: 18 May 2004

This article shows how to use CompactDatabase() function with database application created with AppWizard, and how to calculate compression ratio. Solved problems: closing database instances, and reopening database without being noticed by users.

Anton P. Ivanov

3.33

MTDaoRecordset : A DAO Class that supports MultiThreading

Updated: 5 Sep 2002

If you're sufferring from dao cracks in multithreaded environment, this article will be useful to you

Kevin Hua

2.78

Oracle Stored Procedure Wrapper
Updated: 12 Aug 2004

This small VB.NET application allows you to quickly generate VB.NET wrapper code for your Oracle stored procedures.

Barry Etter

4.46

Extending TableAdapters for Dynamic SQL

Updated: 9 Jul 2007

This article discusses ADO.NET TableAdapters – especially how to extend TableAdapter functionality using Visual Basic .NET

MikeInNH

4.46

Simulating Recordsets with ADO.NET
Updated: 2 Oct 2004

A proposed class to simulate the ADODB.Recordset behavior in .NET.

Alberto Venditti

4.41

DataGrid101 - Using Windows.Forms DataGrid
Updated: 15 May 2003

Tutorial on the usage of Windows.Forms.DataGrid

omri

4.38

ADO.NET RecordSet Library
Updated: 18 Jul 2006

An ADO.NET recordset class.

João Martins

4.37

A Fast CSV Writer Using ATL
Updated: 7 Jun 2007

A Fast CSV Writer Using ATL

callmepls

4.33

Schema Compare Tool for Oracle
Updated: 21 Jul 2004

This small VB.NET application allows you to compare Oracle database schemas against one another. This is very helpful when making sure your development instance is the same as your production instance; especially when implementing front-end changes.

Barry Etter

4.27

QuickWhere: create complex forms for searching into databases
Updated: 22 Feb 2004

QuickWhere is component that helps you in the creation of complex forms for searching into databases.

DragD

4.19

Dynamic Reports UsingSQL Queries

Updated: 24 Nov 2005

Dynamic report by using the PrintDocument component with SQL queries.

Pakorn Indhatep

4.18

Use of custom attributes to serialise objects to/from SQL Server tables

Updated: 1 Nov 2005

Shows how you can use custom attributes to save .NET classes directly to an SQL Server table.

Duncan Edwards Jones

4.17

Data binding concepts in .NET windows forms
Updated: 16 Feb 2003

A detailed look at the concepts involved in data binding and controlling data binding.

Tarun Jain

4.08

ADO.NET and UDL
Updated: 30 Sep 2005

Using Data Link files with SQLClient and OracleClient.

ra1234567890

3.83

Caching Data in WinForms DataGridView in NET 2.0
Updated: 4 May 2006

An article on how to show large amounts of records using DataGridView's virtual mode in paging.

Nikhil Contractor

3.81

Article 2 - Display data using DataSet and DataGrid controls through Whidbey (VB.NET)
Updated: 10 May 2004

This article explains how we can display data using DataSet and DataGrid control after the database is created.

benoyraj

3.77

Implementing a Provider Independent Data Access Layer in .NET

Updated: 4 Nov 2003

This article tells how you can implement a DAL which is provider independant.

Manoj G

3.70

ATL COM and ADO

Updated: 4 Apr 2001

An ATL Component that uses ADO for data.

Amit Dey

3.69

Data Access Layer (Part I)

Updated: 26 Oct 2005

This is the first part of the development of a Data Access Layer.

Settas Antonis

3.68

Custom Data Grid with Field Chooser functionality
Updated: 2 Jan 2003

A datagrid control with field chooser context menu

GKris

3.32

Runtime Connection Wizard
Updated: 10 Feb 2007

A control to define and save SQL Connections in runtime

Jakob Lithner

3.29

SQL Database Editor
Updated: 26 Aug 2004

An article on a SQL database editor.

Charl Pohlmann

3.29

Data Accessor Class for VB.NET and ASP.NET
Updated: 20 Mar 2003

Wrap up Routine Data Accessing Code into a class

David Bernett

3.24

EasyData - A simple and fast way to work with data
Updated: 12 Apr 2005

This code shows a very simple way to work with data, using XML serializer, and a little trick with ArrayLists.

rmaax

3.17

An SQL execution engine for DataSets
Updated: 29 Jun 2006

Describes a crude method of executing an SQL statement against an in-memory DataSet and returning a new DataSet containing the result table(s).

Lachlan Keown

3.17

Table Adapters and Generics in Visual Studio 2005
Updated: 12 Jun 2007

Using Generics to minimize duplicate code when using Table Adapters in a Data Access Layer (DAL)

The Burger

3.00

Databinding with Cross Reference table (many to many)

Updated: 21 Apr 2004

This article shows how to databind master and details DataGrids (Winforms) when using a cross reference table.

ss2art

2.85

Download binary data from database using a Windows application
Updated: 14 Mar 2005

Function to download and open a file saved as IMAGE data in an SQL database.

SUNILT

2.40

Inheriting Data Access Layer functions
Updated: 20 Jul 2004

Simplify DAL by using Reflection and database table naming conventions

Nigel-Findlater

2.33

XML data type tips in SQL Server 2005
Updated: 9 Nov 2006

Techniques for using the XML data type for storing data.

Howard Richards

4.71

Stored Procedure Invocation Code Generator for VB, C# and JScript.NET

Updated: 15 Jun 2003

Stored Procedure Invocation Code Generator for VB, C# and JScript.NET

Simon Wilson

4.70

DevShot - Database Snapshots for Developers
Updated: 25 Nov 2005

How to create runtime backups from SQL Server 2005 and restore them.

Tommi G

4.67

Accessing XML Using Insert/Update/Delete/Query Statements
Updated: 12 Apr 2005

A psuedo-database for XML.

4.63

Script SQL Server 2005 diagrams to a file
Updated: 7 Aug 2006

Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.

craigd

4.62

An introduction to a post-relational database for .NET, Matisse - Part 1

Updated: 15 Jun 2004

Step by step introduction to a new generation database for .NET.

4.62

An introduction to a post-relational database for .NET : Matisse - Part 5
Updated: 30 Mar 2004

Object-oriented programming with a post-relational database

4.59

.NET Data Access Class for Exchange 2000 Webstore

Updated: 17 Aug 2005

Assembly written in VB.NET that accesses Exchange 2000 Webstore data, using WEBDAV.

clementsm

4.59

Generate SQL Insert statements for your SQL Server 2000 Database
Updated: 14 Apr 2004

Deploy your SQL Server 2000 database with scripts.

daffrey

4.58

Introducing Distributed Messaging using Service Broker in SQL Server 2005
Updated: 28 Sep 2005

An article on distributed messaging using Service Broker in SQL Server 2005.

Akram Hussein

4.57

Oracle to SQL Server VB.NET Utility application
Updated: 7 Jun 2007

A utility program that allows you to enter SQL to select data from Oracle, the program will then create a table in SQL Server and copy the data using SQLBulkCopy.

hoquet

4.55

Extending C# to Support SQL Syntax at Compile Time
Updated: 13 Jun 2005

Ever wished you could truly embed SQL functionality in your C# code without using strings or late binding? Imagine being able to write complex Where clauses purely in C#.

Chad Z. Hower aka Kudzu

4.53

SQL Agent: A Job Scheduler Framework

Updated: 20 Sep 2007

An easy-to-use .NET solution for Job Scheduling with pluggable actions that runs on a Windows Service. Back up your SQL Server Express and much more!

Danilo Corallo

4.45

Connect to DB2 from Microsoft .NET
Updated: 29 Aug 2003

Microsoft .NET and Db2 conenction

Sreejumon

4.43

SQL Server backup utility

Updated: 3 Jun 2006

Restore/backup selected objects in SQL Server.

Shabdar Ghata

4.40

An introduction to a post-relational database for .NET, Matisse - Part 3

Updated: 26 Mar 2004

Step by step guide for .NET programming with a Post-Relational Database

4.38

Read Tables from SAP R/3 using SAP.NET Connector

Updated: 20 Feb 2004

Reading SAP R/3 made easy.

hardteck

4.34

An introduction to a post-relational database for .NET : Matisse - Part 4

Updated: 27 Apr 2004

ADO.NET programming with a post-relational database

Narayana Rao Surapaneni, krmpradeep

4.34

An Oracle Query Tool (part 1)
Updated: 23 Feb 2006

An Oracle query tool with syntax highlighting and a tabbed MDI interface.

Danilo Corallo

4.32

Optimizing building trees from a database
Updated: 20 Jan 2005

How a different way of looking at a problem can result in better performance.

NielsHoldijk

4.31

.NET Data Persistence: SQL Server vs. Matisse vs. FastObjects
Updated: 11 May 2004

An article with source code examining the development speed and performance capability of .NET, Matisse and FastObjects

A.Z. Rosenberg

4.30

UI architecture for managing DTS packages
Updated: 4 Aug 2005

This articles details a UI architecture for managing DTS packages.

4.27

An Approach to Viewing the Structure of a Database Using VB 2005
Updated: 14 Sep 2006

This article describes an easy approach to examining all of the tables, views, and columns in a database.

salysle

4.21

VB DataGridView Automatically Saving Updates to a Bound Database
Updated: 11 Jul 2006

Demonstrates how to configure a DataGridView control to automatically store edits to bound datasets into the source database.

Andrew Timberlake-Newell

4.19

DataLoaders - Unified Data to Object Binding
Updated: 31 Oct 2004

A framework to completely separate objects from their data source - allowing any data source to be used without prior consideration in your code or designs. Databases, text files, web services and potentially anything else can all be used or swapped transparently.

David Wulff

4.18

Object-Oriented database design with the DatabaseObjects library

Updated: 31 Jan 2007

Demonstrates creating object-oriented database systems with the DatabaseObjects library.

Toby Wicks

4.00

LWDbComponents - Another Database Component

Updated: 10 Dec 2006

A full featured and easy to use DB component.

Luis Angel R.C.

4.00

Single Object Property Database
Updated: 30 Oct 2007

Object Properties Snapshot Management

Tigran Martirosyan

4.00

dbObject - Database code generation using attributes
Updated: 26 Jan 2006

A poor man's OR tool for generating VB.NET database code against a MySQL database.

wduros1

3.95

Database Resetter

Updated: 5 Oct 2004

A little tool to make life while developing with databases a little easier.

Michiel de Rond

3.85

An introduction to a post-relational database for .NET, Matisse - Part 2

Updated: 24 May 2004

Step by step introduction to a new generation database for .NET: Schema definition.

Romelard Fabrice (Alias F___)

3.82

Creating Managed Objects in SQL Server 2005
Updated: 22 Dec 2005

Creating managed objects in SQL Server 2005.

Nishith Pathak

3.78

DataQuicker (ORM) 0.9.4: Introduction
Updated: 28 Sep 2005

DataQuicker helps build a clear application structure, accelerates developement, and decreases maintenance costs. It's more possible to provide our customer a perfect on-time project, and release us from over-time working and other delays.

Eunge

3.73

Stop writing connection management code every time you access the database
Updated: 6 Jan 2006

A simple class library for database access without the pervasive and often-fragile connection management details.

Alvaro Mendez

3.72

NHibernate vs. NEO: Face to Face. Part I
Updated: 20 Jun 2005

The first article in the Nhibernate vs. NEO series. Introduction to NEO O/R mapping tool.

firefalcon

3.69

Trouble with Installing SQL 2005 After Uninstalling CTP/Beta
Updated: 18 Dec 2005

After uninstalling the SQL Server 2005 CTP, if you are unable to install the release version, here is what you should do.

Dewey Vozel

3.59

Using SQLParameters with VB.NET/C#
Updated: 3 Sep 2004

Using SqlParameters with stored procedures in .NET.

dotScott

3.53

VB.NET Class Library: Access Table Interface

Updated: 12 Sep 2006

A toolkit that simplifies querying and updating Access database tables.

George B Gilbert

3.53

Using a generic data abstraction layer for database access in .NET
Updated: 23 Oct 2003

The proposed solution removes the hard coding of SQL statements in the application, therefore maximizing the portability of the program, while minimizing the risk of introducing new bugs.

Rob van der Veer

3.46

An OO Persistence Approach using Reflection and Attributes in C#
Updated: 10 Jun 2003

Describes how to use C# attributes , ADO.NET and C# to persist objects to databases.

Dan Bunea

3.41

SQL Database Relation Builder
Updated: 24 Aug 2004

An article on automatically building the relationships between tables in a DataSet.

Charl Pohlmann

3.33

.NET MySQL Connexion V 1.2
Updated: 18 Jul 2003

Class Library for MySQL request

3.26

Simulating Stored Procedures in Microsoft Access using Enterprise Library Application Blocks

Updated: 26 Jul 2005

Simulating stored procedures in Microsoft Access using Enterprise Library Application Blocks.

defwebserver

3.26

Convert DateTime To .NET Ticks Using T-SQL
Updated: 29 Dec 2003

Convert a datetime value to .NET-compatible Ticks using a T-SQL User-Defined Function. Useful for interoperation between .NET and unmanaged environments such as ASP and VB6

Eron Wright

3.23

Creating and populating MS Access files from other databases, using DTS
Updated: 31 May 2006

An article on creating and populating an automated MS Access file from other databases.

Malik Nasir

3.14

Avoid Max Open Cursor Error In .NET
Updated: 19 Aug 2004

Handling Oracle Max Open cursor error when fetching multiple rows in .NET.

Vivek Shaurya

3.00

Controlling Text Field Input on Key Press

Updated: 31 Oct 2007

Shows the basics of controlling input on a controls key press event

The ANZAC

2.87

Custom Configuration SQL Connection String Section

Updated: 24 Jan 2006

This solution demonstrates enforcing valid SQL connection strings in the App.Config file.

Ted Bouskill

2.00

NHibernate Made Simple
Updated: 31 Oct 2007

A simple, straightforward tutorial that will get you up to speed on the fundamentals of NHibernate as quickly as possible

Daniel Aioanei, Adi Malinaru, Andrei Postolache

4.88

Hands on how to configure the Microsoft MSDE
Updated: 14 Nov 2004

An article on how to setup and configure the MSFT MSDE 2000.

Lars-Inge Tønnessen

4.83

Generic Solution Framework to Saving History of Records Using MSSQL Server 2005 Xml Column
Updated: 14 Mar 2007

An article about How to Save Old Versions of Records Using MSSQL Server 2005 Xml Column

yincekara

4.82

Implementing complex data binding in custom controls
Updated: 29 Aug 2006

An article on implementing complex data binding (DataSource and DataMember) on a custom control.

Sascha Knopf

4.80

Dynamic... but fast: The tale of three monkeys, a wolf and the DynamicMethod and ILGenerator classes

Updated: 27 Jul 2007

How to use the DynamicMethod and ILGenerator classes to create dynamic code at runtime that out performs reflection

Herbrandson

4.79

Using CLongBinary for BLOBs
Updated: 1 Dec 1999

Shekar Narayanan

4.78

Remotable Multi-tiered Object-centric Domain Framework
Updated: 23 Jul 2007

An article on building an agile multi-tiered business framework

manu1971

4.78

CppSQLite - C++ Wrapper for SQLite

Updated: 29 Oct 2004

A C++ wrapper around the SQLite embedded database library.

Rob Groves

4.76

Stored Procedure Class Wizard (SPCW)

Updated: 9 May 2001

A tool to generate class files to implement stored procedures

George Poulose

4.76

SQL Injection Attacks and Some Tips on How to Prevent Them
Updated: 23 Jan 2005

Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.

Colin Angus Mackay

4.76

Using Blobs with WTL OLE DB Database Applications
Updated: 7 Sep 2002

Describes an extension to DDX that can read and write blobs using OLE DB providers. Includes sample WTL OLE DB database projects for SQL Server "Pubs" and MS Access "Northwind"

Ed Gadziemski

4.75

FileHelpers v2.0 - Delimited (CSV) or Fixed Data Import/Export Framework

Updated: 10 Jul 2007

An easy to use .NET library to read/write strong typed data from files with fixed length or delimited records (CSV). Also has support to import/export data from different data storages (Excel, Acces, SqlServer, MySql)

Marcos Meli

4.73

The alxBase classes for work with DBF files

Updated: 6 Nov 2002

The alxBase classes for work with dbf files.

Alexey

4.73

Best Practice for Binding WinForms ListControls
Updated: 27 Sep 2004

This article demonstrates the best technique for databinding the ListBox and ComboBox controls in .NET Windows Forms

Scott McMaster

4.72

The CAccessReports class
Updated: 15 Mar 2000

A class for Printing and Viewing MS Access Reports

Tom Archer - MSFT

4.71

Universal Database Admin for ASP.NET and SQL Server (Reloaded)

Updated: 15 Apr 2006

A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.

Quartz.

4.71

Accessing the Borland Database Engine (BDE) from Visual C++
Updated: 18 Nov 1999

Robert Pittenger

4.70

A scripted SQL query generation framework with IDE: SQLpp (v1.4)

Updated: 13 Sep 2003

A helper framework for generation of SQL queries in C++ and Lua

Jonathan de Halleux

4.70

Modeling Hierarchies
Updated: 18 Aug 2002

A solution to the problem of storing hierarchical data in a relational database.

Tomaž Štih

4.68

Data Access Layer (DAL) with SqlWrapper library

Updated: 13 Jun 2005

With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.

Andrey Shchurov

4.67

Use Table-Valued Functions as Arrays in SQL Server

Updated: 6 Jun 2007

Provide array functionality in SQL Server using T-SQL or the CLR

Mark J. Miller

4.66

Generate PDB files in C#
Updated: 10 Jan 2006

This article shows how to create a .pdb file to use as database on Palm devices.

MRSumra

4.64

Persisted Permutations
Updated: 5 May 2004

An article on how to persist permutations of items in relational databases.

4.63

Implement Phonetic ("Sounds-like") Name Searches with Double Metaphone Part IV: SQL Server and Advanced Database Topics

Updated: 19 Mar 2007

Presents a SQL Server Extended Stored Procedure wrapper around the author's C++ implementation, and discusses use of Double Metaphone with relational databases in general.

Adam Nelson

4.62

StP Database Administrator

Updated: 27 Aug 2003

Web-based administration toolkit for MS Access databases

Philip Patrick

4.61

A db grid control using ASP

Updated: 28 Aug 2001

A grid control for ASP written in JavaScript to display recordsets.

Bjornar Henden

4.60

Implementation of a B-Tree Database Class

Updated: 29 Jun 2006

An article and source code regarding the implmentation of B-Trees in C++.

_oti

4.60

Database Visualization

Updated: 31 May 2006

This article aims to create a simple tool for visualizing database tables and relations, a database map to refer to.

VGirish

4.59

Auto-Generating a Comprehensive C# Data Access Layer

Updated: 6 Nov 2006

Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.

adamAFA46

4.58

TransactionScope in .NET 1.1
Updated: 1 Jun 2005

Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.

Alexander Shirshov

4.57

A sorting and paging DataGrid loading data on-demand, saving changes in bulk from and to an Oracle database, in ASP.NET
Updated: 23 Aug 2005

This article demonstrates how to implement a paging DataGrid with an Oracle database. It also demonstrates how to limit the volume of data to exchange between the Web Server and the browser by retrieving only the rows necessary and updating changes in bulk.

Patrice Borne

4.57

Pluggable Sample Data Generator Framework and GUI
Updated: 7 Nov 2006

A framework for writing sample data generators and a GUI that allows these generators to be effectively used

Troy Magennis

4.56

DataTable Transaction Logger
Updated: 28 Feb 2006

Undo/Redo DataTable transactions by logging row changes (insert/delete) and field changes.

klaus_salchner@hotmail.com

4.53

Passing an array or DataTable into a stored procedure
Updated: 28 Sep 2003

This article describes how to pass the equivalent of an array, into a stored procedure, showing a number of different data types. This technique doesn't have the size limitations that a number of other techniques suffer from.

Gareth Edwards

4.53

A Data Access Layer to persist business objects using attributes and reflection - Part III
Updated: 21 Mar 2002

Persistance to business objects through attributes and reflection

xicoloko

4.52

Databinding the SqlTypes

Updated: 2 May 2003

Databinding the SqlTypes using the PropertyDescriptor class and the ITypedList Interface

Dan Glass

4.52

Introduction to WTL OLE DB Database Applications
Updated: 21 Jul 2002

How to create a basic WTL database application using an ATL wizard-generated OLE DB consumer and WTL's version of Dynamic Data Exchange (DDX)

Ed Gadziemski

4.51

Data Access and Transaction Handling Framework

Updated: 13 Jan 2005

Generic data access component for different datasources, sprocs/SQL, implicitly propagated transactions, explicitly managed transaction contexts etc.

Deyan Petrov

4.51

Membership and Role providers for MySQL

Updated: 20 Dec 2005

This article provides two files that contain a Membership Provider and a Role Provider for ASP.NET v2.0.

Rakotomalala Andriniaina

4.51

How To Automatically restart MySQL on Windows
Updated: 3 May 2005

This article provides a small executable (36K) which configures MySQL (or another Windows Service) to automatically restart whenever it fails/crashes.

Emmanuel Kartmann

4.50

How to link different data sources together
Updated: 12 Jun 2005

Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.

4.50

Figure Out the Default Values of Stored Procedure Parameters
Updated: 3 Feb 2006

When working with Microsoft SQL JDBC driver, you cannot invoke a stored procedure without specifying all the parameters, including the optional parameters that have default values. Learn how to fix that problem here.

Rafael Mizrahi, Laurence Moroney

4.50

QuickQuery - a database querying tool

Updated: 7 Feb 2005

A tool for querying all types of databases.

BlackDice

4.49

SQL Tuning Tutorial - Understanding a Database Execution Plan (1)

Updated: 18 Apr 2005

If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.

Gael Fraiteur

4.48

Database Independent Access
Updated: 5 Jan 2005

Use different database providers without tying implementation to one.

Jaryl Sim

4.48

DB2 Access Classes
Updated: 28 Nov 2003

A set of classes to encapsulate DB2 CLI APIs in ADO style.

nickadams

4.47

Creating Excel Sheets using ODBC
Updated: 13 Jan 2000

Writing to Excel spreadsheets using only ODBC

Alexander Mikula

4.46

Another Embedded Database For C++

Updated: 14 Jan 2007

A C++ wrapper to SQLite database

4.45

ADO.NET Generic Copy Table Data Function

Updated: 25 Jul 2007

This generic function will allow you to copy data between any two ADO.NET providers with one simple method call

Michael Ceranski

4.45

PostgreSQL/libpqxx Class Generator

Updated: 18 Aug 2006

Automated generation of PostgreSQL data transfer classes.

_oti

4.45

Correct Column Ordinals of an ADOX Table Object

Updated: 3 Jun 2003

Getting the correct column ordinals of an ADOX Table object.

Ferdie

4.44

Using a LLBLGen-generated data-access tier

Updated: 25 Aug 2002

An article which describes how to use the data-access tier, generated by the free, open source data-access tier generator for .NET: LLBLGen. The sourcecode for LLBLGen v1.2 in C# is included, plus the generated data-access tier used in this article (C# and T-SQL) and the creation script for the data

Frans Bouma

4.44

Project RDL - Open Source Report Definition Language implementation in C#
Updated: 10 Jan 2005

The RDL Project is an open source (GPL) implementation of the RDL for the .NET environment created by fyiReporting Software. RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Project RDL is a compact implementation of RDL.

Kim Sheffield

4.44

Installing MSDE with .NET Application
Updated: 29 Nov 2005

This article shows how to distribute or install MSDE with a .NET application.

4.42

ADO Recordset Paging in ASP
Updated: 22 Jun 2000

How to display multiple pages of records in ASP

Konstantin Vasserman

4.41

Full Database Abstraction Layer Generator
Updated: 23 Oct 2003

Yet another DAL generator with SQL generation, multi database support, C# code generation, etc...

Jonathan de Halleux

4.40

How to use RecordSets without using the AppWizard at the creation of your project.
Updated: 18 Nov 1999

Braulio Dez

4.39

C++ Object Oriented Database Generator
Updated: 18 Nov 1999

This project is a code generator to produce CObject-dervied data classes for Object-Oriented database management

Robert Pittenger

4.36

Easier Database Transactions - Extending the Using Statement to Perform Automatic Database Transactions
Updated: 25 Oct 2004

Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.

Chad Z. Hower aka Kudzu

4.36

An Implementation of Dynamic Connection String and Cursor Handling using Enterprise Library 2.0 in an ASP.NET 2.0 Application with an Oracle Database
Updated: 14 Jun 2006

This article will explore some solutions for dynamic connection string and cursor handling using Enterprise Library 2.0 in an ASP.NET 2.0 applications with an Oracle database.

Yunyou Yao

4.36

Reading Excel files using ODBC
Updated: 13 Jan 2000

A discussion and demonstration of reading Excel files using ODBC

Alexander Mikula

4.33

How to make a random selection from an SQL table
Updated: 2 Mar 2005

A simple technique for selecting random records from a table.

Ach1lles

4.33

BindingSource, Transaction Sandboxes, and Pre vs. Post Add Modalities
Updated: 13 Mar 2006

An investigation into different data entry modalities and the need for a transaction sandbox.

4.33

Parameter Discovery on Microsoft Access With XML option. Using Microsoft Patterns and Practices

Updated: 13 Mar 2007

Automation of command parameter building targeting Microsoft Access

Patrickquinn1212

4.33

CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet

Updated: 16 Feb 2002

A Class to Read and Write to Excel and Text Delimited Spreadsheet

Yap Chun Wei

4.33

Data Access Component - declarative transactions at the method level without EnterpriseServices, different data sources supported, Part 1

Updated: 30 Oct 2002

Data Access Component - thin wrapper of ADO.NET eliminating the need for the transactional support provided by COM+, supplying a uniform interface to different data sources thus allowing for easy switching to another data source eventually

Deyan Petrov

4.31

SQL Server Permissions - Fixing Orphaned Users
Updated: 5 Nov 2003

A short article on recovering orphaned users when moving a database from one server to another.

Megan Forbes

4.29

Compact and Repair Access Database using C# and late binding
Updated: 21 Jul 2004

The code compacts and repairs an MS Access database from C# code using a JRO.JetEngine COM-object. Binding occurs at runtime, no references, no interops. Pure System.Reflection.

Alexander Yumashev

4.29

A Data Access Layer to persist business objects using attributes and reflection - Part I
Updated: 21 Mar 2002

Persistance to business objects through attributes and reflection

xicoloko

4.28

C# Code Generator for Stored Procedures

Updated: 20 Feb 2006

This stored procedure will generate all the C# code for calling any Stored Procedure

McCodeJunky

4.28

Using the CDatabase class to read an Access databases

Updated: 30 Mar 2001

This is a very simple code snippet that demonstrates how to read a Microsoft Access database file using the CDatabase class

Zahirul Haque

4.26

An XML Database Schema And Data Editor
Updated: 30 Sep 2002

View and edit your XML database schema and data

Daniel Aioanei, Adi Malinaru

4.26

Asynchronous Query Execution
Updated: 9 Dec 1999

Two classes that provide support for asynchronous SQL execution.

Vachik Hovhannisyan

4.25

Trees in SQL databases
Updated: 22 Sep 2004

How to get all power of trees in SQL

Eugene Lepekhin

4.25

Create many-to-many relationships in LINQ for SQL
Updated: 1 Sep 2006

Creating many-to-many relationships in LINQ for SQL.

Galin Iliev [Galcho]

4.25

Concurrent model in ADO.NET, ways that allow to negotiate disconnected model restrictions for Oracle databases
Updated: 5 Dec 2006

Using ADO.NET conrurrent model in Oracle databases.

Michael Milonov

4.25

Securely backup your SQL Server database and other files to a remote machine
Updated: 15 Apr 2007

An effective utility to securely backup an SQL Server database and/or a group of files to a remote machine

vooose

4.25

Web SQL Utility
Updated: 30 Aug 2006

A simple ASP.NET application to run queries against your databases. Stores history and favourites.

Ashley van Gerven

4.24

Discard changes in business objects
Updated: 16 Nov 2006

How to build a business object with the option to discard changes

Galin Iliev [Galcho]

4.24

Database Viewer and Updater for any Database

Updated: 25 Jul 2006

View and update any database table and metadata. Includes sample databases.

avronp

4.22

agStoredProc
Updated: 19 Nov 2004

With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.

Alexander German

4.20

Web control to generate database design documents in HTML
Updated: 24 Jan 2006

Just 200 lines of VB.NET to document your SQL Server databases.

Olivier Giulieri

4.20

Creating Auto-Suggest Textbox Using ASP.NET 2.0 Client Callbacks
Updated: 15 Jun 2007

Implementing an auto-completion feature using ASP.NET 2.0 client callbacks

azamsharp

4.20

Approach to unit testing of .NET database applications with NDbUnit and XPath queries
Updated: 22 Jun 2007

The focus is on how one can test the content of a database to see if it adheres to certain assumptions

Serioja Sidorov

4.20

ASC2XXX - Two classes for parsing delimited text files
Updated: 9 Mar 2003

Convert delimited text files to XML file or DataSet object

John C

4.16

Managing Connection Strings for Web Farms in ASP.NET 2.0
Updated: 27 Apr 2006

How to manage database connection strings and connection string encryption for a web farm, in ASP.NET 2.0.

Chris Cole

4.15

OLE DB Templates - A light and simple Data Access Method
Updated: 23 Nov 1999

Richard Warg

4.15

Typed SQLDataReader
Updated: 17 Aug 2004

This article would describe how to read column values based on column names, using SQLDataReader.

S Sansanwal

4.13

Accessing Microsoft Access databases in ASP using ADO
Updated: 27 Apr 2000

A simple introduction to using Access .mdb databases in your ASP pages

Chris Maunder

4.12

MySQL 5 C# sample code using ObjectDataSources
Updated: 15 May 2006

A simple example using MySQL 5 and stored procedures with ObjectDataSources and Generics, in ASP.NET 2.0.

defwebserver

4.10

LINQ to SQL

Updated: 11 Dec 2007

How to use LINQ to SQL

.NET 1.0, .NET 1.1, .NET 2.0, SQL 2000, SQL 2005, SQL CE, Mono, DotGNU, C# 1.0, C# 2.0, .NET 3.0, C# 3.0, .NET 3.5, C#, .NET, SQL, DB, Dev, ADO.NET, LINQ, Beginner

Le Sourcier

4.09

Optimising hierarchical SQL structures (an ASP approach)
Updated: 16 Oct 2001

An article on how to improve SQL hierarchies

Ciprian Miclaus

4.07

Using checkboxes to update multiple database entries
Updated: 11 Mar 2002

Code which allows you to update any number of records with yes/no type values using checkboxes

Torsten Mauz

4.05

ADO.NET 101: SQL Connection
Updated: 1 Sep 2004

A tutorial on connecting to SQL 2000 Server.

mysorian

4.03

Saving Master-Details form using XML
Updated: 15 Apr 2004

This article shows how to save a master-details form using XML.

Muffadal Jaorawala

4.00

Assuring Database Portability with ODBC and .NET
Updated: 21 Sep 2003

Managing portability of your source code among different RDBMS, reducing developing time and maintenance.

Teo

3.96

Find "Leaked" Database Connections in ASP.NET Web Applications
Updated: 9 Dec 2005

Presents a method for monitoring the amount of time database connections stay open in ASP.NET applications.

Todd Denlinger

3.96

Passing comma delimited parameter to stored procedure
Updated: 14 Feb 2004

How to pass an array of integers to a stored procedure.

Reza_Allamehzadeh

3.95

Online DB Administration

Updated: 18 Mar 2003

Online administration of your database. Create or modify tables, keys, and indexes. Edit or insert data.

Bjornar Henden

3.94

General trees persisted in relational databases

Updated: 24 Jun 2003

Persisting general trees in relational databases with fast path-finding capabilities.

3.93

OpenClient++: C++ wrapper for Sybase Open Client library
Updated: 21 Nov 2004

OpenClient++ is a thread safe, cross platform C++ wrapper for Sybase Open Client API.

Rohit Joshi

3.92

MyByteFX.DataHelper
Updated: 31 Mar 2004

A simple Data Link Property Dialog that can create connection strings used in ByteFX.MySqlClient provider.

CodeSanta

3.91

SqlIndex - Lesson in "Connected" ADO.NET
Updated: 26 May 2004

Shows a way to access one or more databases in a "Connected" way by demonstrating the use of SqlReader, SqlTransaction, and SqlCommand. Provides a re-useable algorithm for dynamically accessing one or more databases to move or manipulate data.

Rodney S. Foley

3.91

A Database Tool for Client-Server Systems

Updated: 30 Apr 2000

Introducing a database tool for client-server systems

3.90

Using Transactions in ADO.NET
Updated: 27 Apr 2005

An introduction to SQL Server transactions and how to use them in ADO.NET.

netbard

3.90

Enhanced DataGrid control
Updated: 25 Jun 2003

Extends DataGrid Functionalities

cctuan

3.89

Generating Database Tables using Attributes
Updated: 15 Feb 2004

Generate database schema information from C# classes.

Ahmed Yassin

3.88

Create database during installation of a .NET application - Version 2

Updated: 11 Jan 2006

This application can be used to create database, tables, and stored procedures during the installation of a .NET application.

3.88

Create a Database during the installation of a .NET application - Version 1

Updated: 3 Sep 2005

This application can be used to create databases, tables, stored procedures during the installation of .NET applications.

3.88

Digging SSIS object model
Updated: 19 May 2007

Describes SQL server 2005 Integration Service object model and different data flow components

Moim Hossain

3.87

An ODBC (DSN/Driver) Manager DLL written in C# (Version - I)
Updated: 15 Jan 2004

ODBC Manager class that retrieves System and User DSNs and driver list.

Fact Pandit

3.86

Importing CSV Data and saving it in database
Updated: 25 Aug 2005

This article shows how to import CSV data and store it in database.

3.86

DarkSide SQL Mini Version 1, The embedded database

Updated: 23 Mar 2006

An embedded database library in C++.

3.85

Searching a Notes Database using MFC/NotesAPI
Updated: 28 May 2003

Searching a Lotus Notes Database and locating notes in the database using Lotus C APIs and MFC.

TiNgZ aBrAhAm

3.83

BooProd.Core - Context sensitive Connexion String
Updated: 13 Dec 2004

This article is to help you create context sensitive connexion string: choosen dynamically, depending on which server the application is running.

Boo!

3.83

Export large data from Gridview and Datareader to an Excel file using C#
Updated: 21 Jun 2007

An article on exporting large data to Excel files

Fuad Bin Omar

3.82

Moving a relational database onto Bamboo Prevalence
Updated: 31 Oct 2003

The article describes how to move a database onto Bamboo Prevalence

Stephan Meyn

3.81

Database build tool
Updated: 17 Sep 2004

An extensible tool to package and deploy database schema objects.

Duncan Edwards Jones

3.80

JET to SQL Converter
Updated: 1 Sep 2003

A library to convert a JET database to SQL 'CREATE TABLE' statements

Rowdy75

3.78

Simplest code to convert an ADO.NET DataTable to an ADODB.Recordset
Updated: 27 May 2005

Simple C# code to convert an ADO.NET (System.Data) DataTable to an ADODB Recordset.

Marc Brooks

3.78

File Manager Component

Updated: 21 May 2003

A file manager with Visual Studio.NET design time support.

Martin Cook

3.77

Database Manipulation with ADO.NET for beginners

Updated: 17 May 2005

Personal address book using ADO.NET and C#.

Huseyin Altindag

3.77

An ASP.NET Application Using a MySQL Database
Updated: 28 Nov 2005

How to use a MySQL 4.1 database from an ASP.NET application and some ODBC basics.

vivekthangaswamy

3.77

Insert Field (not append) Using ADOX

Updated: 3 Jun 2003

Using ADOX to insert field into a MS Access table.

Ferdie

3.75

An ODBC (DSN/Driver) Manager DLL written in C# (Version - I)
Updated: 13 Jan 2004

ODBC Manager class that retrieves System and User DSNs and Driver list

Fact Pandit

3.75

Implementing a strongly typed collection with sort/filter/GetChanges features

Updated: 6 Jul 2005

A strongly typed collection that implements CollectionBase and IBindingList interfaces with interesting features (sort, filter, getchanges).

Hayder Marzouk

3.75

Using Query Notifications in .NET 2.0 to handle ad-hoc data refreshes
Updated: 2 Feb 2006

Query Notification in SQL Server 2005 solves the problem of having to maintain a polling database to get the updated data. The new notification service of SQL Server 2005 can perform this amazing task of notifying a .NET code when any DML operations are performed to a specified table.

rajiv404

3.75

Importing data with the SSIS Object model

Updated: 25 Jun 2007

Describes how to use the SSIS object model for importing data to SQL server 2005

Moim Hossain

3.74

HyperNetDatabase

Updated: 22 Mar 2004

HyperNetDatabase is a single process multithreading and blackout safe database

M L Viñas Livschitz

3.73

The CGeneric Database classes
Updated: 3 Dec 1999

Martin-Pierre Frenette

3.71

A Data Access Layer to persist business objects using attributes and reflection - Part II
Updated: 21 Mar 2002

Persistance to business objects through attributes and reflection

xicoloko

3.71

Dynamically adding DSN-names
Updated: 7 Jul 2004

A simple class to dynamically add DSN-names to your system.

Bas Goedemans

3.69

Managing Data Sources in C#
Updated: 11 May 2004

Data sources management.

Guy Baseke

3.67

An Intelligent Data Layer

Updated: 9 Aug 2007

An article on communicating with a database and generating SQL queries on the fly

Ferhat Nutku

3.65

A generic bulk insert using DataSets and OpenXML
Updated: 14 Apr 2005

Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.

poodull76

3.64

Usage of SQLXML to Filter, Retrieve & Present data
Updated: 5 Dec 2003

An article on Microsoft SQLXML

Vinod Giri T

3.63

Load/Unload images into/from DB table

Updated: 24 Aug 2005

Explains how to load a BLOB data into a DB table and how to get it from the DB table.

Maxim Alekseykin

3.62

DBF2DataSet
Updated: 24 Aug 2007

An article for converting DBF files to dataset XML files

canozurdo

3.61

Populate a TreeView from a SELF-JOINED table

Updated: 22 Nov 2002

This demo shows how to populate a treeview from a self-joined table

Gevik Babakhani

3.61

TwinXBase service
Updated: 12 Sep 2002

A service that scans for DBX files and adds their contents to a main Access database

Petervu

3.60

Data Archive
Updated: 1 Jul 2004

This article describes creating indexed search systems using relational databases

Nikolai Serdiuk

3.60

Automated Class Builder for Database Tables
Updated: 12 Nov 2004

This will create a set of classes that generate a set of C# class files which map into the database tables. They will have the class name same as the table name and they will have a set of properties that are same as the table attributes.

Nirosh

3.58

Access Database Editor in C#
Updated: 2 Mar 2002

This project presents an Access Database Editor written in C#

3.57

Cubes, MDX, Analysis Services and ADOMD in C#
Updated: 30 Mar 2004

An article on Cubes, MDX, Analysis Services and ADOMD in .NET

teknas

3.55

PersistedObject - an ADO.NET mapping mechanism
Updated: 25 May 2002

An alternative to Microsoft's typesafe DataSet

Vasek

3.55

An ADO.NET multi-database, multi-tier solution

Updated: 10 Mar 2004

A view of how ADO.NET can be used in a multi-database, multi-tier environment.

Jochen Jonckheere

3.49

Everything you wanted to know about Stored Procedures
Updated: 26 Mar 2004

Stored Procedures explained in detail

Himanshu Khatri

3.44

Events and CacheDependency with the database
Updated: 23 Sep 2004

Simply implement events and CacheDependency with the database

Miloslav Beno

3.41

OLE DB Consumer using basic C#
Updated: 13 Nov 2001

This is the second in a series of articles about using the OLE DB Consumers.

3.40

Get DataSource Information from CSession Object
Updated: 6 Feb 2003

A HowTo on getting DataSource information from CSession object

Ferdie

3.40

Overview of SQL Server 2000 Database Clustering using MSCS
Updated: 11 May 2005

An article which gives an overview of SQL Server DB clustering using MSCS.

Pankaj A. Chitriv

3.36

Develop Reports Using Crystal Reports in .NET 2005
Updated: 19 Oct 2006

A simple example which connects to an Oracle database to retrieve data with a DataSet, and then show a web report using CrystalReportViewer

Yunyou Yao

3.35

Display records in a table using ASP
Updated: 3 Jun 2002

A beginners guide to displaying records from a database in a table using ASP

Megan Forbes

3.34

CurrencyManager Collection - Dealing with SuspendBinding and ResumeBinding
Updated: 21 Jun 2005

Manage SuspendBindings and ResumeBindings for all CurrencyManagers in your app.

Paul Brower

3.33

Building database application with ADO.NET for a beginner.

Updated: 23 Mar 2005

An article on building database with ADO.NET application for a beginner.

Yulianto.

3.32

Using DataLinks to get or edit a connection string

Updated: 10 Mar 2004

Accessing DataLinks from a .NET program to get or edit a connection string.

DanMayer

3.32

Passing a Comma Delimited Parameter to a Stored Procedure
Updated: 30 Jan 2004

Passing multiple values as a single Parameter to a Stored Procedure

-Dr_X-

3.31

Accessing Row based data in an efficient and maintainable manner
Updated: 1 Aug 2006

Methods for accessing row based data in C# (.NET)

Ennis Ray Lynch, Jr.

3.28

Binding a two dimensional array to a DataGrid

Updated: 2 Feb 2004

Binding a two dimensional array to a DataGrid

Mihail Stefanov

3.27

Why Caching A DataBase Connection Is A Bad Idea
Updated: 11 Feb 2002

Caching Data in Application or Session objects is a good idea. Caching Database connections in Application or Session objects however is not a good idea. This article explains why and how to best use your database connections.

Ashish Patel

3.26

Transactions, locking and table releasing with MySQL
Updated: 17 Apr 2004

Implement a simple class to store multiple queries and run against a MySQL database.

Cláudio de Vasconcelos

3.25

Save binary data to SQL Server

Updated: 26 Apr 2002

ASP can save binary data to a table in SQL Server

Fernando Finelli

3.23

Displaying vertical rows in a DataGrid
Updated: 22 Sep 2003

Displaying vertical rows in a datagrid by flipping the tables horizontally

Neeraj Jain

3.22

ADOMD.NET DataAdapter / DataReader replacement
Updated: 4 Oct 2005

This code replaces the buggy ADOMD.NET DataAdapter and DataReader.

MEmerson

3.20

Intermediate OLE DB Consumer with C#
Updated: 17 Jan 2002

Using the OleDbDataAdapter and OleDbCommands objects to consume OLE DB providers

3.17

Export from Database In Different Formats: PDF, Excel, Access, XML, HTML, FoxPro, CSV
Updated: 8 Aug 2007

A solution to the problem of exporting data from database in different formats

Dragos Boia

3.13

The BeginLoadData problem and why OOP doesn't work
Updated: 22 Jun 2006

A foray into a specific problem while discovering at the same time the reasons for why OOP often fails us.

3.09

A simple architecture to read arbitrarily formatted flat files into ADO DataSets
Updated: 26 Apr 2003

This article gives a simple architecture of using StreamReaders and DataSets together to read data from arbitrarily formatted flat files into DataSets, using ini files as an example

Sriram Chitturi

3.06

A simple count() query class

Updated: 10 Jun 2005

A class to easily do count() queries.

Paul S Ganney

3.04

Remote Database Administer via XMLHTTP

Updated: 4 Aug 2002

This article describes how to administer remote database via XMLHTTP and ADOX. It is useful to webmasters who use virtual hosting. Source code is downloadable.

Lu Lianbo

3.00

DataStore - A template class for creating sequential access record files

Updated: 15 Nov 2006

A template class for creating sequential access record files

3.00

How to link to an Access Database in a C# Application

Updated: 21 Sep 2004

An article explaining how to link your home database in your C# application.

Ahmed jamil Kattan

3.00

Data Extraction and Manipulation
Updated: 24 Apr 2007

Extracts data from database, manipulates extracted data, and then updates the database

~~_{jason_lakewhitney}~~

3.00

Get data from database without refreshing the page

Updated: 14 Nov 2002

works in all browsers

Amol Rajmane

2.96

Persist Objects with Attributes
Updated: 16 Jun 2005

Enable persistance and population of objects without writing ADO.NET code.

Thomas Lykke Petersen

2.94

How to generate an SQL filter clause using C#
Updated: 19 Nov 2003

Produces SQL filter clauses using C# objects

gokselm

2.91

Enhancements done for storing connection strings in Visual Studio 2005
Updated: 30 Jun 2005

Enhancements done for storing connection strings in Visual Studio 2005.

Nishith Pathak

2.91

Application DataBlock Extender Code Generator using SQLDMO

Updated: 4 Apr 2005

Use this Windows application to generate complete Data Access Layer for your applications.

dshalimov

2.90

C# Data Class
Updated: 28 Jan 2002

A generalised method for calling parameterized stored procedures

SimonS

2.88

Populate data from database in a ComboBox
Updated: 19 Oct 2004

Populate data from database in a ComboBox.

Huseyin Altindag

2.85

Stored Procedure Wrapper
Updated: 23 May 2007

An article on wrapping stored procedure invocations in strongly typed intefaces

Szymon Pobiega

2.85

Brief about Triggers in SQL Server 2000

Updated: 18 Jun 2004

A trigger is a database object that is bound to a table. In many aspects, it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure".

SquaredRomi

2.83

Create a Dynamic Pie Graph with Export in the Excel file Without Creating an Excel Object

Updated: 12 Oct 2006

Create a Dynamic Pie Graph with Export in the Excel file Without Creating an Excel Object

DEEPCHAND_KOSTA

2.82

Generate an Organization Chart from Employee Database

Updated: 18 Nov 2007

Generate an organization chart from employee database using ASP & Microsoft Excel

BSRK, AHILABALU

2.81

Simple SQL Connection String Manager Class
Updated: 14 Sep 2004

Simple class that helps accessing and managing SQL Connection Strings.

Pawel Zarzycki

2.81

A Helpful Database Library
Updated: 6 Dec 2006

This article illustrates a helpful database library.

~~_{jason_lakewhitney}~~

2.75

Grant Execute on all procedures to a user
Updated: 15 Jan 2004

This stored procedure grants execute privilege on all procedures to specified user

Sumit Amar .

2.74

Data Access Components
Updated: 27 Oct 2003

Data access components to interact with any database.

stephanpeters4000

2.73

Versatile and Extendible Data Access Factory
Updated: 18 Jul 2004

Using and extending the data access classes, and runtime selection and instantiation using a factory and XML configuration file.

G Ryno

2.67

SimpleQuery – quick and easy database access via ADO.NET

Updated: 19 Aug 2005

A class to allow easy running of T-SQL code against .NET data sources.

ChrisLee1

2.63

SQL Server report compress solution (Zip format)
Updated: 14 Mar 2005

To compress large SQL Server reports and allow the user to download the same in ZIP format.

prabhu.subbiah

2.61

How to use CodeProject Grid in MS Access to view multiple intermediate results
Updated: 15 Oct 2002

This article is about using MFC CodeProject Grid, ATL and MS Access together.

rkdev

2.60

C# Relational Database

Updated: 8 Feb 2005

This article describes how to write a relational database using C#.

Dave Brighton

2.57

BoneBoxes .Net Data Access Tools and Data Tier Generator
Updated: 16 Nov 2002

BoneBoxes is a data access library that provides you with SQL statements and data validation based on the data set's properties

BoneHead

2.55

Custom print procedure in MS SQL 2000/7/6.5

Updated: 24 Dec 2003

This procedure can be called in another Stored procedure or function and quite handy in debugging and development

Abhay Dubey

2.53

SQLDataAdapter without using SQLCommandBuilder
Updated: 29 Jan 2004

This article speaks about how to use SQLDataAdapter and its update method without using SQLCommandBuilder

vinoth1979

2.46

Microsoft Application Block for Data Access in .NET

Updated: 6 Sep 2004

This article gives an overview of Microsoft Application Block for Data Access, its advantages and specifies its usage in a .NET application.

Sekhar Lanka

2.44

Detect Changes To A Database Table
Updated: 26 Feb 2004

This article sorts to illustrate one of the ways by which data table changes can be detected through the use of available aggregate functions like BINARY_CHECKSUM and CHECKSUM_AGG.

Pradeep Fernandes

2.44

Versioned Database Access

Updated: 20 Jul 2007

Use the correct data access classes for the current version of the database

kepProg4eva

2.40

Simple Database Application - Part 1
Updated: 25 Jan 2003

Connecting to Database using C# and ADO.NET

Samar Aarkotti

2.39

C++ wrapper for Sybase's OPENCLIENT Interface
Updated: 28 Sep 2002

This article will provide a cross platform C++ wrapper for Sybase's OPENCLIENT interface.

lihaijian

2.33

Vector Data Language
Updated: 3 Feb 2004

This article covers the Vector Data Language, an XML-based language to manipulate XML data from ODBC sources.

stephan johnson

2.33

IDbDataParameter error in .NET
Updated: 11 Sep 2006

How to solve the error when assigning a DateTime to a IDbDataParameter.

René Paw Christensen

2.33

MFC and MySQL
Updated: 9 Aug 2002

MFC classes to fill ComoBoxes & ListBoxes with MySQL data.

Victor M. Valenzuela

2.29

Setting the SharePoint database straight
Updated: 25 Aug 2004

Investigating the database created by SharePoint for use in your .NET application.

Vivek Shaurya

2.24

C# class that creates 'INSERT INTO' SQL queries
Updated: 16 Dec 2004

Class that creates INSERT INTO SQL queries.

Adam Klobukowski

2.22

Accessing dBase Files

Updated: 2 Jul 2003

How to access a dBase file

thomask

2.16

Dynamic connection string
Updated: 10 Aug 2004

Creating dynamic connection string on a remote site.

x_scripterx

2.14

XmlClient Managed Provider
Updated: 17 Apr 2002

A Class Library that holds a Managed Provider to retreive Load DataSets from Xml sources.

Shawn Wildermuth

2.11

Remove comment in SQL
Updated: 13 Feb 2003

Remove comment in SQL to make it easy to execute with MS Access.

colison

2.10

Building pluggable data access components
Updated: 26 May 2004

A simple explanation on how to build pluggable data access components.

WillemM

2.00

Pluggable data access components - Part 2
Updated: 23 May 2005

Article describing how to build pluggable data access components.

WillemM

2.00

MySQL C++ Wrapper
Updated: 5 May 2003

A set of C++ classes for working with the MySQL library.

Kensho

1.98

Easier Data Access
Updated: 30 Dec 2004

The easier way of accessing data using intermidiate classes between basic ADO.NET classes and your own application.

interface Mirror

1.63

Stored Procedure class generator

Updated: 22 Nov 2004

Generate code classes to access stored procedures via web services.

b_hardman

1.63

Implementing Database Versioning
Updated: 3 Nov 2005

This database script provides a template for properly maintaining multiple versions of a database.

Ezhilan Muniswaran

1.48

Delete mechanism.
Updated: 17 Jan 2005

Explains a mechanism of deleting a record when the selected record has related records in other tables.

Tadas Budvytis

1.43

The Keyspace Problem

Updated: 20 Jul 2006

Just how many customers can you have in your database?

Ennis Ray Lynch, Jr.

1.42

Milonic ASP Menu Editor
Updated: 13 Sep 2005

This ASP program simplifies the editing of the Milonic Menu. It uses the sample MSSQL database with minor changes.

BrianLaF

1.36

MySQL User Defined Functions
Updated: 20 Sep 2006

Tutorial on writing your own MySQL User Defines Functions

DarkLizener

4.82

Connecting to MySQL 5.0 from Visual C# 2005

Updated: 7 Dec 2007

Using C#.NET 2.0 to establish connection to a MySQL database with MySQL Connector/Net 5.0.8.1

.NET 1.0, .NET 1.1, .NET 2.0, Mono, DotGNU, C# 1.0, C# 2.0, .NET 3.0, C# 3.0, .NET 3.5, C#, SQL, .NET, DB, Dev, Beginner

lzcampbell

4.00

Lean and extensible mySQL C++ wrapper
Updated: 26 Feb 2007

An article on a lean (2 header files) C++ template class that provides mySQL query

Richard Lin

3.79

ODBCTracer

Updated: 4 Aug 2005

Using Microsoft's tracing infrastructure for ODBC.

Arinir

4.77

CODBCRecordset class

Updated: 7 Jan 2001

CODBCRecordset class is intended to be full replacement of all ClassWizard generated CRecordset derived classes in MFC projects.

Stefan Chekanov

4.72

A set of ODBC Classes

Updated: 28 Aug 2001

Two classes that make easy to work with ODBC

4.69

Database info tool
Updated: 27 Oct 2000

Explore the structure of tables (and views)

Massimo Colurcio

4.67

The CODBCDynamic class
Updated: 15 Mar 2000

A class to dynamically read data from any ODBC data source

Tom Archer - MSFT

4.65

CODBCAccess: a CDatabase and CRecordset Wrapper

Updated: 13 Mar 2003

A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases

Alexander Wiseman

4.63

ODBC Database Access – A Templatised Approach
Updated: 22 Nov 2004

A library of template classes that enables the rapid production of client-side database code.

Dave Handley

4.63

Interactive SQL Tool (using ODBC)

Updated: 18 Jan 2000

A tool that allows you to query ODBC sources

George Poulose

4.62

DataLayer - Freeware ODBC Library
Updated: 10 Jan 2006

An article on a simple ODBC SDK wrapper library.

darkoman

4.45

Two classes for parameterized SQL statement and stored procedure
Updated: 14 Oct 2002

An article on using parameterized SQL statement and stored procedure with ODBC

dapeng lin

4.44

EasyODBC
Updated: 20 Aug 2003

An easy to use C++ wrapper class for ODBC.

4.16

Parameterized CODBCRecordset Class

Updated: 17 Jul 2001

CODBCRecordset that support parameter prior to opening table(s)

Sasa Kajic

4.00

Simple ODBC classes without MFC

Updated: 4 Nov 2001

A collection of simple classes to connect to ODBC capable DBMS and share those connections

Justin Kirby

3.83

Simple ODBC Wrapper
Updated: 3 Jul 2004

Simple ODBC Wrapper + Connection classes for several database types.

TomKat

3.70

Database Development using Visual C++ and OLE DB: Establishing the connection
Updated: 29 Apr 2005

How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.

emadns

4.82

The Dynamic Database Class Based on ATL/OLE DB
Updated: 24 Apr 2002

A class to dynamically manipulate databases data using ATL/OLE DB technology

Eugene Khodakovsky

4.70

Using MS DataGrid control with OLE DB consumer
Updated: 23 Sep 2001

Use the MS DataGrid control in your C++ app with OLE DB Consumer Templates

4.43

OLE DB consumer using basic C++
Updated: 13 Nov 2001

This article is the first of a series OLE DB articles that cover database access using the OLE DB Templates

4.17

High Performance OLE DB library : Ease of ADO, power of OLE DB
Updated: 3 Dec 2001

Introduction to OLE DB extended classes

Ghanshyam Naik

3.91

Improved Versions of CCommand and CDynamicAccessor

Updated: 26 Oct 2004

This article shows one way to extend CCommand and CDynamicAccessor to make OLEDB in C++ easier

Joergen Sigvardsson

3.70

Creating an OLE DB Data Provider
Updated: 13 Jan 2002

This article shows how to create an OLE DB Data Provider that wraps both a C struct and C++ class containing data that is to be made accessible by a SQL query.

David Utz

3.52

Intermeadiate OLE DB Consumer in C++
Updated: 5 Dec 2001

This article expands on my previous article and introduces recordset operations and database entry operations.

Andreas Saurwein Franci Gonalves

3.35

An OLE-DB DLL that you can use in ANSI-C

Updated: 4 Jul 2002

An OLE-DB DLL that you can use in ANSI-C

roboo

3.21

Raw OLEDB Class Library
Updated: 14 Jun 2005

This class provides a raw OLEDB class library.

esob

3.09

Express OLE DB Library: An ideal data access solution for C++

Updated: 24 Mar 2002

This article introduces a commercial-grade data access library that is based on OLE DB technology. It is feature-rich, light-weight and absolutely free.

Ghanshyam Naik

2.50

Building a Database Application using OLE DB
Updated: 12 May 2004

An article on building a Database Application with OLE DB

Yulianto

1.70

How to call an Oracle Stored Procedure that returns one or more REF CURSORS, using ADO from C++
Updated: 16 May 2006

How to call an Oracle Stored Procedure that returns one or more REF CURSORS, using ADO from C++? Think it should be easy to find on the internet or make it work with a little luck? Not before this article was posted!

Koushik Biswas

4.30

OraLib - a lightweight C++ wrapper over Oracle's OCI library

Updated: 4 Jul 2002

6 classes that provide a lightweight C++ wrapper over Oracle's OCI library

Bobi B.

4.12

C++ wrapper for Oracle's OCI Interface
Updated: 28 Sep 2002

This article will provide a cross platform C++ wrapper for Oracle's OCI interface.

lihaijian

3.50

Auto-discover Oracle TNS service names with COSidHelper class
Updated: 6 Sep 2003

An article on how to discover Oracle TNS service names.

li@agileinfollc.com

3.39

Simple C# code generator for Oracle
Updated: 13 Mar 2007

This is a simple C# code generator for stored procedures in an Oracle database. It also can create text for the new stored procedures.

rovshan_b

3.04

Oracle connection and cursor class for Visual C++ in a VB Style
Updated: 20 Dec 2002

A class to connect Oracle using OCI8 libs, that simplifies the connection and the access to data using SQL strings.

jperez

2.56

5 Steps to Adding Data Replication to a Windows Mobile Application
Updated: 18 Apr 2007

The purpose of this article is to show how to add data replication to a mobile application through the use of .NET (C#).

Liam Cavanagh

4.80

MySqlUtil - TableAdapters for MySql

Updated: 3 Aug 2006

A program which generates Typed DataSets and TableAdapters for MySQL databases

Ian Semmel

4.75

Oracle Advance Queue or Advanced Queuing from .NET (C#/VB/MC++)

Updated: 22 Nov 2005

How to use Oracle advance queue from a .NET enviroment.

CastorTiu

4.69

Fulltext Search for Firebird SQL
Updated: 9 Mar 2005

How to search data stored in a Firebird SQL database using a fulltext index.

Dan Letecky

4.56

The Lob Stream Framework, Part 1
Updated: 5 Jul 2007

Providing a few classes and types that aid in the use of lob streams

Peter De Jonghe

4.56

Embedded Firebird: Full-Featured Embedded Database with 2 MB Runtime
Updated: 28 Jan 2005

An example that shows how Firebird database excels in embedding.

Dan Letecky

4.54

Minosse RDBMS
Updated: 14 Apr 2004

Minosse is a complete SQL relational database system entirely written in pure C#.

Antonello Provenzano

4.53

Oracle Service Manager
Updated: 14 May 2004

Manage the state of Oracle services to conserve resources -- just like Microsoft SQL Server Service Manager.

Rob Kayman

4.53

10 Steps to Creating a Windows Mobile Database Application Using .NET and UltraLite 10

Updated: 18 May 2007

The purpose of this article is to help get a user started in building a mobile database application using Visual Studio .NET (C#).

Liam Cavanagh

4.43

The Lob Stream Framework, Part 2

Updated: 9 Jul 2007

In this article, I build further on the foundation of Part 1 as I will actually implement a subclass of LobStream to manage binary/text data to and from an SQL Server Express database

Peter De Jonghe

4.33

SharpHSQL - An SQL engine written in C#

Updated: 11 Oct 2001

Presenting a high performance SQL engine ported to C# from Java

Mark Tutt

4.32

Data Application Block for Firebird SQL
Updated: 29 Mar 2006

Data Application Block for Firebird SQL intended to speed the development of applications.

Xela220

4.20

10 Steps to Creating a Windows Mobile Database Application Using .NET and SQL Anywhere 10

Updated: 24 May 2007

The purpose of this article is to help get a user started in building a mobile database application using SQL Anywhere and Visual Studio .NET (C#)

Liam Cavanagh

4.20

Using DataAdapters and stored procedures with Sybase and ODBC.NET

Updated: 29 Jan 2003

Small demo app using Sybase ODBC.NET and a DataAdapter to edit a DataGrid

Tietokone Chris

4.13

MySQL Schema in C#
Updated: 19 Jan 2004

An article on HOW-TO grab MySQL schema in C#. This program utilizes ODBC API.

Abdul (Rajib) Bahar

4.07

Uploading and Downloading BLOBs to Microsoft Access
Updated: 21 Dec 2006

Illustrates how to upload and download BLOB data to Microsoft Access.

zam664

4.00

An Introduction to Oracle's Berkeley XML Database
Updated: 20 Mar 2007

An article introducing Oracle's Berkeley XML Database and the command shell

Handpeople

3.55

.NET like Access(V1)
Updated: 28 Feb 2006

Database library for rapid development.

Refky Wahib

3.26

C# MySQL Profile Provider for .NET 2.0

Updated: 13 Sep 2006

This is a MySQL based Profile Provider written in C# for .NET 2.0

Edacio

3.04

MySQL connector for Microsoft Enterprise Library (January 2005 version)
Updated: 9 Jun 2005

Adds support for MySQL databases in the Data Access Application Block.

Benjamin.Mayrargue

3.00

Connecting to MySQL database from your .NET applications.
Updated: 20 Feb 2004

A simple introduction on how to connect to a MySQL database.

Sabith.V.Mannadiar

2.17

SQL Syntax Validator
Updated: 8 Aug 2001

How to validate SQL Queries Prior to executing them

Santosh Rao

4.80

Discover SQL: Dynamically recomputing columns
Updated: 18 May 2002

How to perform different computations for each row of a certain table, with each computation involving several columns.

Adrian Bacaianu

4.69

Improve hierarchy performance using nested sets
Updated: 18 May 2003

This article describes how to use nested sets to improve performance of hierarchies within SQL Server and other relational databases

James Simpson

4.32

SQL WHERE - the easy way
Updated: 19 Feb 2002

Creating SQL WHERE clauses can be a pain. This class grants relief.

4.30

SQL in ten minutes
Updated: 1 Apr 2002

Learn SQL basics quickly, as fast as in ten minutes!

Dan Pomerchik

3.88

Can you do this in one statement?

Updated: 25 May 2002

A SQL conspiracy ...

Software Developer's Journal

3.82

How to make an online conversion from code page to Unicode in your SQL scripts.

Updated: 20 May 2002

This article shows how to use directly in your Microsoft SQL, an extended stored procedure that makes conversions between Unicode and code page data.

Adrian Bacaianu

3.79

The beauty of SQL Server queries - Part I
Updated: 15 Oct 2002

Discusses the SQL's SELECT statement in details.

Mehdi Mousavi

3.62

Century Date Tables
Updated: 27 Oct 2000

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

3.38

Retrieving Mutually Exclusive Records using Seagate Crystal Reports
Updated: 13 Aug 2004

An article explaining the retrieval of mutually exclusive records using Crystal Reports with VC++, and unleashing the problems with solutions.

Muneeb Ahmed Awan

3.00

Convert a Hexadecimal to int using Microsoft SQL
Updated: 23 Apr 2007

An article on how to convert a Hexadecimal to int using Microsoft SQL

topcatalpha

2.77

SQL as a set-oriented language
Updated: 18 Apr 2005

SQL works if the commands are set-based. Procedural elements may helpful, but shouldn't be used on the wrong place. The article begins with a procedural sample and changes it into a set-based version.

j.Auer

2.44

SQL Server Object Search

Updated: 22 Aug 2007

An application that seeks to emulate the F4 object search function from Query Analyser

Brady Kelly

4.77

Accessing MSMQ from Microsoft SQL Server
Updated: 26 Mar 2007

How to send/receive MSMQ messages in SQL Server using CLR Integration

Wojtek Jeziorczak

4.73

SSMSKeyBindings - edit keybindings in sql mgt studio

Updated: 20 Jul 2007

An addin to Sql Server Management studio that lets you configure keybindings

Johan Sassner

4.67

SQL Server Network Instance Detector
Updated: 7 Nov 2007

A simple, ready-to-use control for C# beginners to detect all SQL Server instances in a network and then list all the databases hosted on the selected server

Syed Mujtaba Hassan

4.65

SQL Server 2005 Paging Results

Updated: 19 Apr 2007

Using SQL Server to do paging of sql results.

Frank Kerrigan

4.61

Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
Updated: 28 May 2007

Determining SQL Server performance for temporary tables and and table variables.

Dmitry Tsuranoff

4.59

MD5 Hash SQL Server Extended Stored Procedure

Updated: 8 Mar 2005

An extended stored procedure for SQL Server that implements an optimized MD5 hash algorithm. Very small DLL (barely 7 KB).

Vic Mackey

4.57

Uploading / Downloading Pictures to / from a SQL Server
Updated: 29 Oct 2004

Describes how to upload and download pictures to and from a SQL Server database.

Alexandru Ghiondea

4.55

Dynamic 'Sales by Week' Procedure in SQL Server
Updated: 23 Sep 2005

An approach to creating an aggregate report with a set of dynamic columns based on dates.

Mike Ellison

4.54

Shrinking SQL Server Transaction Logs with SQL-DMO
Updated: 22 Apr 2004

Using SQL-DMO to shrink SQL Server transaction logs.

Armen Hakobyan

4.54

Moving SQL Server 2005 Databases to SQL Server 2000
Updated: 14 Sep 2007

Move SQL Server 2005 databases back to SQL Server 2000.

Frank Kerrigan

4.54

SQL Server DO's and DONT's
Updated: 9 Nov 2002

SQL Server database best practices

Daniel Turini

4.54

Audit Trail Generator for Microsoft SQL
Updated: 27 Oct 2007

Discussion of audit trail techniques and a script to automate audit trail implementation on a Microsoft SQL database

Cedric Baelemans

4.53

SQL Server database versioning with Subversion (SVN)
Updated: 13 Oct 2006

This tool (ScriptDB4Svn) enables you to add your SQL Server databases to Subversion (SVN) source control.

Ewout Stortenbeker

4.52

SQL Server Transactions and Error Handling
Updated: 2 Jul 2003

SQL Server Transactions and Error Handling

Saumendra Poddar

4.52

SQL Server 2000 Collation Changer

Updated: 11 Oct 2007

Change collation order for all text columns in a database

Alex Baker

4.49

Enumerate SQL Server Instances in C#, Using ODBC
Updated: 19 Apr 2005

An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.

Eamonn Murray

4.49

Tree utilities in SQL Server 2000 and 2005, and OLAP implementations
Updated: 19 Jul 2006

This article describes how to efficiently store and access tree structures in a SQL Server database, and how to use them in OLAP implementations.

Dan Radu

4.48

Generating INSERT statements in SQL Server

Updated: 17 Jan 2005

Stored procedure to generate INSERT..VALUES statements in SQL Server.

Sumit Amar .

4.48

SQL Server CLR Integration Part 1: Security
Updated: 4 Mar 2007

Understanding how the SQL Server and CLR security models work together to keep your database secure

Mark J. Miller

4.47

Application to migrate data between different environments using the ADO.NET 2.0 SqlBulkCopy

Updated: 30 Nov 2006

This article explains how to migrate data between different SQL Server environments.

siva pinnaka

4.46

Transferring Data Using SqlBulkCopy
Updated: 15 Apr 2007

An article on how to transfer data using SQLBulkCopy

azamsharp

4.43

Using ROW_NUMBER() to paginate your data with SQL Server 2005 and ASP.NET
Updated: 20 Nov 2005

With the release of SQL Server 2005, Microsoft introduces the long overdue ROW_NUMBER() function. In this article, we will walk through a C# implementation of pagination using the ROW_NUMBER() method.

Jason Witty

4.43

Finding SQL Servers on the Network
Updated: 23 Dec 2003

Locating MS SQL Servers by using ODBC through C# PInvoke calls.

Michael Potter

4.42

Locate SQL Server instances on the local network
Updated: 24 Nov 2005

An article on locating MS SQL Server instances on the local network, and retrieving information about them.

James Curran

4.36

C# Photo Album Viewer

Updated: 21 Apr 2002

A C# Windows application to store and retrieve photos from a SQL Server database.

Mark Nischalke

4.34

Writing Extended Stored Procedures in C++
Updated: 15 Oct 2004

Writing extended stored procedures in C++ for SQL Server.

Davey

4.32

Using SqlDependency for data change events

Updated: 28 Jun 2006

Using SQL Server 2005 and SqlDependency to keep your application's data updated.

Mark Nischalke

4.29

Security in SQL Server 2005 as seen by a programmer
Updated: 21 Mar 2006

The goal of this article is to present elements of security in SQL Server such as: restrictive access to the server, blocking and safe configuration of services, and reduction of attack space for new elements. Techniques for creating and managing users and for securing data are illustrated.

4.27

xp_pcre - Regular Expressions in T-SQL

Updated: 17 Mar 2005

An Extended Stored Procedure to use regular expressions in T-SQL.

Dan Farino

4.27

Data Transformation Services Package Progress Dialog
Updated: 4 Dec 2001

Show a progress dialog when you execute your DTS Package at runtime.

4.22

SQL Server 2000 - Merge Replication Step by Step Procedure
Updated: 17 Dec 2004

Merge replication step by step procedure for SQL Server 2000.

D J Nagendra

4.20

Encrypted columns and SQL Server performance
Updated: 11 Jun 2007

Examining the effects of column encryption on SQL Server performance

Dmitry Tsuranoff

4.18

Alternate Rows Coloring in SQL Reporting
Updated: 17 Feb 2005

To change the row colors in reports.

Jayarajan S Kulaindevelu

4.17

Run external programs from SQL Server stored procedures
Updated: 25 Nov 2005

A useful tool for you and a nightmare for the DBA.

4.16

Tutorial on Extended Stored Procedures for MS SQL Server v7.0
Updated: 10 Mar 2000

An interface that can be used to build robust applications that extend the power of MS SQL Server.

Santosh Rao

4.16

Beginners guide to accessing SQL Server through C#

Updated: 23 Aug 2004

A beginners guide to accessing a SQL or MSDE Server with C#

Matt Newman

4.12

SQL User Defined Function to Parse a Delimited String
Updated: 10 Aug 2004

SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.

Claytong

4.11

Enumerate SQL Server using SQL DMO
Updated: 5 Dec 2001

Get a list of SQL Servers to which you can connect.

4.09

Try and Catch Fun in SQL Server 2005
Updated: 17 May 2006

This article is about exception handling improvements in SQL Server 2005.

Abdul (Rajib) Bahar

4.07

Add a user in SQL Server using Visual C++
Updated: 3 Aug 2003

The article explains adding a user in SQL Server programmatically, using VC++

xiaojin

4.06

How to Exactly Enumerate SQL Server from LAN by using SQLDMO
Updated: 25 Aug 2005

An article on how to use SQLDMO to enumerate SQL Server instances.

Wang Xuemin

4.00

Paging and Sorting on SQL Server and Oracle using Sql.Net
Updated: 21 Feb 2005

This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.

Alon_Catz

3.96

TreeToTable hierarchical tables with SQLServer 2005 and C#
Updated: 12 Aug 2006

Retrieving child records from an hierarchical table

Arjan Pot

3.94

Truncate SQL Server Transaction Log
Updated: 19 Aug 2005

An easy way to truncate Transaction Log files to your desired size.

lintom

3.93

Using SQL DMO to Script Tables
Updated: 13 Apr 2003

This article shows the power of using SQL-DMO with SQL Server 2000 to script out objects. In this example we would script out tables.

Vinod Kumar M

3.90

SQL Server and Database Enumerator
Updated: 26 Apr 2000

A class that helps enumerate SQL servers, databases and languages.

Santosh Rao

3.76

Browsing MS SQL Server Desktop Engine using Information Schema
Updated: 15 Sep 2003

Browse MS SQL Server Information Schema Catalog

oleg.vidovic

3.76

MS SQL Server script validation with NAnt Task
Updated: 31 Aug 2006

Validate MS SQL Server scripts with NAnt to improve continuous integration.

Stefan Fork

3.73

Recursive tables in SQL Server
Updated: 26 Jan 2006

Fast recursion in DB.

balazs_hideghety

3.69

Creating User-Defined Data Types in SQL Server 2005
Updated: 20 Sep 2006

An article on how to create user defined data types using .NET languages for SQL Server 2005.

subai

3.67

Very Lightweight Data Access Layer in C# and .NET 2.0

Updated: 4 Apr 2007

Very Lightweight Data Access Layer in C# and .NET 2.0

Fitim Skenderi

3.67

Storing and Retrieving Images from SQL Server using Microsoft .NET
Updated: 1 Jul 2005

Storing and retrieving images from SQL Server using Microsoft .NET.

Kazim Sardar Mehdi

3.61

Insert Data into SQL 2000 Using OpenXML & ADO.NET
Updated: 2 Jul 2003

An example of inserting data into SQL Server using OpenXML + ADO.NET

S. Vijaya Raghavan

3.50

Using MD5 Encryption with C# and MSSQL 2000

Updated: 10 Oct 2006

Demonstrates methods for creating and validating MD5 encrypted passwords in MSSQL 2000.

UsualDosage

3.50

Getting started with SQL Server Everywhere
Updated: 7 Jul 2006

How to start using SQL Server Everywhere in C# programs.

TomDK

3.50

Restore SQL Server Backup Files into any database
Updated: 24 Oct 2005

When you create a backup, you must be able to restore this backup into the same database and same location. But this code also helps you to restore a backup into a new database or existing database.

Phorozan

3.48

Building managed code using Common Language Runtime (CLR) Integration in SQL Server 2005
Updated: 23 Oct 2005

This article talks about CLR integration and how to program database objects using managed code by using this cool feature of SQL Server 2005.

Sekhar Lanka

3.35

Inserting XML formatted data into SQL Server 2000
Updated: 22 Jun 2004

This article explains Parent-Child insertion into SQL Server 2000 using XML Support provided by SQL Server 2000 and Visual Studio.NET

faisal abdul aziz

3.33

Delete and Constraint Handling Stored Procedure Using SQL Server 2000
Updated: 25 Oct 2006

A generalized stored procedure that performs constraint checks before performing deletes.

Jeremy Mullinax-Hill

3.33

Finding 'who is' using SQL Server
Updated: 5 Nov 2003

An article showing how to display the sp_who info and sort on a column.

Steve Brailsford

3.20

Data Driven Subscriptions in SQL RS 2000 Standard

Updated: 15 May 2006

How to implement data driven subscriptions in SQL RS 2000, Standard edition.

Jason Selburg

3.20

Create a SQL Server Database Using C#
Updated: 26 Apr 2005

Create a SQL Server database using C#.

Nguyen Thanh Phuong

3.05

SQL Server extended stored procedure to send UDP messages

Updated: 25 Apr 2005

SQL Server extended stored procedure to send UDP messages.

Rod VanAmburgh

2.92

SQL Server 2000 Using Tranasaction on Distributed servers - Linked Servers
Updated: 14 Dec 2004

Using tranasaction on distributed servers and querying them - Linked Servers in SQL Server.

R. Senthil Kumaran

2.89

Using C# to Enumerate Through Stored Procedures in MS SQL Server 2000
Updated: 3 Jan 2006

This guide will show you how to enumerate through the stored procedures in MSSQL 2000, as well as retrieve parameter information for a stored procedure.

UsualDosage

2.88

MS SQL Server to FireBird migration
Updated: 4 Feb 2005

A real example of database migration (MS SQL -> FireBird).

firefalcon

2.77

Add "Select All" to parameter lists in SQL Reporting
Updated: 10 Mar 2005

How to add a "select all" option to your parameter lists in SQL Reporting.

Sven Cipido

2.71

Connecting to SQL Server
Updated: 14 May 2002

This article explains how to connect to an SQL Server and pass a string.

Amol Kakhandki

2.66

CodeSmith generated Audit Log Triggers
Updated: 8 Apr 2005

CodeSmith template for creating Audit Log Triggers on SQL tables.

RichardRoe

2.56

HOWTO: Install the Northwind and Pubs Sample Databases
Updated: 23 Oct 2007

To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express.

Brian Hart

2.55

Developing a SSIS Package
Updated: 2 Nov 2006

An article on configuring an SSIS Package.

karun123

2.12

Handle Sql server and Foxpro database with .NET
Updated: 6 May 2007

This article aids in rapid application development for database handling, for desktop and web applications

Gaurav Kumar Singh

2.11

How to Set Up SQL Server Integrated Security For Using With SMS
Updated: 19 Apr 2005

How to set up SQL Server Integrated Security for using with SMS.

Ahmed_Sayed

2.00

Word, Excel, Image, XML Files Stroe / Retrive from Database

Updated: 4 Apr 2007

This article will explian store / retrive the word documents, excel files, Images and xml to Sql server database.

Rajaraman.net05

1.88

Complete Remote (Intra/Inter) SQL Server Manager
Updated: 4 Feb 2004

SQL Server manager for remote monitering and managing.

Chaudhary

1.86

Expanding SQL Hierarchies: The Dualistic Approach
Updated: 18 Oct 2006

This article discusses a method for retrieveing hierarchical data from a relational database

Sergey Sorokin

1.75

Simple C# Wrapper for SQLite
Updated: 16 Aug 2007

An article that describes lightweight C# wrapper for SQLite

fbelic

1.69

Pass Serialized Tabular Data as a Stored Proc Parameter
Updated: 29 May 2007

How to solve the age-old problem of passing complex structures as parameters to sprocs

habanero

1.67

How to find if only one particular column has been modified in a trigger

Updated: 6 Oct 2006

How to find if only one particular column has been modified in a trigger.

Master DJon

1.50

Performance Analysis of Addnew and Execute Command in CRecordset to Insert data

Updated: 29 Jun 2007

An article on efficiently adding rows in a database

kazim bhai

1.00

A Fast CSV Reader

Updated: 30 Nov 2007

A reader that provides fast, non-cached, forward-only access to CSV data

Sebastien Lorion

4.80

SqlProcedure - Improve Database Performance, Eliminate Errors and Reduce Code
Updated: 23 Nov 2007

Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors

adambl

4.75

QueryCommander SQL Editor

Updated: 27 Sep 2005

QueryCommander SQL editor with IntelliSense, wrapped in a Visual Studio type of environment. QueryCommander supports: Microsoft SQL Server 6.5-2005, MySQL 4.*-5.1, and Oracle 9i.

Mikael Håkansson

4.69

Generating osql Batch Scripts

Updated: 8 Jan 2006

This article is on a tool I wrote to generate executable osql deployment batch scripts.

Michael Erasmus

4.67

DataTable Synchronization Manager
Updated: 4 Mar 2006

Adds synchronization to the DataTable Transaction Logger.