Database - ADO			top
Title / Updated	Author	Score
A set of ADOX Classes Updated: 19 Jun 2002 Simple database catalog access using a set of ADOX classes SQL, VC6, VC7Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev	Carlos Antollini	4.84
ADO Connection Strings Updated: 23 Jul 2002 A list of ODBC DSN Connection Strings. SQL, VC6, VC7.NET 1.0, Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev	Carlos Antollini	4.83
A set of ADO classes - version 2.20 Updated: 6 Sep 2005 Simple database access using an ADO class. SQL, VC6Win2K, SQL Server, MFC, ADO, DBA, Dev	Carlos Antollini	4.81
dbAx: a C++ Library for ActiveX Data Objects (ADO) Updated: 21 Jan 2009 C++ class wrapper for ADO C++, Windows, Win32, COM, ADO, DBA	Ross White	4.76
Loading image files from a database, using ADO Updated: 27 Jan 2006 Putting and retrieving images files to and from a database, via ADO. SQL, VC7.1Win2K, WinXP, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	Bahrudin Hrnjica	4.67
Interactive SQL Tool (using ADO) Updated: 17 Jan 2000 A tool that allows you to query OLE DB sources SQL, VC6, SQL Server, DBA, Dev	George Poulose	4.57
ADO at a glance Updated: 10 Jun 2001 A simple introduction to using ADO SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	M. Shokuie Nia	4.42
ADO Data Bound Class Wizard Updated: 27 Sep 2000 ADO Data Bound Class Wizard SQL, VC6, SQL Server, MFC, ATL, DBA, Dev	Ly Nguyen	4.41
Using MS DataGrid control with ADO Updated: 2 Sep 2001 Use the MS DataGrid control in your C++ app with ADO SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	Rashid Thadha	4.34
Another Simple ADO Class Updated: 13 Mar 2001 Another simple yet cool ADO class for your project - from zCoders.com! SQL, VC6Win2K, SQL Server, Visual Studio, DBA, Dev	Christopher W. Backen	4.15
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. SQL, VC6, VC7, VC7.1, VC8.0Win2K, WinXP, Win2003, Vista, TabletPC, COM, ADO, SQL 2000, SQL 2005, VS.NET2003, VS2005, SQL CE, DBA, Dev	Vitaly Tomilov	3.96
ADO : 101-level tutorial Updated: 2 May 2004 101-level tutorial on ActiveX Data Objects SQL, VC6, VC7, VC7.1, Windows, SQL Server, VS.NET2003, DBA, Dev	Kevin Wittmer	3.93
Two ADO Wrapper Classes Updated: 4 Apr 2001 Make ADO operations easier with 2 simple classes SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	Dogu Tumerdem	3.69
ADO MFC Wrapper classes Updated: 11 Aug 2002 ADO classes that closely resemble CDatabase and CRecordset. SQL, VC6, VC7, SQL Server, MFC, DBA, Dev	Tim Kohler	3.69
Generic Database Class Using ADO to execute Stored Procedures Updated: 3 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! SQL, VC6, VB 6Win2K, SQL Server, ATL, DBA, Dev	Amir Samdani	3.63
Use XSLT to convert ADO Recordsets into delimited files Updated: 29 Oct 2001 Transform any XML persisted ADO Recordset into a delimited text file. C++, XML, SQL, Windows, SQL Server, Visual Studio, ADO, DBA, Dev	simulant	3.60
How to return Disconnected ADO Recordset from COM Updated: 18 Mar 2002 An article on how to return disconnected ADO Recordset from COM using VC. SQL, VC6Win2K, WinXP, SQL Server, Visual Studio, MFC, ATL, DBA, Dev	Siau Tan Long	3.33
WrapSP - A Wrapper Class Generator for SQL Stored Procedures Updated: 8 Aug 2009 A simple to use tool that generates ADO based classes for calling SQL Stored Procedures. Only a few clicks, and you can access any Stored Procedure in your database. C++, SQLWin2K, WinXP, MFC, ADO, Dev	_Reinhard	3.29
Create Table with AutoNumber Indexed Field Updated: 6 May 2009 Create a new Table and re-create Table to set existent Field as Primary Key VB (VB 6), Windows (WinXP, Vista), ADO	Mostafa Kaisoun	3.00
Breaking data on comma - Unedited Updated: 22 Feb 2008 to break data on comma delimiter SQL, SQL Server (SQL 2000, SQL 2005, SQL CE), DBA	shekharshashi	1.00
.NET - ADO.NET			top
Title / Updated	Author	Score
Performance and the Entity Framework Updated: 12 Aug 2009 An article describing the best practices for Entity Framework performance C#, .NET (.NET 3.5), ADO.NET, Architect, Dev	Perry Marchant	4.88
Edit Almost Anything in a DataGrid Updated: 27 Feb 2005 Allow your DataGrid to edit pictures and a whole range of other data types. C#, VB, Windows, .NET 1.1, ADO.NET, WinForms, VS.NET2003, Dev	Declan Brennan	4.72
How to Manually Create a Typed DataTable Updated: 28 Oct 2008 When you override GetRowType, you also need to override NewRowFromBuilder(). C#, Windows, ADO.NET, Dev	Marc Clifton	4.72
Implementing Audit Trail using Entity Framework - Part 1 Updated: 27 Mar 2009 Implementing Audit Trail using Entity Framework's caching entries C#, .NET (.NET 3.5), SQL Server (SQL 2005), ADO.NET, Dev, Design	Morshed Anwar	4.71
Declarative Transactions using ADO.NET and without Enterprise Services. Updated: 26 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. C#, Windows, .NET 1.0, ADO.NET, Dev	Sandy Place	4.70
Programmatically using ADO.NET and XML Updated: 15 Sep 2004 With ADO.NET, a database can be regarded as a virtual XML document. XPath query and XSLT transformation are naturally available. C#, Windows, .NET 1.0, .NET 1.1, ADO.NET, VS.NET2003, DBA, Dev	Xinjie ZHANG	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. VB, Windows, .NET 1.1, WinForms, VS.NET2003, Dev	patgrape	4.68
Introduction to the Entity Framework Updated: 12 Feb 2009 Looking at the EF and database association patterns. C#.NET 3.5, ADO.NET, Architect, DBA, Dev, Design	Marc Clifton	4.68
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. C#, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	Mark J. Miller	4.67
Light ORM Library for .NET Updated: 25 Dec 2008 This article is about the Light Object-Relational Mapping library. C#, Windows, .NET, SQL Server, Visual Studio, ADO.NET, DBA, Dev	Sergey Busel	4.64
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 C#, Windows, .NET, Visual Studio, DBA, Dev	yolousa72	4.63
C# 2.0 Nullable Data Readers Updated: 20 Jan 2006 An article on nullable data readers for .NET 2.0 nullable types. C#, Windows, .NET 2.0, ADO.NET, VS2005, DBA, Dev	Steve Michelotti	4.59
Component to access databases in the .NET environment Updated: 31 May 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. C#, VB, VC7.NET 1.0, Win2K, WinXP, ASP.NET, Dev	Xiangyang Liu 刘向阳	4.59
Custom DataBindable BusinessObjects and The Typed DataSet Updated: 3 Jan 2007 An article about Custom Businessobjects in conjunction with the DataSet to Retrieve Data C#, Windows, .NET, Visual Studio, DBA, Dev	Emmanuel71	4.58
Using ADO.NET for beginners Updated: 12 Sep 2005 ADO.NET for beginners. C#, SQL.NET 1.1, WinXP, ADO.NET, VS.NET2003, DBA, Dev	Huseyin Altindag	4.58
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. C#, Windows, .NET, Visual Studio, ADO.NET, Dev	David Veeneman	4.57
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. C#, Windows, .NET, Visual Studio, DBA, Dev	Marc Clifton, J. Dunlap	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. C#, Windows, .NET 2.0, ADO.NET, VS2005, DBA, Dev	PIEBALDconsult	4.53
Inserting relational data using DataSet and DataAdapter Updated: 15 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. C#, VC7.NET 1.0, Win2K, WinXP, DBA, Dev	Mauricio Ritter	4.52
DataSet Watch 2.0 Updated: 29 Dec 2006 An enhanced DataSet Visualizer for Visual Studio 2005. C# 2.0, Windows, .NET 2.0VS2005, Dev	Osama Abbas	4.52
Fill a DataSet from delimited text files Updated: 18 Apr 2004 Explains how to fill a dataset with the information stored in a delimited text file C#, Windows, .NET, Visual Studio, DBA, Dev	CoderForRent	4.50
LogParser DataProvider for ADO.NET Updated: 11 May 2007 The article shows how to use SQL features of Microsoft LogParser with ADO.NET C# 2.0, VB 7.x, Windows, .NET 1.1, .NET 2.0, ASP.NET, SQL Server, IIS, VS.NET2003, CEO, DBA, Dev	FrankNight	4.50
Using Oracle Stored Procedures in SqlDataSource Select Command Updated: 5 Jan 2009 How to use Oracle (and other non Microsoft) SP in SqlDataSource Select command C#, SQL, Windows, .NET (.NET 2.0), ASP.NET, ADO.NET, Dev	Petrovik Aleksandar	4.50
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. Windows, .NET, Visual Studio, Dev	David Veeneman	4.37
ADO.NET Entity Framework as Data Access Layer Updated: 30 Oct 2009 ADO.NET Entity Framework as Data Access Layer C#, .NET (.NET 3.5), ADO.NET	sarvesh.upadhyay	4.33
DatabaseAccessor Updated: 23 Aug 2007 A simple base class that encapsulates basic database access functionality C#, Windows, .NET 2.0, Visual Studio, ADO.NET, DBA, Dev	PIEBALDconsult	4.32
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. C#, Windows, .NET, Visual Studio, ADO.NET, Dev	David Veeneman	4.32
.NET DataSet to ADODB Recordset Conversion Updated: 8 Mar 2006 A description of how how to convert a .NET DataSet to an ADODB Recordset. VB, Windows, .NET, ASP.NET, Visual Studio, ADO, ADO.NET, Dev	KRucker	4.29
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. C#, Windows, .NET, Visual Studio, ADO.NET, WinForms, DBA, Dev	Peter Huber SG	4.26
Build database independent ADO.NET programs with Mimer Provider Manager Updated: 31 Mar 2004 Write database independent ADO.NET applications C#, Windows, .NET 1.1, Visual Studio, DBA, Dev	fral	4.25
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. C#, VB, SQL.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP.NET, ADO.NET, VS.NET2003, DBA, Dev	Pinx	4.24
Object Mapping Part II - Schema Code Generator Updated: 17 Dec 2006 Generate an object mapping class from a schema definition. C#, Windows, .NET, Visual Studio, DBA, Dev	Marc Clifton, J. Dunlap	4.22
The ADO.NET OleDbDataReader class Updated: 22 Aug 2003 Accessing database information using the DataReader class from ADO.NET in C# C#, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev	Chris Maunder	4.19
Using ADO.NET in MFC Projects Updated: 9 Aug 2003 Mixing managed and unmanaged code and using .NET library in MFC projects C++/CLI, VC6, VC7, VC7.1, .NET, Win2K, WinXP, Win2003, MFC, Dev	Majid Shahabfar	4.18
Introduction to ADO.NET Sync Services Updated: 18 Sep 2008 This article shows how easily we can create occasionally connected WinForms application using ADO.NET Sync services. VB, Windows, .NET (.NET 3.5), ADO.NET, Dev	Vishal Shukla	4.18
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. VB, Windows, .NET 2.0, ASP.NET, WinForms, VS2005, Dev	nauthiz69_3	4.09
How to avoid writing SQL for ADO.NET DataAdapter Updated: 17 Jan 2005 Automatic creation of SQL for CRUD operations when Strongly Typed DataSets are used. C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003VS.NET2003, DBA, Dev	Dejan Grujic	4.08
WQL DataProvider for ADO.NET Updated: 1 Sep 2004 WQL DataProvider for ADO.NET Windows, .NET, Visual Studio, Dev	Maxim Kazitov	4.07
ADO.NET and Stored Procedures Code Generator Updated: 4 Sep 2008 A VB code generator that reads a SQL Server table and generates ADO.NET code and also Stored Procedures. VB (VB 8.0, VB 9.0), SQL, Windows, .NET, ASP.NET, SQL Server, ADO.NET, DBA, Dev	Johnny Worker	4.07
SQL Bulk Copy with C#.Net Updated: 24 Jan 2007 An article about copying data to SQL within your application. C#, SQL, Windows, .NET, SQL Server, Visual Studio, DBA, Dev	Kadir Camoglu.	4.03
ADO.NET Primer using Managed C++ Updated: 30 Jul 2002 A primer on using ADO.NET with Managed extensions for Visual C++ .NET C++/CLI, VC7, Windows, .NET 1.0, Visual Studio, Dev	Bill Ferreira	4.00
Simplified .NET Data Access API Updated: 10 Jul 2006 An API to simplify access to databases through ADO.NET. C#, XML, Windows, .NET 1.1, .NET 2.0, Visual Studio, ADO.NET, DBA, Dev	BoneSoft	4.00
Yet Another Filter Library Updated: 1 May 2009 A class library that helps to create WHERE clauses in a SQL statement or a filter expression for a System.Data.DataRow select operation. C#, .NET, ADO.NET, Dev	Antonello Genuario	4.00
Using InfoMessage Event of SqlConnection Object Updated: 8 Jun 2009 This article explores the usage of InfoMessage event of SqlConnection object C#, SQL, .NET (.NET 3.5), ADO.NET, DBA, Dev, Design	Balamurali Balaji	4.00
SqlBulkCopy in ADO.NET 2.0, SqlBulkCopy Class in C#, SqlBulkCopy help, SqlBulkCopy guide, SqlBulkCopy class, SqlBulkCopy tutorial Updated: 28 Sep 2007 SqlBulkCopy in ADO.NET 2.0, SqlBulkCopy Class in C#, SqlBulkCopy help, SqlBulkCopy guide, Transferring Data Using SqlBulkCopy - SqlBulkCopy - Copy Table Data Between SQL Servers at High Speeds, perform bulk copies with .NET 2.0's SqlBulkCopy class, SqlBulkCopy tutorial C#, SQL.NET 1.0, .NET 1.1, .NET 2.0, WinXP, .NET 3.0, ASP.NET, ADO.NET, WebForms, SQL 2000, VS.NET2003, VS2005, DBA, Dev	idreeskhan	3.97
Convert XML to Strongly Typed DataSets Updated: 3 Dec 2003 An example of using an XML document to generate a typed DataSet and load it. C#, Windows, .NET, Visual Studio, Dev	Paperless	3.95
Compressing Persisted DataSets Updated: 19 Jun 2005 Using .NET 2.0 DeflateStream and GZipStream to compress persisted DataSets. VB, XML.NET 2.0, WinXP, ADO.NET, VS2005, Dev	Adrian_Moore	3.91
Implementing Audit Trail using Entity Framework - Part 2 Updated: 1 Apr 2009 Implementing Audit Trail using Entity Framework's caching entries C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 3.5), ADO.NET, Architect, Dev	Morshed Anwar	3.86
DRY Database Interactions (.NET 2.0) Updated: 17 Oct 2009 Don't Repeat Yourself (DRY) when working with your database. Simple and easy code that makes it harder to make common mistakes. C#, SQL.NET 2.0, ASP.NET, ADO.NET, Dev	Mark Ericksen	3.83
Business Logic with Entity Framework Updated: 26 May 2009 How to use Entity framework to do some basic logic when a change happens in related Entities or Associations C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 3.0, .NET 3.5, .NET 4.0), SQL Server (SQL 2005, SQL 2008), Visual Studio (VS2008), ADO.NET, WinForms, WebForms, LINQ, Architect, DBA, Dev, QA	Bishoy Ghaly	3.76
ADO.NET – Get the notification events from Managed Providers Updated: 3 May 2001 How to use the event handlers for various ADO.NET connection & data objects. C#, VC7, Windows, .NET 1.0, Dev	Naveen K Kohli	3.74
Simple ADO.NET Database Read, Insert, Update and Delete using C#. Updated: 30 May 2001 An easy introduction to accessing databases using the ADO classes. It includes how to read and write integers, strings and dates. C#.NET 1.0, Win2K, Visual Studio, Dev	John McTainsh	3.73
Bulk Record Insert for Access Updated: 5 Jan 2007 This article demonstrates how perform a bulk 'Insert' with MS Access. C#, Windows, .NET, Visual Studio, DBA, Dev	~~_{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. C#, Windows, .NET 1.1VS.NET2003, DBA, Dev	Karthik Krishnaswami	3.67
Converting a DataSet to a Generic List Updated: 18 Jul 2009 Presents a simple utility framework that helps in converting DataSets to generic Lists. C# 1.0, C# 2.0, C# 3.0, Windows, .NET 3.5, ADO.NET, Dev	Benzi K. Ahamed	3.67
A Handy Code to Get Your Project Connected to Any Database by ADO.NET Updated: 16 Jul 2009 Purely object oriented ADO code component to get your project running, no matter what database you are using at the backend. Specialised for SQL Server. C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 1.1, .NET 2.0, .NET 3.0, .NET 3.5), ASP.NET, ADO.NET, DBA, Dev	MeraMBA.com	3.63
Replace SqlDataReader with a DynamicSqlDataReader Updated: 31 May 2009 Remove those strings from your .NET 4.0 applications using the dynamic feature. C#.NET 4.0, ADO.NET, Dev	TimMerksem	3.60
ADO.NET Updated: 23 Dec 2008 Understanding ADO.NET C#, ADO.NET, WinForms, Dev	logicchild	3.50
Simple Sample with Entity Framework Updated: 9 Jul 2009 Simple sample with entity framework in 3 layers with ASP.NET C# (C# 3.0), .NET (.NET 3.5), ASP.NET, ADO.NET, Dev	stexavcar	3.43
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. C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev	Henri G Demers	3.42
Multiple Database Connection File Manager Updated: 31 Jul 2008 Utility to manage multiple DB connection strings for an application. C#, XML, Windows (WinXP, Win2003, Vista), .NET (.NET 3.5), SQL Server (SQL 2000, SQL 2005), ADO.NET, Oracle, DBA, Dev, QA, SysAdmin	TSells	3.40
Using SqlBulkCopy with ASP.NET 2.0 Updated: 25 Dec 2008 An article to explain the use of SqlBulkCopy class in ASP.NET C# (C# 2.0), ASP, ASP.NET, ADO.NET, WebForms	Aman Bhullar	3.40
How to save data from a DataSet into a T-SQL table Updated: 5 Nov 2008 This article tells you how to save data from a DataSet into T-SQL tables. C# (C# 1.0, C# 2.0, C# 3.0), XML, SQL, Windows, ASP.NET, ADO.NET, Dev	Sandeep Aparajit	3.35
Schema.ini override and bulk upload using SQLXML Updated: 15 Mar 2007 Schema.ini override and bulk upload using SQLXML C#, VB, XML, SQL, Windows, .NET 1.1, Visual Studio, SQL 2000, DBA, Dev	Aravind Rajagopal K	3.33
Database Transactions with Multiple TableAdpaters Updated: 13 Mar 2008 An article on using Transactions with Strongly Typed Datasets and multiple Table Adpaters while taking advantage of Partial Classes. C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 2.0), Visual Studio (VS2005), ADO.NET, Dev	Brice Schagane	3.32
Beginner’s Tutorial on Using the Firebird ADO.NET Client 2.5 Updated: 25 Mar 2009 In this article, I will show you how to interface your simple C# applications to the FirebirdSQL Server using the Firebird ADO.NET Client 2.5. SQL, C# 3.0, Windows, ADO.NET, VS2008, DBA, Dev	Maximus Byamukama	3.29
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. C# 2.0, Windows, .NET 3.0, ASP.NET, Visual Studio, WebForms, Dev	Murali Krishna .Y	3.25
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. C#, Windows, .NET, Visual Studio, LINQ, DBA, Dev	Dan Radu	3.21
Working with DataGrid in VC++.NET Updated: 15 Dec 2004 This article demonstrates the DataGrid , ADO.NET components, and storing data into the database and retrieving from the same. C++/CLI, VC7, VC7.1, Windows, .NET, ADO.NET, VS.NET2003, Dev	Arul Nayagam C A	3.20
AutoIncrement in a disconnected DataSet Updated: 25 Sep 2005 Working with disconnected DataSets that contain autoincrement count. C#, Windows, .NET CF, .NET 1.1, ADO.NET, VS.NET2003, Dev	balazs_hideghety	3.20
Check if a table or field exists in a database Updated: 13 Nov 2008 Function to check if a table or field exists in an MS Access or SQL Server database. VB, .NET, ADO.NET, Dev	R. Syed	3.18
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. C#, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	TeX HeX	3.00
The SqlReader Object Updated: 29 Dec 2006 Cutting your code time in half using a smart SQL frontend. C#, Windows, .NET, Visual Studio, DBA, Dev	David Morton	2.92
Recommended ADO.NET Data Access Strategies Updated: 15 Sep 2002 ADO.NET provides two basic strategies for how you work with the disconnected data model C#, VB, Windows, .NET 1.0, ASP.NET, Visual Studio, Dev	reddy123987	2.89
Portable SQL with ANTLR - Unedited Updated: 25 Feb 2008 Architectural overview of the MacroScope portable SQL ADO.NET provider C# (C# 1.0, C# 2.0, C# 3.0)	vb3	2.88
Interbase and Visual C# .NET Updated: 11 Jun 2008 A solution managing InterBase DB's with C# .NET C# (C# 1.0, C# 2.0, C# 3.0), Windows (WinXP, Win2003, Vista), Visual Studio (VS.NET2003, VS2005, VS2008), WinForms, Dev	pechan00000	2.83
Generate Stored Procedure Wrapper Methods and Associated Wrapper Classes Updated: 28 Sep 2008 This tool helps developers generate their ADO.NET stored procedure wrapper methods and any related strongly-typed data object class. C#, .NET, ASP.NET, ADO.NET, Architect, Dev	Sunny Ahuwanya	2.83
Using Data Relation with Data Table Updated: 6 Apr 2007 This article exemplifies how to use the Data Relation of ADO.NET with Data Table to create the in memory Data Relation between two tables. VB 7.x, Windows, .NET 1.1, Dev	Aakash Jain	2.65
An Overview on ADO.NET Updated: 22 Aug 2009 How to understand data access in .NET. C# 1.0, C# 2.0, C# 3.0, .NET, ADO.NET, Dev	logicchild	2.27
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! C#, VB, JScript .NET, Forth.NET, .NET CF, Mobile, .NET 1.1, Win2K, WinXP, ADO.NET, VS.NET2003, Dev	Pinx	2.25
.NET DataSet filter demonstration Updated: 26 Jul 2007 This article explains how to filter rows in a DataSet/DataTable. The example provided will help you get information faster. C#, Windows, .NET 1.0, .NET 1.1, .NET 2.0, .NET 3.0VS.NET2003, VS2005, Dev	NinethSense	2.11
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. C#, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev	Xodiak	2.00
DataQuicker 0.9.0 Updated: 27 Sep 2005 DataQuicker takes the transparent level, speeds up your application building and reduces the coupling between application and database. It supports convertion from table/view to DAL directly with accessional tools. It can nearly cut off all your efforts on DAL design and coding... C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP.NET, ADO, VS.NET2003, Dev	Eunge	2.00
Transpose a DataTable using C# Updated: 21 Nov 2009 Transpose DataTable rows into columns and vice versa using C#. C#, .NET, ASP.NET, ADO.NET, Dev	S.Satheesh	1.20
ADO.NET and OPENXML to Perform Bulk Database Operations Updated: 17 Dec 2007 Explains how to send bulk records to a database using OPENXML. XML, C# 1.0, C# 2.0, C# 3.0.NET 1.0, .NET 1.1, .NET 2.0, .NET 3.0, .NET 3.5, ADO.NET, SQL 2000, SQL 2005, DBA, Dev	mfmaneef
Changing column collations through C# and ADO.NET - Unedited Updated: 28 Sep 2009 Today we look into how collations in Sql Server bugged me while trying to get code generation to work on a database different from what it was originally build on. We also look at how I solved the problem (which is with some cool C# and WPF code).The problem contextLets take a look at the big pictu All Topics	mrjvdveen
Database - COM			top
Title / Updated	Author	Score
Exposing tabular data from your COM object - Part 2 Updated: 28 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! SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev	Len Holgate	4.95
How to Integrate an OLE Object with SQL Server Updated: 15 Jun 2009 This article will demonstrate how we can integrate T-SQL with an external application. C# (C# 2.0, C# 3.0, C# 4.0), .NET (.NET 2.0, .NET 3.0, .NET 3.5), SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), Visual Studio (VS2008), COM, COM+	Md. Marufuzzaman	4.83
Exposing tabular data from your COM object - Part 3 Updated: 28 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. SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev	Len Holgate	4.82
How to Integrate an OLE Object with SQL Server v2 - Unedited Updated: 22 Aug 2009 This article will give you an idea about how to integrate an OLE Object that is a com+ api with SQL Server and write a message into a windows event log. SQL, Windows, SQL Server (SQL 2000), Architect, DBA	Md. Marufuzzaman	4.76
Making ATL OLE DB Provider templates support updating of data - Part 1 Updated: 20 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! SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev	Len Holgate	4.50
Exposing tabular data from your COM object - Part 1 Updated: 28 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! SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev	Len Holgate	4.33
Making ATL OLE DB Provider templates support updating of data - Part 2 Updated: 20 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! SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev	Len Holgate	3.60
Database - DAO			top
Title / Updated	Author	Score
Using Data Access Objects (DAO) with WTL Updated: 5 May 2008 DAO is old, obsolete, yet it is still very versatile and developer friendly. C++ (VC8.0), Windows (WinXP), WTL, Dev	CodeWizard1951	4.74
CByteArrayFile - storing objects in databases using DAO Updated: 17 Mar 2000 A class used to serialize object into a database field SQL, VC6, SQL Server, MFC, DBA, Dev	Daniel Kaminski	4.33
DAO library extension Updated: 4 Mar 2002 My added DAO functionality makes database reading and writing easier SQL, VC6, SQL Server, MFC, DBA, Dev	Kevin Smith	3.47
Using CompactDatabase function with AppWizard's database application Updated: 17 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. SQL, VC6WinXP, SQL Server, DBA, Dev	Anton P. Ivanov	3.14
How to use DAO in Visual C++ without MFC Updated: 26 Mar 2006 Use the #import directive and discover the DAO type library. C++, Windows, Visual Studio, COM, Dev	Yuriy Tkachenko	3.00
MTDaoRecordset : A DAO Class that supports MultiThreading Updated: 4 Sep 2002 If you're sufferring from dao cracks in multithreaded environment, this article will be useful to you SQL, VC6, VC7, Windows, SQL Server, Visual Studio, MFC, DBA, Dev	Kevin Hua	2.78
ATL - Data Access			top
Title / Updated	Author	Score
A uniform interface for large texts for a C# SQL client Updated: 26 Jul 2009 The article provides a simple interface for handling large text in SqlClient and C# file streams. SQL, C# 1.0, C# 2.0, C# 3.0.NET 2.0, .NET 3.0SQL 2005, SQL 2008, Dev	AlexS9999	5.00
Fast and Easy Data Access with oSo.SimpleSql Updated: 20 Jun 2009 A Data Access Framework using Generics, Lambda Expressions, Fluent Interfaces, and the SqlProviderFactory. C# (C# 3.0), .NET (.NET 3.5), ASP.NET, ADO.NET, Dev	Charles T II	4.94
Design and Implementation of an Attribute-Driven, Caching Data Abstraction Layer Updated: 21 Jul 2008 An easy-to-use, attribute-driven data abstraction layer with multi-database support, intelligent caching, transparent encryption, multi-property sorting, property change tracking, etc. C# (C# 1.0, C# 2.0, C# 3.0), Architect, Dev	owen654321	4.82
A Detailed Data Binding Tutorial Updated: 25 Mar 2008 Demonstrates a variety of Windows Forms data binding features through several simple examples. C# (C# 2.0, C# 3.0), .NET CF, .NET (.NET 2.0, .NET 3.0, .NET 3.5), Visual Studio (VS2005, VS2008), ADO.NET, Dev	Qwertie	4.76
NHibernate and Complex Types for Native Keys - Unedited Updated: 3 Jun 2009 Learn how to use complex classes as primary (not composite!) keys with NHibernate. C#, Windows, .NET (.NET 3.0, .NET 3.5), ASP.NET, Architect, DBA, Dev	Jeremy Likness	4.71
Abstract Data Access Layer Design Updated: 5 Sep 2009 The present document tries to describe the architecture of a specific layer of access to data for relational databases. This document tries to present/display a form to automate tasks of access to data. C# (C# 1.0, C# 2.0, C# 3.0), SQL, All Topics, Architect, Design	Anwar Ibáñez O'Kamell	4.60
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 VB, Windows, .NET, Visual Studio, Dev	MikeInNH	4.59
Implementing Repository Pattern With Entity Framework Updated: 11 Jun 2009 Implement Repository Pattern in data access layer with Entity Framework All Topics, Architect	Morshed Anwar	4.57
Oracle Stored Procedure Wrapper Updated: 11 Aug 2004 This small VB.NET application allows you to quickly generate VB.NET wrapper code for your Oracle stored procedures. VB, SQL, Windows, .NET 1.1VS.NET2003, DBA, Dev	Barry Etter	4.50
A Fast CSV Writer Using ATL Updated: 7 Jun 2007 A Fast CSV Writer Using ATL VC6, VC8.0, C# 2.0.NET 2.0, Win2K, WinXP, ATL, COM, ADO, VS2005, Dev	callmepls	4.50
Microsoft Indexing Service How-To Updated: 9 Jul 2007 This article describes how to provide full text search using Microsoft Indexing Service in .NET applications. C# 1.0, C# 2.0, C# 3.0, Windows, .NET 1.1, .NET 2.0, .NET 3.0, ADO.NET, DBA, Dev	Ilya Verbitskiy	4.46
Simulating Recordsets with ADO.NET Updated: 2 Oct 2004 A proposed class to simulate the ADODB.Recordset behavior in .NET. VB, SQL, Windows, .NET 1.0, .NET 1.1, ADO, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	Alberto Venditti	4.45
Schema Compare Tool for Oracle Updated: 20 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. VB, SQL, Windows, .NET 1.1VS.NET2003, DBA, Dev	Barry Etter	4.40
DataGrid101: Using Windows.Forms DataGrid Updated: 14 May 2003 Tutorial on the usage of Windows.Forms.DataGrid VB, Windows, .NET 1.0, Dev	omri	4.38
ADO.NET RecordSet Library Updated: 18 Jul 2006 An ADO.NET recordset class. VB, Windows, .NET, Visual Studio, ADO.NET, Dev	João Martins	4.37
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. VB, SQL, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	Duncan Edwards Jones	4.25
QuickWhere: create complex forms for searching into databases Updated: 21 Feb 2004 QuickWhere is component that helps you in the creation of complex forms for searching into databases. VB.NET 1.0, Win2K, WinXP, Win2003, Dev	DragD	4.19
Data binding concepts in .NET windows forms Updated: 15 Feb 2003 A detailed look at the concepts involved in data binding and controlling data binding. C#, VB 6.NET 1.0, Win2K, WinXP, Dev	Tarun Jain	4.14
Dynamic Reports UsingSQL Queries Updated: 23 Nov 2005 Dynamic report by using the PrintDocument component with SQL queries. VB, Windows, .NET 1.1, ADO.NET, WinForms, VS.NET2003, CEO, Architect, DBA, Dev, QA	Pakorn Indhatep	4.12
Simple Data Access in C# Updated: 11 Jan 2009 Fast and easy to use data access class library. C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 2.0, .NET 3.0, .NET 3.5), SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), Visual Studio (VS2005, VS2008), ADO.NET, Architect, Dev	6opuc	4.04
Data Access Component Updated: 30 Apr 2009 An open source Data Access Component C# (C# 2.0), XML, SQL, Windows, .NET, ASP.NET, SQL Server, ADO.NET, LINQ, MySQL, Oracle, Architect, Dev, Design	zhongzf	3.86
ADO.NET and UDL Updated: 30 Sep 2005 Using Data Link files with SQLClient and OracleClient. C#, VB, Windows, .NET 1.1, ADO.NET, VS.NET2003, Dev	ra1234567890	3.83
Article 2 - Display data using DataSet and DataGrid controls through Whidbey (VB.NET) Updated: 9 May 2004 This article explains how we can display data using DataSet and DataGrid control after the database is created. VB, VC6, VC7, VC7.1.NET 2.0, Win2K, WinXP, Win2003, MFC, VS2005, Dev	benoyraj	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. VB, Windows, .NET 2.0, ADO.NET, VS2005, Dev	Nikhil Contractor	3.81
How to Perform a Database-independent Databind with UDLA Framework Updated: 12 Dec 2008 How to perform a database-independent databind with UDLA (Universal Database Layer Access) C#, .NET, ASP.NET, Win32, Win64, ADO.NET, Dev	Sir Zeppa'Man	3.80
Easy Data Access Layer Updated: 10 Mar 2009 This library gives an easy data access tool for different data sources. C# 2.0, C# 3.0, .NET, ADO.NET, Dev	eng. Plamen Kovandjiev	3.79
ATL COM and ADO Updated: 3 Apr 2001 An ATL Component that uses ADO for data. VC6, VB 6, ATL, Dev	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. VB, Windows, .NET, Visual Studio, Dev	Settas Antonis	3.68
Implementing a Provider Independent Data Access Layer in .NET Updated: 3 Nov 2003 This article tells how you can implement a DAL which is provider independant. VB, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev	Manoj G	3.67
Database Connector Updated: 28 Jan 2009 A system of plug-ins that provide very simple database access C#.NET 2.0, ADO.NET, DBA	PIEBALDconsult	3.60
Creating a DAL with SubSonic Updated: 8 Nov 2007 Creating a DAL with SubSonic. C# 2.0, Windows, .NET 2.0SQL 2000, SQL 2005, VS2005, DBA, Dev	Michael Ceranski	3.59
Overview of XQuiSoft Data Using the Provider Pattern (Open Source) Updated: 16 Jun 2009 A data abstraction layer for .NET applications. Write your application code to be database neutral. Swap out the type of database your application uses without updating or even recompiling your business components. C#, Windows, .NET, SQL Server, Visual Studio, ADO.NET, Oracle, Architect, DBA, Dev	Mike Lang	3.50
Dynamically Generate C# Data Access Code for Microsoft SQL and Other Databases Updated: 19 Dec 2008 With this tool, dynamically generate C# data layer code (CRUD functions) for Microsoft SQL and other databases C# 2.0, Windows, .NET, Visual Studio, DBA, Dev	mattraffel	3.40
EasyData - A simple and fast way to work with data Updated: 11 Apr 2005 This code shows a very simple way to work with data, using XML serializer, and a little trick with ArrayLists. VB, XML.NET 1.1, WinXPVS.NET2003, Dev	rmaax	3.36
Database local cache Updated: 14 Dec 2007 A C# class that uses the local file system to cache binary objects stored in a database. C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 2.0, .NET 3.0, .NET 3.5), SQL Server (SQL 2000, SQL 2005), ADO.NET, Dev	konamiman34	3.33
Custom Data Grid with Field Chooser functionality Updated: 1 Jan 2003 A datagrid control with field chooser context menu C#, VB.NET 1.0, Win2K, WinXP, Dev	GKris	3.32
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). VB, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	Lachlan Keown	3.31
Runtime Connection Wizard Updated: 10 Feb 2007 A control to define and save SQL Connections in runtime VB, Windows, .NET, Visual Studio, WinForms, Dev	Jakob Lithner	3.29
SQL Database Editor Updated: 25 Aug 2004 An article on a SQL database editor. VB, SQL.NET 1.1, Win2K, WinXP, Win2003, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	Charl Pohlmann	3.29
Data Accessor Class for VB.NET and ASP.NET Updated: 19 Mar 2003 Wrap up Routine Data Accessing Code into a class VB, Windows, .NET 1.0, ASP.NET, Visual Studio, Dev	David Bernett	3.24
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) VB, Windows, .NET 2.0VS2005, Dev	The Burger	3.00
Easier Database Access with Diamond Binding (Part 2) Updated: 18 Sep 2007 An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding SQL, C# 2.0.NET 2.0, Win2K, WinXP, Win2003, Vista, .NET 3.0, WebForms, SQL 2000, SQL 2005, VS2005, Architect, DBA, Dev	Matty22	2.93
Databinding with Cross Reference table (many to many) Updated: 20 Apr 2004 This article shows how to databind master and details DataGrids (Winforms) when using a cross reference table. VB, .NET, Win2K, WinXP, Win2003, Visual Studio, Dev	ss2art	2.93
Developing Abstract Functions for Accessing Stored Procedures Updated: 3 Apr 2008 This article explains about developing abstract functions for accessing Stored Procedures. VB (VB 7.x, VB 8.0, VB 9.0, VB 6), Windows, .NET, ADO.NET, Dev	Ben Kotvis	2.87
Inheriting Data Access Layer functions Updated: 19 Jul 2004 Simplify DAL by using Reflection and database table naming conventions VB, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev	Nigel-Findlater	2.45
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. VB, Windows, .NET, Visual Studio, Dev	SUNILT	2.40
Generating a data layer using SubSonic Updated: 20 May 2008 This article will demonstrate how to generate a data access layer using SubSonic. C# (C# 1.0, C# 2.0, C# 3.0), XML, .NET, ADO.NET, Dev	dnpro	2.20
.NET - Databases			top
Title / Updated	Author	Score
A SQLite Server/Client Implementation Updated: 23 Jan 2008 Implementing server/client architecture for the great SQLite! C++, C++/CLI, C, DBA, Dev	Daniel Cohen Gindi	4.91
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. SQL, Windows, .NET 2.0, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	craigd	4.76
Stored Procedure Invocation Code Generator for VB, C# and JScript.NET Updated: 14 Jun 2003 Stored Procedure Invocation Code Generator for VB, C# and JScript.NET C#, VB, JScript .NET, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev	Simon Wilson	4.71
NetBase - A Minimal .NET Database with a Small SQL parser, Part 2 Updated: 3 Nov 2009 NetBase is a small database system that reads and writes to DBF-like files, with a SQL front-end. The second part of this series discusses the SQL parser. C#, SQL, Windows, .NET, Visual Studio, Architect, DBA, Dev	buttonpusher	4.68
DevShot - Database Snapshots for Developers Updated: 25 Nov 2005 How to create runtime backups from SQL Server 2005 and restore them. VB, SQL, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev	Tommi G	4.67
Accessing XML Using Insert/Update/Delete/Query Statements Updated: 12 Apr 2005 A psuedo-database for XML. C#, Windows, .NET 1.1VS.NET2003, Dev	Marc Clifton	4.64
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. SQL, Windows, .NET, Visual Studio, SQL 2005, DBA, Dev	Akram Hussein	4.63
An introduction to a post-relational database for .NET : Matisse - Part 5 Updated: 29 Mar 2004 Object-oriented programming with a post-relational database C#, VB.NET 1.1, Win2K, WinXP, Win2003, ASP.NET, Visual Studio, Dev	John Sasak	4.62
An introduction to a post-relational database for .NET, Matisse - Part 1 Updated: 14 Jun 2004 Step by step introduction to a new generation database for .NET. C#, VB.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP.NET, Visual Studio, Dev	John Sasak	4.62
Generate SQL Insert statements for your SQL Server 2000 Database Updated: 13 Apr 2004 Deploy your SQL Server 2000 database with scripts. VB.NET 1.1, Win2K, WinXPVS.NET2003, Dev	daffrey	4.60
.NET Data Access Class for Exchange 2000 Webstore Updated: 16 Aug 2005 Assembly written in VB.NET that accesses Exchange 2000 Webstore data, using WEBDAV. C#, VB, Windows, .NET 1.0, Visual Studio, Dev	clementsm	4.59
SQL Agent: A Job Scheduler Framework Updated: 8 May 2008 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! VB, XML, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev	Danilo Corallo	4.54
XML data type tips in SQL Server 2005 Updated: 9 Nov 2006 Techniques for using the XML data type for storing data. C#, VB, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev	Howard Richards	4.54
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#. C#, Windows, .NET 1.1, ADO.NET, VS.NET2003, Dev	Chad Z. Hower aka Kudzu	4.53
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. VB, C# 2.0, Windows, .NET 2.0SQL 2000, VS.NET2003, VS2005, DBA, Dev	hoquet	4.49
Connect to DB2 from Microsoft .NET Updated: 28 Aug 2003 Microsoft .NET and Db2 conenction C#, .NET, Win2K, WinXP, Win2003, Visual Studio, Dev	Sreejumon	4.46
SQL Server backup utility Updated: 3 Jun 2006 Restore/backup selected objects in SQL Server. VB.NET 2.0, WinXP, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	Shabdar Ghata	4.46
An introduction to a post-relational database for .NET, Matisse - Part 3 Updated: 25 Mar 2004 Step by step guide for .NET programming with a Post-Relational Database C++, C#, VB.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP, ASP.NET, Visual Studio, MFC, Dev	John Sasak	4.38
Read Tables from SAP R/3 using SAP.NET Connector Updated: 19 Feb 2004 Reading SAP R/3 made easy. C#, Windows, .NET 1.1VS.NET2003, Dev	hardteck	4.36
An introduction to a post-relational database for .NET : Matisse - Part 4 Updated: 26 Apr 2004 ADO.NET programming with a post-relational database C++, C#, VB.NET 1.1, Win2K, WinXP, Win2003, ASP.NET, Visual Studio, MFC, Dev	John Sasak	4.34
An Oracle Query Tool (part 1) Updated: 23 Feb 2006 An Oracle query tool with syntax highlighting and a tabbed MDI interface. VB, Windows, .NET, ADO.NET, WinForms, VS2005, DBA, Dev	Danilo Corallo	4.34
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. VB, SQL, Windows, .NET 2.0, Visual Studio, SQL 2005, DBA, Dev	Andrew Timberlake-Newell	4.30
Optimizing building trees from a database Updated: 20 Jan 2005 How a different way of looking at a problem can result in better performance. C#, Windows, .NET 1.1, ADO.NET, VS.NET2003, Dev	NielsHoldijk	4.29
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. VB, SQL, Windows, .NET 2.0, ADO, ADO.NET, SQL 2000, SQL 2005, VS2005, DBA, Dev	salysle	4.29
PostgreSQL & PostGis Operations Updated: 10 Jun 2009 In this article, I would like to show you how to (backup, restore) DB & converting between PostGIS & Esri shape file C# (C# 3.0), Windows (Win2003), Visual Studio (VS2008), DBA, Dev	Thabet Tech	4.29
UI architecture for managing DTS packages Updated: 3 Aug 2005 This articles details a UI architecture for managing DTS packages. Windows, .NET, Architect, DBA, Dev	Narayana Rao Surapaneni, krmpradeep	4.27
NetBase - A Minimal .NET Database with a Small SQL Parser, Part 1 Updated: 3 Nov 2009 This is a small database system that reads and writes to DBF-like files, with a SQL front-end. C#, SQL, Windows, .NET, Visual Studio, Architect, Dev	buttonpusher	4.23
.NET Data Persistence: SQL Server vs. Matisse vs. FastObjects Updated: 10 May 2004 An article with source code examining the development speed and performance capability of .NET, Matisse and FastObjects C#, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev	A.Z. Rosenberg	4.21
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. C#, VB, SQL, Windows, .NET 1.1, ADO.NET, VS.NET2003, Architect, DBA, Dev	David Wulff	4.13
Object-Oriented database design with the DatabaseObjects library Updated: 31 Jan 2007 Demonstrates creating object-oriented database systems with the DatabaseObjects library. VB, Windows, .NET, Visual Studio, Dev	Toby Wicks	4.00
LWDbComponents - Another Database Component Updated: 10 Dec 2006 A full featured and easy to use DB component. VB, XML, SQL, Windows, .NET 2.0, ADO.NET, VS2005, DBA, Dev	Luis Angel R.C.	4.00
Single Object Property Database Updated: 30 Oct 2007 Object Properties Snapshot Management C# 2.0, Windows, .NET, Visual Studio, Dev	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. VB, SQL, Windows, .NET, Visual Studio, DBA, Dev	wduros1	3.95
DataQuicker (ORM) 0.9.4: Introduction Updated: 27 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. C#.NET 1.1, Win2K, WinXP, Win2003, Vista, ADO.NET, VS.NET2003, Dev	Eunge	3.92
Getting Started With Object Databases Updated: 13 Jul 2006 A programmatic introduction to object database storage and a short comparison of ODBMS and RDBMS systems C#, Windows, .NET, Visual Studio, Dev	carlos.muentes	3.92
Database Resetter Updated: 5 Oct 2004 A little tool to make life while developing with databases a little easier. VB, SQL, Windows, .NET 1.1SQL 2000, VS.NET2003, DBA, Dev	Michiel de Rond	3.85
Creating Managed Objects in SQL Server 2005 Updated: 21 Dec 2005 Creating managed objects in SQL Server 2005. C#, Windows, .NET, Visual Studio, SQL 2005, DBA, Dev	Nishith Pathak	3.84
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. C#, SQL, Windows, .NET, ASP.NET, Visual Studio, ADO, ADO.NET, Architect, DBA, Dev	firefalcon	3.83
An introduction to a post-relational database for .NET, Matisse - Part 2 Updated: 23 May 2004 Step by step introduction to a new generation database for .NET: Schema definition. C#, VB.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP, ASP.NET, Visual Studio, Dev	John Sasak	3.82
Avoid Max Open Cursor Error In .NET Updated: 18 Aug 2004 Handling Oracle Max Open cursor error when fetching multiple rows in .NET. C#, SQL.NET 1.0, .NET 1.1, Win2KVS.NET2003, Architect, DBA, Dev	Vivek Shaurya	3.80
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. C#, VB, SQL, Windows, .NET 1.1, .NET 2.0, ADO.NET, VS.NET2003, VS2005, DBA, Dev	Alvaro Mendez	3.79
VB.NET Class Library: Access Table Interface Updated: 12 Sep 2006 A toolkit that simplifies querying and updating Access database tables. VB, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	George B Gilbert	3.67
Trouble with Installing SQL 2005 After Uninstalling CTP/Beta Updated: 17 Dec 2005 After uninstalling the SQL Server 2005 CTP, if you are unable to install the release version, here is what you should do. SQL, Windows, .NET, Visual Studio, SQL 2005, Architect, DBA, Dev	Dewey Vozel	3.59
Using SQLParameters with VB.NET/C# Updated: 2 Sep 2004 Using SqlParameters with stored procedures in .NET. C#, VB, SQL, Windows, .NET 1.0, .NET 1.1, ASP.NET, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	dotScott	3.53
Using a generic data abstraction layer for database access in .NET Updated: 22 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. C#.NET 1.0, .NET 1.1, Win2K, WinXP, Visual Studio, Dev	Rob van der Veer	3.48
An OO Persistence Approach using Reflection and Attributes in C# Updated: 9 Jun 2003 Describes how to use C# attributes , ADO.NET and C# to persist objects to databases. C++, C#, .NET, Win2K, WinXP, Win2003, Visual Studio, MFC, Dev	Dan Bunea	3.44
SQL Database Relation Builder Updated: 23 Aug 2004 An article on automatically building the relationships between tables in a DataSet. VB, SQL.NET 1.1, Win2K, WinXP, Win2003, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	Charl Pohlmann	3.33
Custom Configuration SQL Connection String Section Updated: 23 Jan 2006 This solution demonstrates enforcing valid SQL connection strings in the App.Config file. C#, XML, XSLT, Windows, .NET 1.1VS.NET2003, Dev	Ted Bouskill	3.30
.NET MySQL Connexion V 1.2 Updated: 17 Jul 2003 Class Library for MySQL request VB.NET 1.0, Win2K, WinXP, ASP.NET, MySQL, Dev	Romelard Fabrice (Alias F___)	3.26
Simulating Stored Procedures in Microsoft Access using Enterprise Library Application Blocks Updated: 25 Jul 2005 Simulating stored procedures in Microsoft Access using Enterprise Library Application Blocks. VB, Windows, .NET 1.1VS.NET2003, Dev	defwebserver	3.26
Convert DateTime To .NET Ticks Using T-SQL Updated: 28 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 SQL, Windows, .NET 1.0, .NET 1.1SQL 2000, DBA, Dev	Eron Wright	3.25
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. VB, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	Malik Nasir	3.14
Controlling Text Field Input on Key Press Updated: 31 Oct 2007 Shows the basics of controlling input on a controls key press event VB 8.0, Windows, .NET, Visual Studio, DBA, Dev	The ANZAC	2.71
Best Practice in File Storage while Building Applications - Database (Blob Storage) Vs File System Updated: 7 Aug 2008 This article explains the best strategy to be followed while designing data storage applications by System Architects Windows, .NET, Win32, SQL Server, Visual Studio, ADO, ADO.NET, Architect, DBA, Dev, Design	Ziyad Mohammad	2.25
Database - General			top
Title / Updated	Author	Score
SQL. How to find holes in sequences. - Unedited Updated: 17 Jun 2009 Hello,Did you ever been asked to find all holes in document numbers (docs are sequentially numbered)? I had to do this search twice. Once for auditing purposes: holes may mean some sort of forgery. And now customers want to reuse numbers of deleted docs. And how do you think holes can be found using WCF	Anton Burtsev	5.00
SQL. Running Totals. - Unedited Updated: 20 Jun 2009 Running totals... Accountants like them so much. But there is no way in SQL to make efficient query that calculate running total. Why? What is running total? It is just previous running total plus current value. But SQL syntax does not give an access to previous rows. WCF	Anton Burtsev	5.00
SQL. Fast GUID List Generator. - Unedited Updated: 27 Jun 2009 The article shows how one can use MS SQL Server to generate millions of guids in seconds. WCF	Anton Burtsev	5.00
SQLite for C# – Part 8 – Loading CSV/Pipe into SQLite via command line - Unedited Updated: 19 Sep 2009 Ever wondered how hard it would be to load a CSV file into a SQLite database? SQL, DBA, Dev	GarethI	5.00
Remotable Multi-tiered Object-centric Domain Framework Updated: 23 Jul 2007 An article on building an agile multi-tiered business framework C# 2.0, Windows, .NET 2.0, Visual Studio, WinForms, DBA, Dev	Emmanuel Nuyttens	4.84
Introduction to WTL OLE DB Database Applications Updated: 20 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) SQL, VC6Win2K, WinXP, SQL Server, ATL, WTL, DBA, Dev	Ed Gadziemski	4.84
Hands on how to configure the Microsoft MSDE Updated: 14 Nov 2004 An article on how to setup and configure the MSFT MSDE 2000. C++, SQLWin2K, WinXP, Win2003, Visual Studio, SQL 2000, DBA, Dev	Lars-Inge Tønnessen	4.83
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. C#, Windows, .NET 2.0, ADO.NET, VS2005, DBA, Dev	Sascha Knopf	4.82
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 C#, SQL, Windows, .NET, DBA, Dev	yincekara	4.82
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) C# 1.0, C# 3.0, VB 7.x, VB 9.0, Windows, .NET CF, Mobile, .NET 1.0, .NET 1.1, .NET 2.0, Mono, .NET 3.0, ASP.NET, Visual Studio, ADO.NET, WebForms, Architect, Dev	Marcos Meli	4.79
Dynamic... But Fast: The Tale of Three Monkeys, A Wolf and the DynamicMethod and ILGenerator Classes Updated: 21 Jul 2008 How to use the DynamicMethod and ILGenerator classes to create dynamic code at runtime that outperforms reflection VB, C# 2.0, C# 3.0, Windows, .NET 2.0, .NET 3.0, ASP.NET, VS2005, Dev	Herbrandson	4.79
CppSQLite - C++ Wrapper for SQLite Updated: 28 Oct 2004 A C++ wrapper around the SQLite embedded database library. SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, VS.NET2003, DBA, Dev	Rob Groves	4.79
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. C#, SQL, .NET, Win2K, WinXP, Win2003, Vista, TabletPC, Embedded, Visual Studio, SQL 2000, SQL 2005, SQL CE, Architect, DBA, Dev	Colin Angus Mackay	4.78
Using CLongBinary for BLOBs Updated: 30 Nov 1999 SQL, VC6, SQL Server, DBA, Dev	Shekar Narayanan	4.78
Stored Procedure Class Wizard (SPCW) Updated: 8 May 2001 A tool to generate class files to implement stored procedures SQL, VC6, SQL Server, DBA, Dev	George Poulose	4.77
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 C#, SQL, Windows, .NET, Visual Studio, DBA, Dev	David Veeneman	4.75
Using Blobs with WTL OLE DB Database Applications Updated: 6 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" VC6, VC7Win2K, WinXP, WTL, Dev	Ed Gadziemski	4.75
The alxBase classes for work with DBF files Updated: 5 Nov 2002 The alxBase classes for work with dbf files. SQL, VC6, VC7Win2K, WinXP, SQL Server, MFC, DBA, Dev	Alexey	4.73
Best Practice for Binding WinForms ListControls Updated: 26 Sep 2004 This article demonstrates the best technique for databinding the ListBox and ComboBox controls in .NET Windows Forms C#, VB, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev	Scott McMaster	4.72
The CAccessReports class Updated: 14 Mar 2000 A class for Printing and Viewing MS Access Reports SQL, VC6, SQL Server, MFC, DBA, Dev	Tom Archer	4.71
A scripted SQL query generation framework with IDE: SQLpp (v1.4) Updated: 12 Sep 2003 A helper framework for generation of SQL queries in C++ and Lua SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, STL, DBA, Dev	Jonathan de Halleux	4.70
Accessing the Borland Database Engine (BDE) from Visual C++ Updated: 17 Nov 1999 SQL, VC6, Windows, SQL Server, DBA, Dev	Robert Pittenger	4.70
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. C#, SQL, Windows, .NET CF, Mobile, .NET 1.1, ASP.NET, SQL 2000, VS.NET2003, DBA, Dev	Quartz.	4.68
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 C#, SQL, Windows, .NET, Visual Studio, DBA, Dev	Mark J. Miller	4.68
Modeling Hierarchies Updated: 17 Aug 2002 A solution to the problem of storing hierarchical data in a relational database. C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev	Tomaž Štih	4.68
Strongly Typed DataSet Generator Updated: 20 Nov 2009 Generate strongly typed datasets C#, XML, SQL, .NET, SQL Server, ADO.NET	Akram Mellice	4.67
StP Database Administrator Updated: 26 Aug 2003 Web-based administration toolkit for MS Access databases Win2K, WinXP, ASP, Dev	Philip Patrick	4.65
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. SQL, VC7Win2K, WinXP, Win2003, SQL Server, Visual Studio, DBA, Dev	Adam Nelson	4.64
Persisted Permutations Updated: 4 May 2004 An article on how to persist permutations of items in relational databases. C++, SQL, Windows, Visual Studio, SQL 2000, DBA, Dev	Daniel Aioanei, Adi Malinaru, Andrei Postolache	4.63
Lite ORM library (v2) Updated: 28 Jul 2008 A small ORM library. C# (C# 1.0, C# 2.0, C# 3.0), XML, .NET (.NET 2.0), ADO.NET, Dev	Sergey Busel	4.63
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. C#, VB, SQL, VC7.1, Windows, .NET 1.1, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	Andrey Shchurov	4.63
A db grid control using ASP Updated: 27 Aug 2001 A grid control for ASP written in JavaScript to display recordsets. Windows, ASP, IIS, Dev	Bjornar Henden	4.61
A sorting and paging DataGrid loading data on-demand, saving changes in bulk from and to an Oracle database, in ASP.NET Updated: 22 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. C#, SQL, Windows, .NET 1.1, ASP.NET, ADO.NET, VS.NET2003, DBA, Dev	Patrice Borne	4.60
How To Automatically restart MySQL on Windows Updated: 2 May 2005 This article provides a small executable (36K) which configures MySQL (or another Windows Service) to automatically restart whenever it fails/crashes. SQL, VC7Win2K, WinXP, Win2003, SQL Server, MySQL, Architect, DBA, Dev	Emmanuel Kartmann	4.59
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. C#, Javascript, XML, Windows, .NET, ASP.NET, Visual Studio, Ajax, MySQL, Architect, Dev	Rakotomalala Andriniaina	4.59
Optimizing Performance in NHibernate: Part 2: A Collection of Enhancements Updated: 9 May 2007 This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer. SQL, C# 1.0, C# 2.0, Windows, .NET 1.1, .NET 2.0SQL 2000, SQL 2005, VS.NET2003, VS2005, Architect, DBA, Dev	Peter Weissbrod	4.58
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. SQL, C# 2.0, Windows, .NET 2.0, SQL Server, ADO.NET, WinForms, VS2005, DBA, Dev	adamAFA46	4.58
LocalTranGuard - a TransactionScope Fix/Wrapper for LocalTransactions Updated: 18 Apr 2007 Supporting LocalTransactions only with TransactionScope by avoiding escalation to MSDTC. C# 2.0, Windows, .NET 2.0, SQL Server, Visual Studio, Architect, DBA, Dev	balazs_hideghety	4.58
Insert Field (not append) Using ADOX Updated: 2 Jun 2003 Using ADOX to insert field into a MS Access table. SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, ATL, WTL, STL, DBA, Dev	Ferdie	4.57
TransactionScope in .NET 1.1 Updated: 1 Jun 2005 Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1. C#, SQL, .NET, WinXP, Win2003, ASP.NET, Visual Studio, COM+, ADO.NET, SQL 2000, SQL 2005, Architect, DBA, Dev	Alexander Shirshov	4.57
A Data Access Layer to persist business objects using attributes and reflection - Part III Updated: 20 Mar 2002 Persistance to business objects through attributes and reflection C#, Windows, .NET 1.0, Visual Studio, DBA, Dev	xicoloko	4.56
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 C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev, QA	Troy Magennis	4.56
DataTable Transaction Logger Updated: 28 Feb 2006 Undo/Redo DataTable transactions by logging row changes (insert/delete) and field changes. C#, Windows, .NET, Visual Studio, ADO.NET, Architect, DBA, Dev	Marc Clifton	4.55
Database Deadlocks for Dummies Updated: 2 Oct 2008 Explaining Database deadlocking to non-technical people SQL, SQL Server (SQL 2000, SQL 2005, SQL CE), CEO, Architect, DBA, Dev, QA, Design, SysAdmin	Andrew J Dixon	4.54
DeveelDB - A Brief Introduction Updated: 22 Oct 2009 A description of the base functionalities and usage of a full-featured open-source pure .NET/Mono embedded RDBMS C# (C# 1.0, C# 2.0), SQL, .NET (.NET 1.1, .NET 2.0), Linux, ADO.NET, Architect, DBA, Dev	Antonello Provenzano	4.54
Database Programming With MySQL - Unedited Updated: 26 Jun 2008 Getting MySQL running and programming it with KDevelop Linux, MySQL, Dev	pseudonym67	4.53
Passing an array or DataTable into a stored procedure Updated: 27 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. C#, Windows, .NET 1.0, .NET 1.1, Visual Studio, DBA, Dev	Gareth Edwards	4.52
SQL Tuning Tutorial - Understanding a Database Execution Plan (1) Updated: 17 Apr 2005 If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this. C#, SQL, Windows, .NET, Visual Studio, ADO.NET, SQL 2000, SQL 2005, SQL CE, DBA, Dev, QA	Gael Fraiteur	4.52
Databinding the SqlTypes Updated: 1 May 2003 Databinding the SqlTypes using the PropertyDescriptor class and the ITypedList Interface C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, Visual Studio, DBA, Dev	Dan Glass	4.52
PostgreSQL/libpqxx Class Generator Updated: 18 Aug 2006 Automated generation of PostgreSQL data transfer classes. SQL, VC7.1, Windows, SQL Server, VS.NET2003, DBA, Dev	_oti	4.50
How to link different data sources together Updated: 11 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. C#, SQL, Windows, .NET, ASP.NET, Visual Studio, ADO.NET, SQL 2000, SQL 2005, Architect, DBA, Dev	klaus_salchner@hotmail.com	4.50
Easy way to create your Join queries Updated: 26 Apr 2006 An easy graphical way to create complex nested SQL Join queries. SQLWin2K, WinXP, Win2003, Vista, Visual Studio, SQL 2000, DBA, Dev	Emad Al-Ashi	4.50
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 C#, XML, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev, QA	Serioja Sidorov	4.50
Entity Framework Performance Updated: 31 Oct 2009 A comparison of performance between ADO.NET and Entity Framework. C# 3.0, C# 4.0.NET 3.5, .NET 4.0, SQL Server (SQL 2008), ADO.NET, Architect, DBA, Dev	Mark Nischalke	4.50
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. C#, Windows, .NET 1.0, .NET 1.1VS.NET2003, DBA, Dev	Deyan Petrov	4.50
QuickQuery - a database querying tool Updated: 7 Feb 2005 A tool for querying all types of databases. SQL, VC6Win2K, WinXP, SQL Server, MFC, DirectX, DBA, Dev	BlackDice	4.49
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 C# 2.0, Windows, .NET 2.0, Visual Studio, ADO.NET, DBA, Dev	Michael Ceranski	4.48
Creating Excel Sheets using ODBC Updated: 12 Jan 2000 Writing to Excel spreadsheets using only ODBC SQL, VC6, SQL Server, Visual Studio, DBA, Dev	Alexander Mikula	4.48
Project RDL - Open Source Report Definition Language implementation in C# Updated: 9 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. C#, SQL.NET 1.1, WinXPSQL 2000, VS.NET2003, DBA, Dev	Kim Sheffield	4.47
DB2 Access Classes Updated: 27 Nov 2003 A set of classes to encapsulate DB2 CLI APIs in ADO style. SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, Visual Studio, STL, DBA, Dev	nickadams	4.47
Create many-to-many relationships in LINQ for SQL Updated: 1 Sep 2006 Creating many-to-many relationships in LINQ for SQL. C#, SQL, Windows, .NET 2.0, LINQ, VS2005, DBA, Dev	Galin Iliev [Galcho]	4.46
Identifying NHibernate-Related Bottlenecks through Performance Monitoring Updated: 10 Jun 2007 A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues SQL, C# 1.0, C# 2.0, .NET, Win2K, WinXP, Win2003, Vista, ASP.NET, SQL 2000, VS.NET2003, DBA, Dev	Peter Weissbrod	4.46
Implementation of a B-Tree Database Class Updated: 29 Jun 2006 An article and source code regarding the implmentation of B-Trees in C++. SQL, VC7.1Win2K, WinXP, Win2003, SQL Server, VS.NET2003, DBA, Dev	_oti	4.45
Another Embedded Database For C++ Updated: 14 Jan 2007 A C++ wrapper to SQLite database SQL, VC6, Windows, SQL Server, DBA, Dev	Vijay Mathew Pandyalakal	4.45
Correct Column Ordinals of an ADOX Table Object Updated: 2 Jun 2003 Getting the correct column ordinals of an ADOX Table object. SQL, VC6, VC7, VC7.1, VC8.0Win2K, WinXP, SQL Server, MFC, ATL, WTL, STL, DBA, Dev	Ferdie	4.44
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. C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev	VGirish	4.44
Using a LLBLGen-generated data-access tier Updated: 24 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 C#, Windows, .NET 1.0, DBA, Dev	Frans Bouma	4.44
Database Independent Access Updated: 5 Jan 2005 Use different database providers without tying implementation to one. C#, SQL, Windows, .NET 1.0, .NET 1.1, ASP.NET, ADO.NET, VS.NET2003, Architect, DBA, Dev	Jaryl Sim	4.43
Distributed Database Management System Updated: 5 Dec 2008 A distributed database management system, having a main server-LookupServer, several DatabaseServers and Clients, using java.nio for communicating. Java, Java (JavaSE 6), Dev	Alina Simion	4.43
Installing MSDE with .NET Application Updated: 28 Nov 2005 This article shows how to distribute or install MSDE with a .NET application. C#, SQL.NET 1.1, Win2K, WinXPSQL 2000, VS.NET2003, DBA, Dev	Mukund Pujari	4.42
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard - Unedited Updated: 17 Nov 2007 SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard C++, SQL, Windows, Visual Studio, SQL 2005, DBA, Dev	pinaldave	4.42
Compact and Repair Access Database using C# and late binding Updated: 20 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. C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, COM, COM+, VS.NET2003, DBA, Dev	Alexander Yumashev	4.42
Full Database Abstraction Layer Generator Updated: 22 Oct 2003 Yet another DAL generator with SQL generation, multi database support, C# code generation, etc... C#, VC6, VC7, VC7.1, .NET, Win2K, WinXP, Win2003, Visual Studio, DBA, Dev	Jonathan de Halleux	4.41
Minimum Database Permissions Required for SqlDependency Updated: 22 Mar 2006 This article explains how to give a user the minimum rights required for SqlDependency to work C#, SQL, Windows, .NET 2.0, ADO.NET, SQL 2005, VS2005, DBA, Dev	Michael Vanhoutte	4.41
ADO Recordset Paging in ASP Updated: 21 Jun 2000 How to display multiple pages of records in ASP Win2K, ASP, IIS, ADO, Dev	Konstantin Vasserman	4.40
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. C#, SQL, Windows, .NET, ASP.NET, Visual Studio, DBA, Dev	Yunyou Yao	4.40
Database Schema Versioning Management 101 Updated: 10 Apr 2007 An introductory approach to synchronizing database schema versions SQL, Windows, Visual Studio, SQL 2000, SQL 2005, Architect, DBA, Dev, Design	Peter Weissbrod	4.40
Easy Data Access - Unedited Updated: 23 Oct 2006 Run-time data accessor generation VB, C# 1.0, C# 2.0, Windows, .NET 1.1, .NET 2.0, .NET 3.0, SQL Server, ADO.NET, VS.NET2003, VS2005, Architect, DBA, Dev	Igor Tkachev	4.39
@@IDENTITY VS SCOPE_IDENTITY() in TSQL Updated: 22 Jul 2009 Advantage of SCOPE_IDENTITY() over @@IDENTITY SQL, SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), DBA, Dev	Robin_Roy	4.38
Reading Excel files using ODBC Updated: 12 Jan 2000 A discussion and demonstration of reading Excel files using ODBC SQL, VC6, SQL Server, DBA, Dev	Alexander Mikula	4.38
Discard changes in business objects Updated: 16 Nov 2006 How to build a business object with the option to discard changes C#, Windows, .NET, Visual Studio, DBA, Dev	Galin Iliev [Galcho]	4.38
An XML Database Schema And Data Editor Updated: 29 Sep 2002 View and edit your XML database schema and data C#.NET 1.0, Win2K, WinXP, DBA, Dev	Marc Clifton	4.37
How to use RecordSets without using the AppWizard at the creation of your project. Updated: 17 Nov 1999 C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev	Braulio Dez	4.37
C++ Object Oriented Database Generator Updated: 17 Nov 1999 This project is a code generator to produce CObject-dervied data classes for Object-Oriented database management SQL, VC6, Windows, SQL Server, Visual Studio, DBA, Dev	Robert Pittenger	4.36
C# - CSV Import Export Updated: 4 Nov 2008 This article introduces import and export functions between a flat CSV file and a SQL server. C#, Windows, .NET 2.0, SQL Server, ADO.NET, WinForms, VS2005	Slyuch, András	4.36
Saving Master-Details form using XML Updated: 14 Apr 2004 This article shows how to save a master-details form using XML. C#.NET 1.0, .NET 1.1, WinXP, Dev	Muffadal Jaorawala	4.36
CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet Updated: 15 Feb 2002 A Class to Read and Write to Excel and Text Delimited Spreadsheet SQL, VC6, VC7Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev	Yap Chun Wei	4.35
How to make a random selection from an SQL table Updated: 2 Mar 2005 A simple technique for selecting random records from a table. C#, SQL, Windows, .NET CF, .NET, Mobile, ASP, ASP.NET, Visual Studio, ADO, ADO.NET, DBA, Dev	Ach1lles	4.35
A Custom Business Objects Helper Class Updated: 24 Jul 2006 This article shows how to construct a custom business object helper that will populate business objects from a datareader using generics, reflection, and custom attributes C#, Windows, .NET, Visual Studio, DBA, Dev	adargel	4.35
Typed SQLDataReader Updated: 16 Aug 2004 This article would describe how to read column values based on column names, using SQLDataReader. C#, Windows, .NET 1.0, .NET 1.1VS.NET2003, DBA, Dev	S Sansanwal	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. C#, Windows, .NET, Visual Studio, ADO.NET, Architect, DBA, Dev	Marc Clifton	4.33
Using SQL DMO to Alter the Data Type of Table Columns Updated: 1 Jun 2006 This article describes the usage of SQL DMO to automate few aspects of DB maintenance. VBScript, SQL, Windows, Visual Studio, SQL 2000, DBA, Dev	Sarith Sutha	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 C#, Windows, .NET 2.0, WinForms, SQL 2005, VS2005, DBA, Dev	Patrickquinn1212	4.33
TDD using SqlCE and NHibernate Updated: 10 Apr 2007 This article walks through setting up a SqlCE test bench when using TDD XML, SQL, C# 2.0, Windows, .NET 2.0, SQL Server, VS2005, Architect, DBA, Dev, QA	Sean Chambers	4.33
Using a Database Over a Webservice Updated: 29 May 2007 This article shows an example implementation of a database used over a Web-Service C# 2.0, Windows, .NET 2.0VS2005, Architect, DBA, Dev	Tetyana Loskutova	4.33
How to Read Microsoft Excel 2007 Using a Connection String in C# Updated: 28 Nov 2007 This article explains how to connect to Microsoft Excel 2007 using a connection string and populate DataGridView C# 1.0, C# 2.0.NET 1.1, .NET 2.0, Win2K, WinXP, Win2003, .NET 3.0, .NET 3.5, ADO.NET, WinForms, VS2005, DBA, Dev	Mihadh	4.33
C# Code Generator for Stored Procedures Updated: 20 Feb 2006 This stored procedure will generate all the C# code for calling any Stored Procedure C#, SQL, Windows, .NET, Visual Studio, ADO.NET, SQL 2000, DBA, Dev	PaulMcKenzie	4.32
Data Access Component - declarative transactions at the method level without EnterpriseServices, different data sources supported, Part 1 Updated: 29 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 C#, Windows, .NET 1.0, DBA, Dev	Deyan Petrov	4.31
A Data Access Layer to persist business objects using attributes and reflection - Part I Updated: 20 Mar 2002 Persistance to business objects through attributes and reflection C#, Windows, .NET 1.0, Visual Studio, DBA, Dev	xicoloko	4.31
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. VB, SQL, Windows, .NET, ASP.NET, Visual Studio, ADO.NET, SQL 2000, DBA, Dev	Olivier Giulieri	4.31
Database Viewer and Updater for any Database Updated: 25 Jul 2006 View and update any database table and metadata. Includes sample databases. C#, Windows, .NET 2.0, ASP.NET, IIS, Visual Studio, ADO.NET, SQL 2000, SQL 2005, DBA, Dev	avronp	4.31
Prevent Circular References in Database Design Updated: 2 Aug 2009 Circular reference can make your data inconsistent and potentially hazardous even if you have been following up on normal forms and constraints strictly All Topics, Architect, DBA, Dev, Design	truongpham	4.31
Web SQL Utility Updated: 30 Aug 2006 A simple ASP.NET application to run queries against your databases. Stores history and favourites. Javascript, C# 1.0, Windows, .NET 1.1, ASP.NET, VS.NET2003, Dev	Ashley van Gerven	4.31
Implementing Dynamic WHERE-Clause in Static SQL Updated: 8 Nov 2007 This article shows different methods of implementing Dynamic WHERE-Clause in static SQL. SQL, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	John P Harris	4.30
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. C#, XML, Windows, .NET 2.0, ASP.NET, WebForms, VS2005, Dev	Chris Cole	4.29
SQL Server Permissions - Fixing Orphaned Users Updated: 4 Nov 2003 A short article on recovering orphaned users when moving a database from one server to another. C++, SQLWin2K, WinXP, Win2003, SQL Server, Visual Studio, DBA, Dev	Megan Forbes	4.29
Using the CDatabase class to read an Access databases Updated: 29 Mar 2001 This is a very simple code snippet that demonstrates how to read a Microsoft Access database file using the CDatabase class SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	zhaque	4.28
Trees in SQL databases Updated: 22 Sep 2004 How to get all power of trees in SQL C#, SQL, Windows, .NET, Visual Studio, Architect, DBA, Dev, QA	Eugene Lepekhin	4.28
Microsoft Enterprise Library Data Access Block [DAAB] on Oracle Provider [ODP.NET] - Unedited Updated: 15 Jan 2008 Microsoft Enterprise Library Data Access Block [DAAB] on Oracle Provider [ODP.NET] C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev	Rain Man Alex	4.25
Asynchronous Query Execution Updated: 8 Dec 1999 Two classes that provide support for asynchronous SQL execution. SQL, VC6, SQL Server, Visual Studio, DBA, Dev	Vachik Hovhannisyan	4.25
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. C#, SQL, Windows, .NET, SQL Server, Visual Studio, ADO, ADO.NET, DBA, Dev	Rafael Mizrahi, Laurence Moroney	4.25
dexleapFTC, a full text engine made of pure stored procedures - Unedited Updated: 16 Jul 2006 Implement a full text engine by using stored procedures for all MS SQL server editions C#, Windows, .NET, Visual Studio, DBA, Dev	Simon Pang	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. C#, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	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 C#, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev	vooose	4.25
LINQ to SQL Updated: 10 Dec 2007 How to use LINQ to SQL C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 1.0, .NET 1.1, .NET 2.0, Mono, DotGNU, .NET 3.0, .NET 3.5), SQL Server (SQL 2000, SQL 2005, SQL CE), ADO.NET, LINQ, DBA, Dev	Le Sourcier	4.24
Using the Foreach ADO Enumerator in SSIS Updated: 4 Jun 2006 SSIS has a built in function for loops. In this blog article, I want to demonstrate how to use SSIS's Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e.g. name, language, version, etc.) about them. SQL, Windows, .NET, Visual Studio, ADO, SQL 2005, DBA, Dev	r.stropek	4.24
View Database Structure Using C# Updated: 20 Jan 2008 An article on how to view a database structure using C# C#, SQL Server, VS2005, Dev	salysle	4.24
Determining Stored Procedure Parameters with SQL 2005 Updated: 18 Jun 2006 Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005 C#, SQL, Windows, .NET, Visual Studio, ADO.NET, SQL 2000, SQL 2005, DBA, Dev	gtamir	4.23
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. C#, SQL, HTML, Windows, .NET 2.0, ASP.NET, ADO.NET, MySQL, VS2005, DBA, Dev	defwebserver	4.22
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 C++, Windows, .NET, ASP.NET, Visual Studio, WebForms, SQL 2000, DBA, Dev	azamsharp	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. C#, SQL, Windows, .NET 1.1, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	Alexander German	4.20
Object-oriented database programming with db4o Updated: 12 Oct 2007 An introduction to object persistence with db4o, an object-oriented database management system. Topics include storing, updating, deleting, and querying objects. All three db4o's query APIs will be explored. C# 2.0, Windows, .NET 2.0VS2005, Architect, DBA, Dev	Buu Nguyen	4.19
Passing an Array as Parameter to SQL Server Procedure Updated: 13 May 2009 Passing an array as parameter to SQL server Procedure SQL, SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), MySQL, Oracle, DBA	Mohammad Al Hoss	4.18
OLE DB Templates - A light and simple Data Access Method Updated: 22 Nov 1999 SQL, VC6, SQL Server, Visual Studio, DBA, Dev	Richard Warg	4.15
Checking the New DST 2007 from a DBA Perspective Updated: 31 Jan 2007 How to check if your Microsoft SQL Server 2005 is ready for the new DST 2007 C#, SQL, Windows, .NET 2.0, Visual Studio, SQL 2005, DBA, Dev	jamesplewis	4.14
Accessing Microsoft Access databases in ASP using ADO Updated: 26 Apr 2000 A simple introduction to using Access .mdb databases in your ASP pages Win2K, ASP, ADO, Dev	Chris Maunder	4.12
Strange behaviors of an access database - Unedited Updated: 3 Aug 2007 I invite any one who doesn't know about MS access mdb files safty (specially compact and repair) to read this, before it's too late! SQL, VC6, VC7, VC7.1, VC8.0Win2K, WinXP, Win2003, SQL Server, MFC, VS.NET2003, VS2005, DBA, Dev, QA	Hamed Mosavi	4.12
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. C#, SQL, VB 6.NET 1.1, Win2K, WinXPSQL 2000, VS.NET2003, DBA, Dev	Mukund Pujari	4.09
Using Transactions in ADO.NET Updated: 27 Apr 2005 An introduction to SQL Server transactions and how to use them in ADO.NET. C#, SQL, Windows, .NET 1.1, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	netbard	4.09
Optimising hierarchical SQL structures (an ASP approach) Updated: 15 Oct 2001 An article on how to improve SQL hierarchies SQL, VC6, Windows, ASP, IIS, Visual Studio, DBA, Dev	Ciprian Miclaus	4.07
Digging SSIS object model Updated: 19 May 2007 Describes SQL server 2005 Integration Service object model and different data flow components SQL, C# 2.0, C# 3.0.NET 2.0, Vista, .NET 3.0SQL 2005, VS2005, DBA, Dev	Moim Hossain	4.05
Using checkboxes to update multiple database entries Updated: 10 Mar 2002 Code which allows you to update any number of records with yes/no type values using checkboxes Windows, ASP, Dev	Torsten Mauz	4.05
Passing comma delimited parameter to stored procedure Updated: 13 Feb 2004 How to pass an array of integers to a stored procedure. C++, SQLWin2K, WinXP, Win2003, SQL Server, Visual Studio, DBA, Dev	Reza_Allamehzadeh	4.05
Smum County IO Updated: 3 Apr 2006 An ADO.NET toolbox that is meant to serve as the lowest level database IO layer for an application based on an Access, Microsoft SQL Server, or Oracle database. C#, SQL, .NET, Win2K, WinXP, ADO.NET, SQL 2000, SQL 2005, VS.NET2003, DBA, Dev	Lou Flees	4.04
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 C# 2.0, Windows, .NET 2.0, ASP.NET, Visual Studio, WebForms, DBA, Dev	Fuad Bin Omar	4.04
ADO.NET 101: SQL Connection Updated: 31 Aug 2004 A tutorial on connecting to SQL 2000 Server. VB, XML, SQL.NET 1.0, .NET 1.1, .NET 2.0, WinXP, ASP.NET, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	mysorian	4.03
An ODBC (DSN/Driver) Manager DLL written in C# (Version - I) Updated: 14 Jan 2004 ODBC Manager class that retrieves System and User DSNs and driver list. C#, Windows, .NET 1.1VS.NET2003, DBA, Dev	Fact Pandit	4.00
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. SQL, VC7, VC7.1, Windows, SQL Server, VS.NET2003, DBA, Dev	Rohit Joshi	4.00
Pluggable data access components - Part 2 Updated: 22 May 2005 Article describing how to build pluggable data access components. C#, Windows, .NET 1.1, ADO.NET, VS.NET2003, DBA, Dev	WillemM	4.00
SQL Server objects in SourceSafe using SMO and Visual SourceSafe automation - Unedited Updated: 3 Apr 2006 Useful tool to script database objects using SMO and chek in Visual Source Safe C#, Windows, .NET, Visual Studio, DBA, Dev	Levent Soyalp	4.00
SQL Optimization Tip - Unedited Updated: 16 Nov 2009 Use SET NOCOUNT ONWhenever we write any procedure and execute it a message appears in message window that shows no of rows affected with the statement written in the procedure and we become very happy to see that our procedure is working. But do you know that this message creates an extra overhead o SQL	Virendra Dugar	4.00
Creating SQL Server Login programmatically - Unedited Updated: 19 Nov 2009 Introduction I got this question from Daniweb C# forum, and of course whenever I need to do something against SQL Server object from .NET I go to SMO (SQL Server Management Objects) which provides a great functionalities to do anything with SQL Server instead of going on SSMS and create some scri C#, SQL Server	Ramy Mahrous	4.00
How to create Database User programmatically? - Unedited Updated: 19 Nov 2009 Well... we need to assign a server login to has access on a database, let's say the SQL Server Login we had created programmatically should has access on database "Database1" and for some reasons we should do that programmatically Well. Create any C# project type (Windows, Class Library or even Cons C#, SQL Server	Ramy Mahrous	4.00
TSQL reparent an entire branch with hierarchyid - Unedited Updated: 18 Nov 2009 Reparenting a Tree branch is a PITA using the HierarchyID functions. This reparents a branch by reformating the string representation of the HierarchyID. Supports moving the branch to the root node. I use an ID as the primary key so the proc expects the ID's of the node recordsDECLARE @NodeID INT SQL Server	Mycroft Holmes	4.00
Assuring Database Portability with ODBC and .NET Updated: 20 Sep 2003 Managing portability of your source code among different RDBMS, reducing developing time and maintenance. C#, Windows, .NET 1.0, .NET 1.1, DBA, Dev	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. C#, SQL, VC7.1, VC8.0, .NET, Win2K, WinXP, Win2003, ASP.NET, Visual Studio, SQL 2000, IIS 5.1, DBA, Dev	Todd Denlinger	3.96
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. C#, .NET CF, .NET 1.1, Win2K, WinXPVS.NET2003, Dev	MRSumra	3.95
A modification To the NetTiers Code Generator Template Makes the Generated Search Stored Procedures More Flexible - Unedited Updated: 31 Oct 2006 Modification to the nettiers code generator template to make the generated stored procedure for search more powerful(supports the like operator of Transact-sql) and searching the datetime/smalldatetime datatyped columns more smartly C#, Windows, .NET, Visual Studio, DBA, Dev	matrix_resident	3.94
SQL Server - Convert UTC to Local Time - Unedited Updated: 11 Jul 2006 Convert UTC to local time. C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev	Chris Tillotson	3.94
Online DB Administration Updated: 17 Mar 2003 Online administration of your database. Create or modify tables, keys, and indexes. Edit or insert data. Win2K, WinXP, ASP, Dev	Bjornar Henden	3.94
Persistent Object Management in less than 300 Lines of Code - Unedited Updated: 8 Oct 2007 Presenting a lightweight method to cut out most of the repetetive work of creating data classes. SQL, C# 2.0, Windows, .NET 2.0, ASP.NET, Visual Studio, WebForms, SQL 2000, SQL 2005, Architect, DBA, Dev	Nick Higgs	3.93
General trees persisted in relational databases Updated: 23 Jun 2003 Persisting general trees in relational databases with fast path-finding capabilities. C#, Windows, .NET, Visual Studio, DBA, Dev	Daniel Aioanei, Adi Malinaru	3.93
Create database during installation of a .NET application - Version 2 Updated: 10 Jan 2006 This application can be used to create database, tables, and stored procedures during the installation of a .NET application. C#.NET 1.1, Win2K, WinXPSQL 2000, VS.NET2003, DBA, Dev	Mukund Pujari	3.92
MyByteFX.DataHelper Updated: 30 Mar 2004 A simple Data Link Property Dialog that can create connection strings used in ByteFX.MySqlClient provider. C#.NET 1.1, Win2K, WinXP, Win2003VS.NET2003, Dev	CodeSanta	3.91
SqlIndex - Lesson in "Connected" ADO.NET Updated: 25 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. C#, Windows, .NET 1.1VS.NET2003, DBA, Dev	Rodney S. Foley	3.91
Setting up Stored Procedures with Optional Parameters and Using a Strongly Typed TableAdapter to Execute said Stored Procedure - Unedited Updated: 29 Mar 2006 Collection of information on optional paramters in stored procedures as well as passing null values into the fill method of a stongly typed data adapter C#, SQL, Windows, .NET, Visual Studio, ADO.NET, WinForms, DBA, Dev	TofuBug24	3.91
A Database Tool for Client-Server Systems Updated: 29 Apr 2000 Introducing a database tool for client-server systems Java, SQL, VC6Win2K, SQL Server, Visual Studio, MFC, DBA, Dev	Xiangyang Liu 刘向阳	3.90
Very fast table copy from an ODBC source into MS Access within a C# project - Unedited Updated: 11 Jan 2008 An extremely fast and efficient way to import a table from any ODBC-capable database into MS Access (while running in a C# project), by using the MS Access built-in import functionality. C# 1.0, C# 2.0.NET 1.0, .NET 1.1, .NET 2.0, Win2K, WinXP, Win2003, Vista, COM, ADO.NET, SQL 2005, VS.NET2003, VS2005, DBA, Dev	Muaddubby	3.90
Generating Database Tables using Attributes Updated: 14 Feb 2004 Generate database schema information from C# classes. C#.NET 1.0, .NET 1.1, Win2K, WinXP, Visual Studio, Dev	Ahmed Yassin	3.88
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. C#, VB, XML, SQL.NET 1.1, Win2K, WinXP, Win2003SQL 2000, VS.NET2003, DBA, Dev	poodull76	3.87
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. C#, SQL, Windows, .NET CF, .NET 1.0, .NET 1.1, .NET 2.0, ADO.NET, SQL 2000, SQL 2005, VS.NET2003, VS2005, SQL CE, DBA, Dev	Chad Z. Hower aka Kudzu	3.86
Optimistic Concurrency with C# using the IOC and DI Design Patterns Updated: 25 Feb 2009 Discussion of concurrency using the IOC and DI Design Patterns with the PostgreSQL database. SQL, C# 2.0.NET 2.0, ADO.NET, Dev	Donsw	3.86
Create a Database during the installation of a .NET application - Version 1 Updated: 2 Sep 2005 This application can be used to create databases, tables, stored procedures during the installation of .NET applications. C#, SQL.NET 1.1, Win2K, WinXPSQL 2000, VS.NET2003, DBA, Dev	Mukund Pujari	3.85
DarkSide SQL Mini Version 1, The embedded database Updated: 23 Mar 2006 An embedded database library in C++. SQL, VC6, SQL Server, Visual Studio, DBA, Dev	Vijay Mathew Pandyalakal	3.85
Searching a Notes Database using MFC/NotesAPI Updated: 27 May 2003 Searching a Lotus Notes Database and locating notes in the database using Lotus C APIs and MFC. SQL, VC6, VC7Win2K, WinXP, SQL Server, MFC, DBA, Dev	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. C#, SQL.NET 1.1, WinXP, ASP.NET, SQL 2000, VS.NET2003, DBA, Dev	Boo!	3.83
Processing with C#, Oracle transactions and Oracle exceptions - Unedited Updated: 19 Mar 2007 An article which describes an alternative way of cooperation between Oracle PL/SQL and C# SQL, C# 1.0, C# 2.0, C# 3.0, VB 7.x, VB 8.0, VB 9.0.NET 1.0, .NET 1.1, .NET 2.0, Win2K, WinXP, Win2003, Vista, .NET 3.0, ASP.NET, SQL Server, WebForms, VS.NET2003, VS2005, DBA, Dev	Dimitar Madjarov	3.83
Multi User Contact Management System using Three Tier Architecture - Unedited Updated: 1 Mar 2007 A Simple Multi User Contact Management System that will help programmers to use some tricks C# 2.0.NET 2.0, WinXP, WinForms, VS2005, DBA, Dev	Zakaria Bin Abdur Rouf	3.83
Moving a relational database onto Bamboo Prevalence Updated: 30 Oct 2003 The article describes how to move a database onto Bamboo Prevalence C#, SQL, Windows, .NET 1.1, SQL Server, VS.NET2003, DBA, Dev	Stephan Meyn	3.81
Database build tool Updated: 17 Sep 2004 An extensible tool to package and deploy database schema objects. C++, VB, SQL, Windows, .NET 1.0, .NET 1.1, ADO.NET, SQL 2000, VS.NET2003, Architect, DBA, Dev	Duncan Edwards Jones	3.80
C#: Avoiding DTC with Typed DataSets and SQL Server 2000 - Unedited Updated: 16 Nov 2006 An article describing a simple way to provide transaction support to an application designed using the DataSet wizard, and avoiding the DTC requirement with using TransactionScope and SQL Server 2000. C#, Windows, .NET, Visual Studio, DBA, Dev	Neil Barnwell	3.80
Databasing framework with LINQ support Updated: 25 Sep 2009 An easy to use framework with multi-tier, user types, and LINQ support. C# 3.0.NET 3.0, .NET 3.5, ADO.NET, LINQ, Dev	Paulo Zemek	3.80
Database Manipulation with ADO.NET for beginners Updated: 17 May 2005 Personal address book using ADO.NET and C#. C#, Windows, .NET 1.0, .NET 1.1, ADO.NET, VS.NET2003, DBA, Dev	Huseyin Altindag	3.80
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. C#, VC7.1, Windows, DotGNU, Visual Studio, ADO, ADO.NET, DBA, Dev	Marc Brooks	3.79
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. C#, Windows, .NET, ASP.NET, Visual Studio, ADO.NET, WebForms, MySQL, Dev	vivekthangaswamy	3.79
Enhanced DataGrid control Updated: 24 Jun 2003 Extends DataGrid Functionalities C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, DBA, Dev	cctuan	3.79
JET to SQL Converter Updated: 31 Aug 2003 A library to convert a JET database to SQL 'CREATE TABLE' statements C#, Windows, .NET, Visual Studio, Dev	Rowdy75	3.78
Using Query Notifications in .NET 2.0 to handle ad-hoc data refreshes Updated: 1 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. C#, SQL, Windows, .NET 2.0, ADO.NET, SQL 2005, VS2005, DBA, Dev	rajiv404	3.78
A Data Access Layer to persist business objects using attributes and reflection - Part II Updated: 20 Mar 2002 Persistance to business objects through attributes and reflection C#, Windows, .NET 1.0, Visual Studio, DBA, Dev	xicoloko	3.78
File Manager Component Updated: 20 May 2003 A file manager with Visual Studio.NET design time support. C#.NET 1.0, Win2K, WinXP, DBA, Dev	Martin Cook	3.78
Building Dynamic Sql In a Stored Procedure - Unedited Updated: 9 Oct 2007 This article explains about Building and Executing a Dynamic Sql in a stored procedure. C++, SQL, Windows, Visual Studio, SQL 2000, DBA, Dev	John P Harris	3.78
ASC2XXX - Two classes for parsing delimited text files Updated: 8 Mar 2003 Convert delimited text files to XML file or DataSet object C#, Windows, .NET 1.0, DBA, Dev	John C	3.77
Usage of SQLXML to Filter, Retrieve & Present data Updated: 4 Dec 2003 An article on Microsoft SQLXML C#, Windows, .NET 1.1, ADO.NET, VS.NET2003, DBA, Dev	Vinod Giri T	3.76
An ODBC (DSN/Driver) Manager DLL written in C# (Version - I) Updated: 12 Jan 2004 ODBC Manager class that retrieves System and User DSNs and Driver list C#, Windows, .NET 1.1VS.NET2003, DBA, Dev	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). C#, Windows, .NET 1.1VS.NET2003, Dev	Hayder Marzouk	3.75
Compact and Repair an Access Database Programmatically Using C# - Unedited Updated: 20 Mar 2007 A simple method that compacts and repairs a Microsoft Access database file using the Microsoft Jet library and C# COM interop. The example code is meant to be integrated into an ASP.NET web site. C# 2.0, Windows, .NET 2.0, ASP.NET, COM, ADO, WebForms, VS2005, DBA, Dev	Jeremy T. Fuller	3.75
DataTable with SelectDistinct in C# - Unedited Updated: 11 Oct 2007 Allows you to perform a Distinct query against a Datatable. C# 2.0, Windows, .NET 2.0, ADO.NET, SQL 2000, SQL 2005, VS2005, DBA, Dev	vacen2	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 SQL, C# 2.0.NET 2.0, VistaSQL 2005, VS2005, DBA, Dev	Moim Hossain	3.74
Improving the performance of queries using SQL Server Part 2 - Unedited Updated: 3 May 2007 These articles on prioritizing and improving query performance in SQL Server. C#, SQL, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, SQL CE, DBA, Dev	Pete O'Hanlon	3.74
HyperNetDatabase Updated: 21 Mar 2004 HyperNetDatabase is a single process multithreading and blackout safe database C#, Windows, .NET, Visual Studio, DBA, Dev	M L Viñas Livschitz	3.73
Intergrating MySql with Enterprise Library for .NET Framework 2.0 - Unedited Updated: 7 May 2007 An article on adding a MySql connector into Enterprise Library for .NET Framework 2.0 C#, Windows, .NET, Visual Studio, MySQL, DBA, Dev	Mark Pryce-Maher	3.73
Deploy your application and database. - Unedited Updated: 3 Nov 2006 Describes how to add custom script to install project C#, Windows, .NET, Visual Studio, DBA, Dev	Dima_sta	3.72
The CGeneric Database classes Updated: 2 Dec 1999 C++, SQL, SQL Server, Visual Studio, DBA, Dev	Martin-Pierre Frenette	3.71
PersistedObject - an ADO.NET mapping mechanism Updated: 24 May 2002 An alternative to Microsoft's typesafe DataSet C#, .NET, Win2K, WinXP, Visual Studio, DBA, Dev	Vasek	3.71
How to retrieve SqlConnection statistics for executed T-SQL commands Updated: 7 Oct 2007 Sample code describing how to retreive statistical information about the T-SQL commands executed. C# 2.0.NET 2.0, Win2K, WinXP, Win2003SQL 2000, SQL 2005, VS2005, DBA, Dev	Ali Ozgur	3.71
How to truncate log file in SQL Server 2005 - Unedited Updated: 9 Jun 2006 How to truncate log file in SQL Server 2005 C#, SQL, .NET, WinXP, Win2003, Visual Studio, ADO.NET, SQL 2005, Architect, DBA, Dev	hong_wei_li@yahoo.com	3.71
Avanced SQL 2005 SQLNotificationRequest functionality with C# - Unedited Updated: 24 Mar 2007 Using the SQLNotificationRequest object and the Service Broker to get row and column change notifications, mimicking supposed SQLDependency capabilities C# 2.0, .NET, Win2003, Visual Studio, SQL 2005, DBA, Dev	Todd Wilder	3.70
Read text file (txt, csv, log, tab, fixed length) - Unedited Updated: 9 Jun 2008 This article is mainly focused on reading text files efficiently. It includes log, csv, tab delimited, fixed length files, etc. Instead of using StreamReader(.NET)/FileSystemObject(VB 6.0), we consider the file as a database table and read the data by querying it. C#, VB (VB 6), .NET, SQL Server, Dev	Pradeep KV	3.69
Managing Data Sources in C# Updated: 10 May 2004 Data sources management. C#, .NET, Win2K, WinXP, Win2003, Visual Studio, Dev	Guy Baseke	3.67
Object-oriented database programming with db4o - Part 2 Updated: 25 Mar 2008 This article explores the client-server and transaction features of db4o. C# (C# 3.0), Windows, .NET (.NET 3.5), Visual Studio, LINQ, Architect, Dev	Buu Nguyen	3.67
Cubes, MDX, Analysis Services and ADOMD in C# Updated: 29 Mar 2004 An article on Cubes, MDX, Analysis Services and ADOMD in .NET C#, Windows, .NET, Visual Studio, DBA, Dev	teknas	3.66
An Intelligent Data Layer Updated: 9 Aug 2007 An article on communicating with a database and generating SQL queries on the fly C# 2.0, .NET, WinXP, SQL Server, Visual Studio, DBA, Dev	Ferhat Nutku	3.65
Copy data from a DataTable to a SQLServer Database using SQLServer Management Objects and SqlBulkCopy - Unedited Updated: 15 Jan 2007 How to copy data from a modified dataset into a SQL Server Database C# 2.0, Windows, .NET 2.0, SQL Server, ADO.NET, VS2005, DBA, Dev	Aaron VanWieren	3.65
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. C#, SQL.NET 1.1, Win2K, WinXP, Win2003, VistaSQL 2000, VS.NET2003, DBA, Dev	Maxim Alekseykin	3.64
Lightweight DB Framework Updated: 24 May 2006 Manage small database tables with lightweight and simple C# code. Best suited for PocketPC and Windows Mobile devices C#, Windows, .NET, Visual Studio, Dev	arie_schwartzman	3.63
DBF2DataSet Updated: 24 Aug 2007 An article for converting DBF files to dataset XML files C# 2.0, Windows, .NET 3.0, Visual Studio, DBA, Dev	canozurdo	3.61
Populate a TreeView from a SELF-JOINED table Updated: 21 Nov 2002 This demo shows how to populate a treeview from a self-joined table C#, Windows, .NET 1.0, ASP.NET, Visual Studio, DBA, Dev	Gevik Babakhani	3.61
TwinXBase service Updated: 11 Sep 2002 A service that scans for DBX files and adds their contents to a main Access database C#, Windows, .NET 1.0, Dev	Petervu	3.60
Data Archive Updated: 30 Jun 2004 This article describes creating indexed search systems using relational databases C#, SQL, Windows, .NET 1.0, .NET 1.1SQL 2000, VS.NET2003, DBA, Dev	Nikolai Serdiuk	3.60
Creating a Date Process Library and WCF Service for Date and Age Processing - Unedited Updated: 27 Jul 2007 This is phase 2 of a 3 phase project. This phase accesses the database created and loaded in phase one to expose an API of common business date functions. SQL, C# 2.0.NET 2.0, WinXP, Win2003, Vista, .NET 3.0, ADO.NET, WCF, SQL 2005, VS2005, Architect, DBA, Dev	Paul Reynolds	3.60
Representing Multiple Selections using a Single Value in Database Tables Updated: 13 Nov 2009 An alternative technique to store multiple bit (boolean) fields using a single value in database tables. C#, SQL, SQL Server, DBA	P. Ganesh Kumar	3.60
Access Database Editor in C# Updated: 1 Mar 2002 This project presents an Access Database Editor written in C# C#, Windows, .NET 1.0, DBA, Dev	Anthony Roach	3.58
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd - Unedited Updated: 6 Sep 2007 SQL SERVER - 2005 - Introduction and Explanation to sqlcmd C++, SQL, WindowsSQL 2000, SQL 2005, DBA, Dev	pinaldave	3.57
Dynamically adding DSN-names Updated: 6 Jul 2004 A simple class to dynamically add DSN-names to your system. C#.NET 1.0, .NET 1.1, Win2K, WinXPVS.NET2003, DBA, Dev	Bas Goedemans	3.56
DataRow indexing performance (integer vs. string) - Unedited Updated: 5 Feb 2007 Integer and string indexing of System.Data.DataRow columns - head to head C# 2.0, Windows, .NET 2.0, Visual Studio, ADO.NET, DBA, Dev	Juraj Borza	3.56
GridView order page shopping cart page ASP.NET SQL - Unedited Updated: 23 Feb 2007 GridView Image order page shopping cart page C# 2.0, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev	T.Ashraf	3.56
A Naming Scheme for Database Tables and Fields Updated: 16 Jan 2008 This article presents a naming scheme for database tables and fields. C++, C#, SQL, .NET, SQL Server, DBA, Dev	Robert Pittenger	3.55
How to send SMS messages from C# using an SQL database - Unedited Updated: 16 Aug 2007 Send SMS messages from C# using an SQL database server and an SMS Gateway SQL, C# 2.0, Windows, .NET, ASP.NET, ADO.NET, WebForms, SQL 2000, SQL 2005, VS.NET2003, VS2005, IE 6.0, SQL CE, IE 7, Architect, DBA, Dev	Gyula Rabai	3.52
Events and CacheDependency with the database Updated: 23 Sep 2004 Simply implement events and CacheDependency with the database C#, Windows, .NET 1.0, .NET 1.1, ADO.NET, VS.NET2003, DBA, Dev	Miloslav Beno	3.50
A Better Loader for ORM Frameworks - Unedited Updated: 10 Feb 2006 Generate loader classes for faster operation using Reflection.Emit C#, MSIL, Windows, .NET 2.0VS2005, DBA, Dev	Chris Stefano	3.50
APPLY Operator of SQL Server 2005 - Unedited Updated: 3 May 2007 APPLY operator is a new feature in SQL Server 2005 is used in FROM clause of a query. It allows you to call a function-returning TABLE for each row of your outer TABLE. We can pass outer table’s columns as function arguments. C++, SQLWin2KSQL 2005, DBA, Dev	Mohammed Ghouse Barq	3.50
Very fast test data generation using exponential INSERT Updated: 28 Aug 2009 Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times. SQL, MySQL, Oracle, SQL 2000, SQL 2005, SQL CE, SQL 2008, DBA, Dev	weilidai2001	3.50
An ADO.NET multi-database, multi-tier solution Updated: 9 Mar 2004 A view of how ADO.NET can be used in a multi-database, multi-tier environment. C#.NET 1.1, Win2K, WinXP, Win2003VS.NET2003, DBA, Dev	Jochen Jonckheere	3.49
Everything you wanted to know about Stored Procedures Updated: 25 Mar 2004 Stored Procedures explained in detail C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev	Himanshu Khatri	3.47
SQLite GUI - Unedited Updated: 10 Mar 2007 A GUI for SQLite in .Net C#, Windows, .NET, Visual Studio, DBA, Dev	Udhaya Kumar.D	3.46
Building a Business Day and Holiday Database Subsystem - Unedited Updated: 17 Jul 2007 This is phase 1 of a 3 phase project. Phase 1 accesses a public holiday web service, and loads a SQL Server table that can drive dating and aging logic on large sets of data and assist in creating fast-performing queries and reports. SQL, C# 2.0, Windows, .NET 2.0SQL 2005, VS.NET2003, Architect, DBA, Dev, Design	Paul Reynolds	3.45
INSERT\UPDATE Query Generator based on table values - Unedited Updated: 15 Feb 2006 This tool would help anyone to create insert\update query based on values in a table, without any data or with custom data C#, Windows, .NET, Visual Studio, DBA, Dev	S Sansanwal	3.44
Sharpe Ratio and Sortino Ratio for a portfolio in SQL - Unedited Updated: 23 Apr 2006 Calculates Annualized Sharpe Ratio and Sortino Ratio for a Portfolio Trading History in SQL C#, Windows, .NET, Visual Studio, DBA, Dev	AndrewPeters	3.42
OLE DB Consumer using basic C# Updated: 12 Nov 2001 This is the second in a series of articles about using the OLE DB Consumers. C#, Windows, .NET 1.0, DBA, Dev	Anthony Roach	3.40
Get DataSource Information from CSession Object Updated: 5 Feb 2003 A HowTo on getting DataSource information from CSession object SQL, VC6, VC7Win2K, WinXP, SQL Server, ATL, DBA, Dev	Ferdie	3.40
Vector Data Language Updated: 2 Feb 2004 This article covers the Vector Data Language, an XML-based language to manipulate XML data from ODBC sources. C#, Windows, .NET 1.0, .NET 1.1, Visual Studio, DBA, Dev	Stephan Johnson	3.40
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. C#, VC7.NET 1.1, Win2K, WinXP, ADO.NET, VS.NET2003, DBA, Dev	Yulianto.	3.39
Using DataLinks to get or edit a connection string Updated: 9 Mar 2004 Accessing DataLinks from a .NET program to get or edit a connection string. C#, VB.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003VS.NET2003, DBA, Dev	DanMayer	3.38
Overview of SQL Server 2000 Database Clustering using MSCS Updated: 10 May 2005 An article which gives an overview of SQL Server DB clustering using MSCS. C++, SQLWin2K, Win2003, Visual Studio, SQL 2000, DBA, Dev	Pankaj A. Chitriv	3.36
Display records in a table using ASP Updated: 2 Jun 2002 A beginners guide to displaying records from a database in a table using ASP .NET 1.0, Win2K, WinXP, ASP, Dev	Megan Forbes	3.34
SMO - Manage your SQL Server! - Unedited Updated: 31 May 2006 A quick start tutorial on how to manage your Microsoft SQL Server 2000/2005 with C# and the Microsoft's SQL Server Management Objects (SMO) C#, Windows, .NET, Visual Studio, DBA, Dev	Thomas Haller	3.34
Binding a two dimensional array to a DataGrid Updated: 1 Feb 2004 Binding a two dimensional array to a DataGrid C#, Windows, .NET 1.1VS.NET2003, DBA, Dev	Mihail Stefanov	3.33
CurrencyManager Collection - Dealing with SuspendBinding and ResumeBinding Updated: 21 Jun 2005 Manage SuspendBindings and ResumeBindings for all CurrencyManagers in your app. C#, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	Paul Brower	3.33
How to Create a Crystal Report using C# and MySQL Updated: 9 Feb 2009 This is a sample that guides you to create reports with Crystal Reports using C# and MySQL RDBMS. C#, Windows, .NET, Visual Studio, MySQL, DBA, Dev	le quang anh - leadershipqa	3.33
SQLCLR, Triggers e Web Services in SQL Server 2005 - Unedited Updated: 9 Aug 2007 Article explaining how to access a web service using SQL Server integration with VS 2005 (SQLCLR) SQL, C# 2.0.NET 2.0, WinXP, Win2003SQL 2005, VS2005, DBA, Dev	desalbres	3.32
Passing a Comma Delimited Parameter to a Stored Procedure Updated: 29 Jan 2004 Passing multiple values as a single Parameter to a Stored Procedure C++, SQL, Windows, Visual Studio, SQL 2000, DBA, Dev	-Dr_X-	3.31
Implementing Triggers in 4D - Unedited Updated: 10 Mar 2007 The targeted audience of the article are the novice 4D developers and aims at explaining the usage of Triggers in 4D databases. C++, SQLWinXP, SQL Server, DBA, Dev	Manjushree Das	3.30
Displaying vertical rows in a DataGrid Updated: 21 Sep 2003 Displaying vertical rows in a datagrid by flipping the tables horizontally C#, .NET, Win2K, WinXP, Win2003, Visual Studio, DBA, Dev	Neeraj Jain	3.29
Maps Tables , Relation between Tables and Columns Info of a SQL Server DataBase - Unedited Updated: 11 Dec 2007 Shows a way to map Tables , Relation between Tables and Columns Info of a SQL Server 2000/2005 DataBase, also generating INSERT, UPDATE, DELETE and SELECT SQL Statement at Runtime using C# (TableReader) SQL, C# 2.0, Windows, .NET 2.0, ASP.NET, WebForms, SQL 2000, SQL 2005, VS2005, Architect, DBA, Dev	felipesabino	3.29
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. C#, Windows, .NET, Visual Studio, Architect, DBA, Dev	Marc Clifton	3.27
Inserting Value of Collection into Database Updated: 7 Aug 2008 Inserting value of Collection into Database XML, SQL, C# 3.0WinXP, Win2003, .NET 3.5, ASP.NET, ADO.NET, SQL 2005, VS2008	bhadeliaimran	3.27
Store and Retrieve trees in SQL under C# - Unedited Updated: 17 Jun 2007 In this article the ability of Microsoft SQL Server database in storing and retrieving trees will be described. SQL, C# 2.0, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev	Reza Shojaee	3.26
Why Caching A DataBase Connection Is A Bad Idea Updated: 10 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. Win2K, WinXP, ASP, Dev	Ashish Patel	3.26
Populate data from database in a ComboBox Updated: 19 Oct 2004 Populate data from database in a ComboBox. C#.NET 1.1, WinXP, ADO.NET, VS.NET2003, Dev	Huseyin Altindag	3.25
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 C#, Windows, .NET, Visual Studio, DBA, Dev	Yunyou Yao	3.25
Dynamically set TextBox.MaxLength based on SQL column size Updated: 25 Jan 2007 Dynamically set TextBox.MaxLength based on the SQL column size. C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev	Fiwel	3.25
Save binary data to SQL Server Updated: 25 Apr 2002 ASP can save binary data to a table in SQL Server Win2K, WinXP, ASP, Dev	Fernando Finelli	3.23
Automated Class Builder for Database Tables Updated: 11 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. C#, Windows, .NET 1.0, .NET 1.1, ADO.NET, VS.NET2003, Architect, DBA, Dev	Nirosh	3.22
Transactions, locking and table releasing with MySQL Updated: 16 Apr 2004 Implement a simple class to store multiple queries and run against a MySQL database. C#.NET 1.1, Win2K, WinXP, Win2003, MySQL, VS.NET2003, DBA, Dev	Cláudio de Vasconcelos	3.20
ADOMD.NET DataAdapter / DataReader replacement Updated: 4 Oct 2005 This code replaces the buggy ADOMD.NET DataAdapter and DataReader. C#, Windows, .NET, Visual Studio, DBA, Dev	MEmerson	3.20
Generate SQL INSERT commands Programmatically - Unedited Updated: 29 Jun 2006 A class for automatically generating SQL INSERT for Typed Datasets C#, Windows, .NET, SQL Server, Visual Studio, ADO.NET, DBA, Dev	Ian Semmel	3.17
Intermediate OLE DB Consumer with C# Updated: 16 Jan 2002 Using the OleDbDataAdapter and OleDbCommands objects to consume OLE DB providers C#, Windows, .NET 1.0, DBA, Dev	Anthony Roach	3.17
Solving the collation mix with SAP (SQL_Latin1_General_CP850_BIN vs. Latin1_General_CI_AS) - Unedited Updated: 20 Jun 2006 Solving the collation mix with SAP (SQL_Latin1_General_CP850_BIN vs. Latin1_General_CI_AS) C#, Windows, .NET 2.0, Visual Studio, SQL 2005, DBA, Dev	r.stropek	3.17
Stored Procedure Generator [Advance] - Unedited Updated: 10 Jan 2007 A very powerful tool that generates SqlServer Stored Procedure Statments to build N-Tier applications VB, SQL, C# 1.0, C# 2.0.NET 1.1, .NET 2.0, Win2K, WinXP, Win2003VS.NET2003, VS2005, Architect, DBA, Dev	Mustafa Magdy	3.17
Computed Column Specification in SQL Server - Unedited Updated: 18 Jul 2007 Computed Column Specification for populating nth column C++, SQL, WindowsSQL 2000, SQL 2005, Architect, DBA, Dev, Design	Padoor Shiras	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 C++, SQL, C# 2.0, Windows, .NET, SQL Server, COM, COM+, DBA, Dev	Dragos Boia	3.16
WEBCLIENT to “European Central Bank” to calculated Exchange between countries. - Unedited Updated: 15 Apr 2005 This load the "ECB" xml file and parse it into a dataset. From that we can calculated the Exchange rate between difference countries. C#, Windows, .NET 1.1, ADO.NET, VS.NET2003, DBA, Dev	hestol	3.13
SQL-DMO: Search and regenerate stored procedures in seconds - Unedited Updated: 22 Sep 2007 Use SQL-DMO Object Library for quick searching and generating stored procedures script SQL, C# 1.0, C# 2.0, Windows, .NET 1.1, .NET 2.0SQL 2000, SQL 2005, VS2005, DBA, Dev	Triet Ho	3.12
Mixing .NET remoting with COM+ to communicate with an Oracle database. Client and server side. - Unedited Updated: 5 Nov 2007 This article will explain a system made for developers to store their software versions in a SQL database, client and server side. Will handle COM+ mixed with Remoting, and a Oracle database. SQL, C# 1.0, C# 2.0, C# 3.0.NET 1.1, .NET 2.0, Win2K, WinXP, Win2003, .NET 3.0, SQL Server, COM+, VS.NET2003, VS2005, Architect, DBA, Dev, Design	Windmiller	3.11
ASCII/Multibyte to Unicode conversion - Unedited Updated: 16 Feb 2007 An article about converting ASCII/Multibyte to unicode using C# and SQL/CLR Integration SQL, C# 2.0.NET 2.0, WinXP, Visual Studio, SQL 2005, DBA, Dev	carlop()	3.10
Application DataBlock Extender Code Generator using SQLDMO Updated: 4 Apr 2005 Use this Windows application to generate complete Data Access Layer for your applications. C#, SQL, VB 6.NET 1.1, Win2K, WinXP, Win2003SQL 2000, VS.NET2003, CEO, Architect, DBA, Dev, QA	dshalimov	3.09
Brief about Triggers in SQL Server 2000 Updated: 17 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". C++, SQLWin2K, WinXP, Win2003, Visual Studio, SQL 2000, DBA, Dev	SquaredRomi	3.08
Processing with C# and Oracle PL/SQL - Unedited Updated: 29 Apr 2007 An article which describes an alternative way of cooperation between Oracle PL/SQL and C# SQL, C# 1.0, C# 2.0, C# 3.0, VB 7.x, VB 8.0, VB 9.0.NET 1.0, .NET 1.1, .NET 2.0, Win2K, WinXP, Win2003, Vista, .NET 3.0, SQL Server, IIS 5.1, IIS 6, VS.NET2003, VS2005, IIS 7, DBA, Dev	Dimitar Madjarov	3.07
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. C#.NET 1.0, .NET 1.1, Win2K, WinXP, ADO.NET, VS.NET2003, DBA, Dev	Ahmed jamil Kattan	3.07
Accessing Row based data in an efficient and maintainable manner Updated: 1 Aug 2006 Methods for accessing row based data in C# (.NET) C# 1.0, Windows, .NET 1.0, Visual Studio, DBA, Dev	Ennis Ray Lynch, Jr.	3.07
A simple architecture to read arbitrarily formatted flat files into ADO DataSets Updated: 25 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 C#.NET 1.0, .NET 1.1, Win2K, ADO, DBA, Dev	Sriram Chitturi	3.06
Automatic Object Persistency – Part I - Unedited Updated: 13 Aug 2006 An API to persist business entities without writing database centric code or mapping schema in an external XML File C#, Windows, .NET, Visual Studio, DBA, Dev	Mohammad Ali Azam	3.06
A simple count() query class Updated: 10 Jun 2005 A class to easily do count() queries. SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	Paul S Ganney	3.04
Remote Database Administer via XMLHTTP Updated: 3 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. XMLWin2K, WinXP, ASP, Dev	Lu Lianbo	3.00
MyGroupConcat: A MySQL UDF aggregate function for string concatenation - Unedited Updated: 23 Mar 2004 This MySQL extension library provides an aggregate function that concatenate strings (for use with SELECT...GROUP BY clause). SQL, VC7, VC7.1Win2K, WinXP, SQL Server, MySQL, DBA, Dev	Emmanuel Kartmann	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 SQL, VC6, Windows, SQL Server, MFC, DBA, Dev	Vijay Mathew Pandyalakal	3.00
Data Extraction and Manipulation Updated: 24 Apr 2007 Extracts data from database, manipulates extracted data, and then updates the database C#, Windows, .NET, Visual Studio, DBA, Dev	~~_{jason_lakewhitney}~~	3.00
Remove duplicate records from SQL tables - Unedited Updated: 13 May 2007 A generic procedure to retrieve and delete duplicate records from MS SQL server tables C++, SQLWin2K, WinXP, Win2003, Vista, Visual Studio, SQL 2000, SQL 2005, DBA, Dev, QA	Eugene Ochakovski	3.00
DLinq Quick Start - Unedited Updated: 4 Oct 2007 Start using DLinq in easy steps C# 3.0, Windows, .NET 2.0VS2005, DBA, Dev, Design	Maruf Maniruzzaman	2.98
Simple SQL Connection String Manager Class Updated: 14 Sep 2004 Simple class that helps accessing and managing SQL Connection Strings. C#, SQL, Windows, Win Mobile, .NET CF, Mobile, .NET 1.0, .NET 1.1, .NET 2.0, ADO.NET, SQL 2000, VS.NET2003, VS2005, DBA, Dev	Pawel Zarzycki	2.97
Improving the performance of queries using SQL Server Part 1. - Unedited Updated: 11 Jan 2007 The first in a series of articles on prioritizing and improving query performance in SQL Server. C#, SQL, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	Pete O'Hanlon	2.97
How to generate an SQL filter clause using C# Updated: 18 Nov 2003 Produces SQL filter clauses using C# objects C#, Windows, .NET 1.0, Visual Studio, Dev	gokselm	2.96
Get data from database without refreshing the page Updated: 13 Nov 2002 works in all browsers Win2K, WinXP, ASP, Dev	Amol Rajmane	2.96
BoneBoxes .Net Data Access Tools and Data Tier Generator Updated: 15 Nov 2002 BoneBoxes is a data access library that provides you with SQL statements and data validation based on the data set's properties C#, Windows, .NET 1.0, Visual Studio, DBA, Dev	BoneHead	2.96
Persist Objects with Attributes Updated: 16 Jun 2005 Enable persistance and population of objects without writing ADO.NET code. C#, SQL.NET 1.1, Win2K, WinXP, Win2003, ADO.NET, SQL 2000, VS.NET2003, Architect, DBA, Dev	Thomas Lykke Petersen	2.94
Writing Server Indifferent SQL Updated: 2 Feb 2009 An article on how to write SQL that runs against all(?) data bases SQL, DBA	Asher Barak	2.94
Configure MS SQL Server 2005 Remote Access ( mixed mode ) - Unedited Updated: 13 Oct 2006 Configure MS SQL Server 2005 Remote Access ( mixed mode ) C#, SQL, .NET, Win2003, ADO.NET, SQL 2005, VS2005, Architect, DBA, Dev	hong_wei_li@yahoo.com	2.93
Grant Execute on all procedures to a user Updated: 14 Jan 2004 This stored procedure grants execute privilege on all procedures to specified user C++, SQLWin2K, Visual Studio, SQL 2000, DBA, Dev	Sumit Amar .	2.92
Generate an Organization Chart from Employee Database Updated: 18 Nov 2007 Generate an organization chart from employee database using ASP & Microsoft Excel Windows, ASP, Visual Studio, Dev	BSRK, AHILABALU	2.91
Enhancements done for storing connection strings in Visual Studio 2005 Updated: 29 Jun 2005 Enhancements done for storing connection strings in Visual Studio 2005. C#, Windows, .NET, Visual Studio, DBA, Dev	Nishith Pathak	2.91
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 C#, VB.NET 1.1, WinXP, ASP.NET, Visual Studio, WebForms, Dev	DEEPCHAND KOSTA	2.89
C# Data Class Updated: 27 Jan 2002 A generalised method for calling parameterized stored procedures C#.NET 1.0, Win2K, WinXP, DBA, Dev	SimonS	2.88
Database Factory using C# Generics - Unedited Updated: 8 Oct 2006 Database Factory using C# Generics C#, Windows, .NET, Visual Studio, DBA, Dev	SikeMullivan	2.87
Top 10 Must Have Features in O/R Mapping Tools - Unedited Updated: 23 Feb 2007 This article will educate you about the various important features that a good O/R mapping tool would provide you and how it can be beneficial to you. VB, C# 2.0, .NET CF, Mobile, .NET 2.0, WinXP, Win2003, ASP.NET, SQL Server, COM, COM+, ADO, ADO.NET, WinForms, WebForms, VS.NET2003, VS2005, DBA, Dev	Iqbal M Khan	2.86
Stored Procedure Wrapper Updated: 23 May 2007 An article on wrapping stored procedure invocations in strongly typed intefaces C# 2.0, Windows, .NET 2.0, Visual Studio, DBA, Dev	Szymon Pobiega	2.85
Run Scripts Add-In for SQL Server 2005 Management Studio - Unedited Updated: 20 Nov 2008 An Add-In for SQL Server 2005 Management Studio that will run all the scripts in the selected project C#, Windows, .NET, Visual Studio, DBA, Dev	Michael Erasmus	2.78
Data Access Components Updated: 26 Oct 2003 Data access components to interact with any database. C#, Windows, .NET 1.1, Visual Studio, DBA, Dev	stephanpeters4000	2.78
How to manipulate hierarchical information in flat relational database tables (optionally industrial strength) - Unedited Updated: 1 Jan 2007 This article describes a technique to quickly retrieve and present hierarchical information from a flat relational database table. SQL, C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev	Akshay Srinivasan2	2.77
A Helpful Database Library Updated: 6 Dec 2006 This article illustrates a helpful database library. C#, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	~~_{jason_lakewhitney}~~	2.75
How to Pass Parameters to Crystal Reports at Runtime Updated: 15 Dec 2007 An article on how to pass parameters to Crystal reports from Windows Form at runtime SQL, Windows, SQL Server, DBA, Dev	Malik Usman	2.75
Query paging by one trip to MS-SQL 2005 via one simple query. - Unedited Updated: 4 Jul 2007 Query paging by one trip to MS-SQL 2005 via one simple query. Without using stored procedure, view or all others features. Only with T-SQL and .NET SQL, C# 1.0, C# 2.0, Windows, .NET 1.1, .NET 2.0, .NET 3.0, ASP.NET, ADO.NET, WebForms, SQL 2005, VS.NET2003, VS2005, DBA, Dev	Marek Mizov	2.72
Insert /retrieve an image into/ from a blob field in Oracle database using C#.Net - Unedited Updated: 22 May 2007 This article will help you to add an image into a blob field of oracle database, This will also help in retrieving the image from the blob field using C#.Net C#, .NET, WinXP, Visual Studio, DBA, Dev	ehanthalingam	2.71
Dynamic Document ID’s without maintaining Counters! - Unedited Updated: 29 Mar 2006 An article to demonstrate the creating of business document ids without using stored counters. C#, SQL, Windows, .NET 1.1, .NET 2.0, SQL Server, ADO.NET, VS.NET2003, VS2005, Architect, DBA, Dev	Asif Sayed	2.69
Versatile and Extendible Data Access Factory Updated: 17 Jul 2004 Using and extending the data access classes, and runtime selection and instantiation using a factory and XML configuration file. C#, SQL.NET 1.0, .NET 1.1, WinXP, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	G Ryno	2.67
Use C# write a designer like PowerDesigner - Unedited Updated: 14 Aug 2006 How to develop a database structure designer use C# C#, Windows, .NET, Visual Studio, DBA, Dev	yfyuan	2.67
SimpleQuery – quick and easy database access via ADO.NET Updated: 18 Aug 2005 A class to allow easy running of T-SQL code against .NET data sources. C#, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	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. C#, SQL, .NET, Win2K, ASP.NET, Visual Studio, SQL 2000, DBA, Dev	prabhu.subbiah	2.61
Using C# for Inserting CLOB data in Oracle - Unedited Updated: 3 Aug 2007 Inserting CLOB data into Oracle table using C# language C# 2.0.NET 1.1, .NET 2.0, WinXPVS.NET2003, VS2005, DBA, Dev	ace	2.61
How to use CodeProject Grid in MS Access to view multiple intermediate results Updated: 14 Oct 2002 This article is about using MFC CodeProject Grid, ATL and MS Access together. SQL, VC6, SQL Server, MFC, ATL, DBA, Dev	rkdev	2.60
Tool to easy navigate through runtime created data tables or datasets - Unedited Updated: 30 Jul 2006 Debugging when working with databases can be a very ugly job. Especially when most of the data tables are created in runtime. Of course you can set a breakpoint when your dataset or data table is filled, but you need to scroll a lot to find out witch data is in the table, witch column names are used C#, Windows, .NET, Visual Studio, DBA, Dev	Ronnie IJsbrandij	2.58
C# Relational Database Updated: 8 Feb 2005 This article describes how to write a relational database using C#. C#.NET 1.0, WinXP, Dev	Dave Brighton	2.57
Oracle Data Access Block for .NET - Unedited Updated: 7 May 2006 This is an Oracle Data Layer class for connecting to Oracle Database from a .net application based on Oracle Data Provider.NET C#, Windows, .NET, ASP.NET, Visual Studio, DBA, Dev	RB Changanacherry	2.57
SQL Stored Procedure Debugging from SQL Query Analyzer - Unedited Updated: 22 Aug 2007 Debugging a SQL Stored Procedure in SQL Server 2000 Query Analyzer C++, SQL, VB 8.0, .NET, WinXP, Visual Studio, SQL 2000, DBA, Dev	Srf_World	2.56
*Restoring Datbase Using BatchFile(.Bat)** - Unedited Updated: 9 Jun 2008 This article describes on building a Database from scratch using Batch File from the existing Database C# (C# 1.0, C# 2.0, C# 3.0), SQL, .NET (.NET 2.0, .NET 3.0, .NET 3.5), ASP.NET, SQL Server (SQL 2000, SQL 2005), IIS (IIS 5.1, IIS 6), COM+, ADO.NET, Dev	Deepak.M	2.56
Custom print procedure in MS SQL 2000/7/6.5 Updated: 23 Dec 2003 This procedure can be called in another Stored procedure or function and quite handy in debugging and development C++, SQLWin2K, Win2003, Visual Studio, SQL 2000, DBA, Dev	Abhay Dubey	2.53
Using ADO.NET programmatically with C# - Unedited Updated: 15 Dec 2005 An article on using Ado.NET programmatically C#, SQL, VC8.0.NET 1.1, Win2K, WinXP, Win2003, Vista, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	Umut ŞİMŞEK	2.52
Using SQL trigger to create unlimited unique id's - Unedited Updated: 29 Sep 2005 Using SQL trigger to create unlimited unique id's C++, SQLWin2K, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	Vincegee	2.52
Object ByteArray Converter - Unedited Updated: 17 Jun 2004 this dll help users to convert between any object and byte array which will be very useful when using to insert objects into a DataBase C#, VB.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP.NET, VS.NET2003, DBA, Dev	Tamer Ahmed Farrag	2.52
Simple Database Application - Part 1 Updated: 24 Jan 2003 Connecting to Database using C# and ADO.NET C#, .NET, Win2K, WinXP, Visual Studio, DBA, Dev	Samar Aarkotti	2.50
To generate insert statement for user defined tables available in SQL Server 2000, through easy to use wizard. - Unedited Updated: 23 Jun 2006 It will generate insert statement as per the tables selected by the user, and it also take cares of Identity inserts in the table. C#, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev	Vivek Singh - IN	2.50
Access .NET assembly through SSIS (Script Component) - Unedited Updated: 8 Oct 2006 Here is some cool stuff to call .NET assembly from SSIS SQL, C# 2.0, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev	Malpani Amol	2.50
Deploy and Debug CLR store procedure - Unedited Updated: 15 Oct 2006 This article will drive you, how deploy and debug CLR store procedure SQL, C# 2.0, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev	Malpani Amol	2.50
C# Class: Text file as DataBase - Unedited Updated: 17 Oct 2007 This article tries to explain how we could use a TextFile as a simple DataBase. C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev	RenanDuarte	2.48
DBInspector - Making the case for code generation - Unedited Updated: 26 Aug 2005 DBInspector is a swiss army knife for database developers. DBInspector helps you generate all types of code based on your database schema. C#, VB, XML, SQL, Windows, .NETSQL 2000, VS.NET2003, DBA, Dev	Mark Williamson	2.48
Microsoft Application Block for Data Access in .NET Updated: 5 Sep 2004 This article gives an overview of Microsoft Application Block for Data Access, its advantages and specifies its usage in a .NET application. C#, .NET, Win2K, WinXP, Win2003, ADO.NET, VS.NET2003, DBA, Dev	Sekhar Lanka	2.47
Dynamic connection string Updated: 9 Aug 2004 Creating dynamic connection string on a remote site. VBScriptWin2K, WinXP, Win2003, ASP, Visual Studio, IIS 5.1, IIS 6, Dev	x_scripterx	2.45
SQLDataAdapter without using SQLCommandBuilder Updated: 28 Jan 2004 This article speaks about how to use SQLDataAdapter and its update method without using SQLCommandBuilder C#, Windows, .NET, Visual Studio, DBA, Dev	vinoth1979	2.44
Detect Changes To A Database Table Updated: 25 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. C#, SQL, .NET, Win2K, WinXP, Win2003, Visual Studio, DBA, Dev	Pradeep Fernandes	2.44
Inheritance in O/R Mapping - Unedited Updated: 9 Jan 2007 Object oriented applications usually have inheritance as an important part of their design, including in their domain objects. However, the corresponding data model has no built-in mechanism for specifying inheritance. Therefore, domain objects must be mapped to relational database intelligently C#, Windows, .NET, Visual Studio, DBA, Dev	Iqbal M Khan	2.43
Using XML as Database with Dataset - Unedited Updated: 20 Apr 2006 How to make simple Database driven application with XML plain text. Portable, easy and light weight! C#, Windows, .NET, Visual Studio, DBA, Dev	bern4d	2.42
Versioned Database Access Updated: 20 Jul 2007 Use the correct data access classes for the current version of the database C# 2.0, Windows, .NET 2.0, Visual Studio, ADO.NET, DBA, Dev	kepProg4eva	2.40
Data Access Component and the Factory Design Pattern - Unedited Updated: 5 Apr 2006 A generic Data Access Component implementation written in C# that supports SQL, Oracle, OLEDB and ODBC data providers. Using the Factory design pattern for instantiating the data provider correct and specific objects determined at run time. C#, Windows, .NET, Visual Studio, DBA, Dev	Waleed Al Tamimi	2.39
Grove [.NET Develop Component Kit] - Unedited Updated: 19 Nov 2003 for database project developer C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP.NET, Visual Studio, DBA, Dev	landws	2.38
MFC and MySQL Updated: 8 Aug 2002 MFC classes to fill ComoBoxes & ListBoxes with MySQL data. SQL, VC6Win2K, WinXP, SQL Server, MFC, MySQL, DBA, Dev	Victor M. Valenzuela	2.38
Database Project Deployment -- An introduction to the DependencyList Updated: 29 Sep 2008 A means to deploy Visual Studio database projects, ordering SQL files using a List that yields in the order of dependency. C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 2.0), Visual Studio (VS2005), Architect, Dev	jimbobmcgee	2.36
INT versus GUID on a table's primary key Updated: 6 May 2008 This article tries to show the pros and cons of using INT or GUID types on primary keys. SQL, C# 1.0, C# 2.0, C# 3.0, VB 7.x, VB 8.0, VB 9.0, DBA, Dev	Liviu Holhos	2.34
C++ wrapper for Sybase's OPENCLIENT Interface Updated: 27 Sep 2002 This article will provide a cross platform C++ wrapper for Sybase's OPENCLIENT interface. C, SQL, VC6Win2K, WinXP, SQL Server, DBA, Dev	lihaijian	2.33
How To Exactly Enumerate SQL Server From LAN By Using SQLDMO - Unedited Updated: 15 Aug 2005 An article on introducing how to use SQLDMO SQL, VC6WinXP, MFC, SQL 2000, DBA, Dev	Wang Xuemin	2.33
IDbDataParameter error in .NET Updated: 11 Sep 2006 How to solve the error when assigning a DateTime to a IDbDataParameter. VB, C# 1.0, C# 2.0, Windows, .NET 1.0, .NET 1.1, .NET 2.0, Visual Studio, DBA, Dev	René Paw Christensen	2.33
SQL Long String Print - Unedited Updated: 22 May 2007 SQL Long String Print C#, SQL, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	Yildirim Kocdag	2.33
Access MS-Access Databases from Java Updated: 6 Apr 2009 This article demostrates how to access MS Access databases from Java. Java, Java, JDBC, Dev	arnavguddu	2.33
Setting the SharePoint database straight Updated: 24 Aug 2004 Investigating the database created by SharePoint for use in your .NET application. C++, C#, VB, SQL, Windows, .NET, ASP.NET, Visual Studio, SQL 2000, Architect, DBA, Dev	Vivek Shaurya	2.30
C# class that creates 'INSERT INTO' SQL queries Updated: 16 Dec 2004 Class that creates INSERT INTO SQL queries. C#, SQL, Windows, .NET, Visual Studio, DBA, Dev	Adam Klobukowski	2.26
Cool Focus Provider - Unedited Updated: 20 Oct 2007 This component is used for forms that have too many textboxes which change their focus with Enter key. C#, Windows, .NET 2.0, WinForms, VS2005, DBA, Dev	Ehsan Golkar	2.26
Dealing With Data tables... - Unedited Updated: 14 Jan 2006 All you want to know to deal with data tables... C#, SQL, .NET, Win2K, WinXP, Visual Studio, SQL 2000, DBA, Dev	Star_Friend	2.26
DTS Export - Unedited Updated: 16 Nov 2006 Article to export MS DTS packages from one server to another. C++, SQLWin2K, SQL Server, ADO, DBA, Dev	KRISHNA PRASAD.N	2.24
SQL Builder for Microsoft SQL Server - Unedited Updated: 24 Apr 2007 This is a SQL Query Builder which is could be used for further purposes. This was developed under C#.NET. This application will allow us to design a query. It will check any relationship of the tables so there's a little possibility generating query from unrelated tables C#, Windows, .NET 2.0VS2005, DBA, Dev	Arek Suroboyo	2.18
Connecting to Database SQL Express 2005 with VS 2005 - Unedited Updated: 2 Aug 2006 Connecting to SQL Express Manualy SQL, C# 1.0.NET 2.0, WinXPSQL 2005, VS2005, DBA, Dev	efero	2.17
System stored procedures - Beginner Level - Unedited Updated: 16 Sep 2007 This article will give you a brief introduction on various system stored procedures and how you can write your own queries instead of using the system procedures. C++, SQL, Windows, .NET, SQL Server, Visual Studio, Architect, DBA, Dev	rilov	2.16
The Keyspace Problem Updated: 20 Jul 2006 Just how many customers can you have in your database? C#, SQL, Windows, .NET, Visual Studio, DBA, Dev	Ennis Ray Lynch, Jr.	2.16
Remove comment in SQL Updated: 12 Feb 2003 Remove comment in SQL to make it easy to execute with MS Access. SQL, VC6, VC7Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev	colison	2.15
Using TRY...CATCH in Transact-SQL - Unedited Updated: 25 Oct 2005 I will discuss the Try & catch errorhandling feature of the SQL SERVER 2005 (Yukon) C++, SQL, Windows, Visual Studio, SQL 2005, DBA, Dev	Himanshu Kumar Sinha	2.14
Building pluggable data access components Updated: 25 May 2004 A simple explanation on how to build pluggable data access components. C#, .NET, Win2K, WinXP, Win2003, Visual Studio, DBA, Dev	WillemM	2.13
Writing SQL queries in XML – A support intensive approach - Unedited Updated: 31 Jul 2005 Article that helps writing SQL in XML to provide better support C#, SQL, Windows, .NET, Visual Studio, GDI, SQL 2000, Architect, DBA, Dev	Syed Asif Iqbal	2.13
XmlClient Managed Provider Updated: 16 Apr 2002 A Class Library that holds a Managed Provider to retreive Load DataSets from Xml sources. C#, Windows, .NET 1.0, DBA, Dev	Shawn Wildermuth	2.11
Paging in SQL Server by using TSQL - Unedited Updated: 18 May 2006 Facilitating efficient Sql Server paging by giving T-SQL query as input to this generic stored procedure C#, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev	Muhammad Kashif Akram	2.11
Extended DataTable to Support DTO Generation Updated: 9 Nov 2007 An article on using DataTable as Generic Data Transfer Object (DTO) for varied data views C# 2.0, Windows, .NET 2.0VS2005, Architect, Dev	Pavan Gayakwad	2.11
Accessing dBase Files Updated: 1 Jul 2003 How to access a dBase file SQL, VC6, VC7, Windows, SQL Server, MFC, DBA, Dev	thomask	2.11
Determine Holes in IDENTITY Columns - Unedited Updated: 29 Sep 2007 An article on an efficient method to determine missing values in an IDENTITY() sequence. C#, SQL, Windows, .NET, SQL Server, DBA, Dev	DejaVudew	2.09
SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects - Unedited Updated: 21 Aug 2007 SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects C++, SQL, Windows, Visual Studio, SQL 2005, Architect, DBA, Dev	pinaldave	2.07
Click Away from Table to Source - Unedited Updated: 24 May 2007 generate 100,1000 lines of bakend code and stored procedures by just one click on table name in sql server C# 1.0, Windows, .NET 1.1VS.NET2003, DBA, Dev	urd_sheir	2.04
Clear the transaction log - Unedited Updated: 25 Apr 2002 dump the transaction log C++, SQLWin2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev	Fernando Finelli	2.00
Alphanumeric increment in C# - Unedited Updated: 11 Jun 2006 This code is very useful when you want to auto increment number using A-Z and 1-9 with possible combinationYou can pass any string and system will return next possible number e.g. You can Pass number "PRO01A9" then You will get "PRO01B1" C#, SQL, .NET CF, Mobile, .NET 1.0, .NET 1.1, .NET 2.0, Win2K, WinXP, Win2003, Vista, TabletPC, Embedded, ASP, ASP.NET, VS.NET2003, Architect, DBA, Dev	Sandip Dalvi Tung	2.00
Store Procedure call in vc++ (ORACLE) - Unedited Updated: 16 Aug 2006 How to Call or Executive Store Procedure (Oracle ) in vc++ C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev	sherton	2.00
User Role Management For Other Projects - Unedited Updated: 27 Sep 2007 Centralized user management system for applications. SQL, VC8.0, Windows, SQL Server, Visual Studio, DBA, Dev	Maruf Maniruzzaman	2.00
A customized business transaction in C# - Unedited Updated: 19 Nov 2007 An article on implementing a customized business transaction class based on LLBLGen Pro. C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev	Chapooki	2.00
Simple way to implement database driven Advance Search Engine to search data in many tables - Unedited Updated: 1 Mar 2008 Way to search record in relational tables to get search count on a search string SQL, .NET (.NET 1.0, .NET 1.1, .NET 2.0, .NET 3.0), ASP, ASP.NET, LINQ, Architect, DBA, Dev, Design	Prasad Bhalekar(PP)	2.00
SQL Get the last date of the month - Unedited Updated: 18 Nov 2009 declare @Date datetimeset @Date = '2009/10/17'Select dateadd(day, 0 - day(dateadd(month, 1 , @Date)), dateadd(month, 1 , @Date)) SQL	Asif Mushtaq	2.00
MySQL C++ Wrapper Updated: 4 May 2003 A set of C++ classes for working with the MySQL library. SQL, VC6, VC7, Windows, SQL Server, Visual Studio, MySQL, DBA, Dev	Kensho	1.98
Materialized Views in Oracle - Unedited Updated: 12 Nov 2006 This article explains in short what Materialized Views are and how to create read-only Materialized Views in Oracle. C#, Windows, .NET, Visual Studio, DBA, Dev	coolestCoder	1.96
Ilumnis Authentication Module - Unedited Updated: 27 Oct 2005 C# MS SQL user / role / right manipulation C#, Windows, .NET 1.1VS.NET2003, DBA, Dev	Darko@Ilumnis	1.94
A Way to Easily Connect to a SQL or an Access Database - Unedited Updated: 29 Jun 2006 An asembly that provides a way to retrieve, store and manipulate data in a SQL an Access database C#, Windows, .NET, Visual Studio, DBA, Dev	ovydiu	1.93
Database Script Generator - Unedited Updated: 9 Oct 2006 This utility can be used to compare two MS Access databases for changes in the data. You have the option of generating the SQL scripts and\or a summary XML XML, SQL, C# 1.0, VB 6.NET 1.0, Win2K, WinXP, Win2003VS.NET2003, DBA, Dev	Ajey Dudhe	1.92
Store/Save images in SQL Server - Unedited Updated: 5 Jan 2009 A sample program to demonstrate how to save or store images in Sql server. SQL, C# 1.0, C# 2.0, C# 3.0.NET 2.0, Win2K, WinXP, Win2003, Vista, .NET 3.0, .NET 3.5, ADO.NET, SQL 2000, SQL 2005, VS2005, VS2008, DBA, Dev	Shabdar Ghata	1.91
How to create CLR store procedure - Unedited Updated: 15 Oct 2006 This article will drive you, how to create CLR store procedure C#, Windows, .NET, Visual Studio, DBA, Dev	Malpani Amol	1.89
Delete mechanism. Updated: 17 Jan 2005 Explains a mechanism of deleting a record when the selected record has related records in other tables. C#, SQL, Windows, .NET, Visual Studio, ADO.NET, SQL 2000, DBA, Dev	Tadas Budvytis	1.88
Add/Drop LinkedServers using SMO - Unedited Updated: 31 Jan 2006 Add/drop Linked Servers using SQL Server 2005 SMO C#, SQL, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	arunpv	1.85
SQL - Time Table With Stored Procedure (SQL Server) - Unedited Updated: 14 Jul 2004 A Stored Procedure for Create a Time Table with all interesting details C++, SQLWin2K, WinXP, Win2003, Vista, Visual Studio, SQL 2000, SQL 2005, DBA, Dev	Romelard Fabrice (Alias F___)	1.83
Simple C# codegenerator for DB objects (table, store procedure) - Unedited Updated: 7 Mar 2005 This small utility generates code to call store procedure or C# class from Table C#, VC6, VC7, VC7.1, VB 6, .NET, Win2K, WinXP, Win2003, DBA, Dev	Gevorg	1.82
ADO.NET disconnected data - Unedited Updated: 11 May 2006 Shows the basics of working with ADO.NET disconnected data. C#.NET 1.1, Win2K, WinXP, Mono, Visual Studio, DBA, Dev	LockonFlamingCliffs	1.82
Easier Data Access Updated: 29 Dec 2004 The easier way of accessing data using intermidiate classes between basic ADO.NET classes and your own application. C#, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	interface Mirror	1.80
Converting Strings to DateTimes for Use in ADO.NET Parameterized Queries using the Data Access Applications Block 3.0 - Unedited Updated: 23 Oct 2004 This article shows you how to take a date string and use it in a parameterized sql server query C#, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev	ritzcoder	1.75
Get list of SSIS package and execut, from .NET application - Unedited Updated: 8 Oct 2006 This article will drive you, how to get list of SSIS packages and executing them using .NET assemblies C#, Windows, .NET, Visual Studio, DBA, Dev	Malpani Amol	1.75
Creating Log file for Stored Procedure - Unedited Updated: 19 Apr 2007 In this articleI am going to show how to create log file for stored Procedure C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev	sarvesh.upadhyay	1.74
Sql Database Connection DLL Written in C# - Unedited Updated: 8 Sep 2005 Connect and close a sql database with internal error reporting using Event Logs C#, SQL.NET 1.1, Win2K, WinXPSQL 2000, VS.NET2003, CEO, Architect, DBA, Dev	Member 2260574	1.73
OR.NET - OR Mapper for .NET 2.0 / SQL Server - Unedited Updated: 8 Oct 2006 Open Source OR Mapper which achieves object-relational persistence through generated C# 2.0 code. C#, Windows, .NET, Visual Studio, DBA, Dev	adamAFA46	1.73
Data Generator for SQL SERVER 2000,2005 and MSDE - Unedited Updated: 21 Aug 2006 The tool can generate the specified number of rows for any table. Can be used for stress testing the application C#, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, Architect, DBA, Dev	ganesan balachandar	1.72
Database manager - Unedited Updated: 19 Jan 2007 A usefull tool to control the database, easy to use and easy to control. C# 2.0, Windows, .NET 2.0, .NET 3.0, Visual Studio, DBA, Dev	NaNg15241	1.69
Automated Database Change Management Process - Unedited Updated: 4 May 2007 The uploaded .NET solution includes the implementation of a database change management process that, if applied correctly, can dramatically reduce the time you spend synchronizing various versions of application databases in development, staging, and production environments C#, Windows, .NET 2.0, SQL Server, Visual Studio, DBA, Dev	Kevin Hurwitz	1.67
SQL Server 2008 and T-SQL new features - Unedited Updated: 5 Jul 2007 This articel emphasizes on two key areas Microsoft data plat form vision and T-SQL new features for next generation of application development. C++, SQL, Windows, Visual Studio, SQL 2005, DBA, Dev	Rajesh Mascon	1.67
*SELECT FROM, sp_helptext ShortCut for SQL Query Analyzer** - Unedited Updated: 12 Jun 2006 A Key ShortCut for 'SELECT * FROM' for tables and to see text of the stored procedures. C++, SQL, Windows, Visual Studio, SQL 2000, DBA, Dev	Paresh Goyal	1.65
Multiple filters on a WHERE clause - Unedited Updated: 2 May 2005 How to write multiple filters on a WHERE clause on a sql sentence C++, SQL, Windows, Visual Studio, SQL 2000, SQL 2005, SQL CE, DBA, Dev	fhunth	1.63
Stored Procedure class generator Updated: 21 Nov 2004 Generate code classes to access stored procedures via web services. C#, SQL.NET 1.1, WinXP, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev	b_hardman	1.63
Using TableAdapters with transactions - Unedited Updated: 18 Feb 2007 Use TableAdapters with transactions C# 2.0.NET 2.0, WinXP, ADO.NET, SQL 2000, VS2005, DBA, Dev	Danko Greiner	1.63
LINQ to SQL versus ADO.NET Updated: 13 Dec 2007 A simple speed comparison. C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 1.0, .NET 1.1, .NET 2.0, Mono, DotGNU, .NET 3.0, .NET 3.5), ADO.NET, LINQ	Islam ElDemery	1.61
Access SSIS package activities and variable through .NET application - Unedited Updated: 8 Oct 2006 This article will drive you, how to access and update properties and variable of SSIS package using .NET application SQL, C# 2.0, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev	Malpani Amol	1.60
Implementing Database Versioning Updated: 3 Nov 2005 This database script provides a template for properly maintaining multiple versions of a database. C++, SQL, Windows, Visual Studio, SQL 2000, DBA, Dev	Ezhilan Muniswaran	1.48
Database to XML Exporter - Unedited Updated: 2 Aug 2001 Learn how to export database fields to XML document SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	Orkun GEDiK	1.40
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. SQL, HTMLWin2K, WinXP, ASP, Visual Studio, SQL 2000, DBA, Dev	BrianLaF	1.36
Data Access Helper Class - Unedited Updated: 9 Oct 2003 This class helps with connecting to DB engine and with returning of resultsets. C#, Windows, .NET, ASP.NET, Visual Studio, DBA, Dev	Radim_Hampel	1.36
Using ADO to connect to a Visual FoxPro (dbf) table in C++ - Unedited Updated: 16 Jun 2006 this is a simple sample about getting a db connection.using ADO to connect dbf table is part of my data query work.maybe it is too easy for someone else:) SQL, VC6, SQL Server, Visual Studio, DBA, Dev	zhipeng0117	1.35
*ABCs of ProC** - Unedited Updated: 23 May 2007 Basic understanding of Pro*C C, SQL, VC6, VC7, VC7.1, VC8.0, Windows, SQL Server, VS.NET2003, VS2005, Architect, DBA, Dev	vipulparmar	1.34
Writing SQL Server Database tables description into Word Document - Unedited Updated: 18 Aug 2005 Window application generates the document with Sql Server database tables C#, SQL, VC7.1.NET 1.1, WinXPSQL 2000, VS.NET2003, DBA, Dev	satya.rapelly	1.33
SQL Server –Active Directory Interaction - Unedited Updated: 17 Aug 2007 Descripe the SQL Server 2000/2005 interaction with Active Directory on Windows 2000 or 2003 server C++, SQL, eVC 4.0, Win Mobile, .NET, Mobile, Win2K, Win2003, Visual Studio, COM, SQL 2000, SQL 2005, SQL CE, CEO, Architect, DBA, Dev, QA, Design	ThomasMiller	1.33
Universal SqlBuilder class (Sql Server,Access, MySql, Sqlite and more) - Unedited Updated: 28 Aug 2007 SqlBuilder class automates and simplifies database operations C#, Windows, .NET, Visual Studio, MySQL, DBA, Dev	Igor Sokolsky	1.33
The Base Class of Connecting To Database - Unedited Updated: 25 Sep 2005 Perfect interface design for common database which would be used to easily connect to the most kinds of database, such as MS Access, MS SQL Server,..., and so on. Do not worry again about the terrible complex interface of ADO COM, take it easy to implementing your operation logical codes... SQL, VC6Win2K, WinXPSQL 2000, DBA, Dev	Churn Wuang	1.30
Capitalize the first character in SQL Server - Unedited Updated: 15 May 2006 This user-defined function will allow you to capitalize the first character of any string passed to it. C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev	Erik Bartlow	1.30
Connecting to Database Express 2005 with VS 2005 - Unedited Updated: 2 Aug 2006 Codes to help to connect VS 2005 to SQL Express manualy SQL, C# 1.0, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev	efero	1.27
A Master-Detail Solution Using Single Input Controls - Unedited Updated: 25 Nov 2005 Shows a solution for creating a master detail relation using textboxes C#, SQL, Windows, .NET, ADO.NET, WinForms, SQL 2000, VS.NET2003, DBA, Dev, QA	TofuBug24	1.22
NetDbExplorer : Demo for mj10777.DataBase Class - Unedited Updated: 16 Feb 2004 The use of mj10777.DataBase to Connect, Create (Database/Table), Read and Fill Tables, Update, Insert and Delete Records and show results in a TreeView / ListView Application. C#, Win Mobile, .NET 1.1, Win2K, WinXP, Win2003, Visual Studio, DBA, Dev	Mark Johnson	1.19
Get comma separated result - Unedited Updated: 15 Nov 2007 Create command for getting comma seperated value C#, SQL, Windows, .NET 2.0, SQL Server, VS2005, DBA, Dev	Sun Rays	1.17
FireBird SqlAssistant - A FireBird SQL Data Block - Unedited Updated: 16 Jan 2007 A FireBird .NET data access block completely written in C#. Supports Embedded SQL, INI File SQL and Stored Procedure C#, Windows, .NET, Visual Studio, DBA, Dev	Rafey	1.16
Format Number to 2 Decimals in MS SQL without Rounding - Unedited Updated: 15 Oct 2004 Format any Number to 2 decimal Number without Rounding C#, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev	ashishnaik1	1.15
My Code Generator For SP and Tables - Unedited Updated: 12 Nov 2007 My Code Generator For SP and Tables C++, Javascript, XML, SQL, C# 2.0, Windows, .NET 1.1, .NET 2.0, ASP.NET, WebForms, Ajax, SQL 2000, VS.NET2003, VS2005, DBA, Dev	Mohammad Rizwan	1.11
An Article- Simplify your life with Object Binding - Unedited Updated: 19 Jan 2007 The .NET framework provides a very flexible and powerful approach to databinding that cuts down a lot of redundant code and simplifies the development process significantly. Unlike the earlier databinding models, which were limited to single data source, the .NET framework provides read/write (two w C#, .NET CF, Mobile, .NET 2.0, Win2K, WinXP, ASP.NET, VS2005, DBA, Dev	Iqbal M Khan	1.09
How to automatize work when working with Typed Dataset Against a database (CSC) - Unedited Updated: 22 Nov 2006 DatasetAdaptor encapsulate a dataset and permit to automatize the work between database and this dataset. C#, Windows, .NET, Visual Studio, DBA, Dev	BlaiseBraye	1.00
Finding nth day of nth week - Unedited Updated: 28 Jun 2007 The Sql Server function helps to get the nth day of the nth week. It returns the required date. SQL, C# 1.0, Windows, .NET, ASP.NET, Visual Studio, WebForms, SQL 2000, DBA, Dev	harry_kochhar	1.00
SqlDbAdaptor hides underlying database - Unedited Updated: 4 Sep 2007 SqlDbAdaptor hides underlying database and makes very easy to switch database without a single line of code change C#, Windows, .NET, Visual Studio, DBA, Dev	Igor Sokolsky	1.00
Simplified phonetic search with MS SQL Server - Unedited Updated: 1 Nov 2007 Perform phonetic search on MS SQL Server using Soundex C++, SQL.NET 1.0, .NET 1.1, .NET 2.0, Win2K, WinXP, Win2003, Vista, TabletPC, .NET 3.0, .NET 3.5SQL 2000, SQL 2005, DBA, Dev	vini2k1	1.00
SQL Server Integration Services (SSIS) 15 Best practices - Unedited Updated: 17 Sep 2009 SQL Server Integration Services (SSIS) 15 Best practices SQL, Windows, SQL Server (SQL 2005), Oracle, Architect, DBA, Dev, Design	josekonoor	1.00
SQL Get the last date of the month - Unedited Updated: 7 Sep 2009 Select dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 - day(@Date), @Date)) SQL	Mycroft Holmes	1.00
Export data from SQL Server to MS Access - Unedited Updated: 19 Nov 2009 Introduction Exporting data from SQL Server to MS Access can be achieved in a variety of ways. The purpose of this article is to provide a fast but easy way to export data from SQL Server to Access. Background You must know how the select & insert statements work in SQL Server. Using the SQL 2000	Muhammad Shahid Farooq	1.00
Osql Batch Scripter - Unedited Updated: 15 Nov 2006 Modification of the Osql Batch Scripter C#, Windows, .NET, Visual Studio, DBA, Dev	F.E.A.
Reading and Writing Images From a Windows Mobile Database using UltraLite 10(C#) - Unedited Updated: 28 May 2007 The purpose of this article is to help developers who are looking to access and store images on Windows Mobile applications using C# and UltraLite. C# 2.0, Windows, .NET CF, Mobile, .NET 2.0, SQL Server, VS2005, DBA, Dev	Liam Cavanagh
SQLServer2000 Deadlock Analaysis - Unedited Updated: 15 Oct 2007 SQLServer2000 deadlock analysis. C++, SQLWinXP, Win2003, Visual Studio, SQL 2000, DBA, Dev	Tijoy Tom
Scheme of Persistence - Unedited Updated: 19 Nov 2007 Mapping business objects and Store Procedures C# 1.0, Windows, .NET, Visual Studio, DBA, Dev	IVAN MARTINEZ HERNANDEZ
Isolation Levels Updated: 16 Apr 2009 This article shows where each Isolation Level can be used, and which ones are better for validations. SQL Server, MySQL, Oracle, DBA	Paulo Zemek
Sql Server - Sort Order Templates - Unedited Updated: 11 Jun 2009 Templates to fix changes in sort-order as they occur. SQL, SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), DBA	ColinBashBash
SSIS insert bulk of data into remote table with trigger - Unedited Updated: 17 Nov 2009 hmmm, nice we have SSIS it makes life easier but it usually comes with non-understood problems like "SQL Server Destination" (2185) failed with error code 0xC0202071 it means when you insert data into table in remote SQL Server don't use SQL Server Destination component however use OLE DB Destinatio SQL Server	Ramy Mahrous
SQL Server Recursive Fetch From Self Referencing Table - Unedited Updated: 19 Nov 2009 CREATE PROC GetChildNodes (@ID uniqueidentifier) AS BEGIN WITH PermissionList (PermissionID, PermissionName, Level) AS ( SELECT ap.PermissionID, ap.PermissionName, 0 AS Level FROM Permission AS ap WHERE PermissionID = @ID UNION ALL SELECT ap.PermissionID, ap.PermissionName, Level + 1 FROM "SQL, Recursive, Self, Referencing"	Anish M
Convert layered MS Access queries to .NET - Unedited Updated: 21 Nov 2009 I am trying to convert some MS Access queries to .NET. These queries call other queries that call other queries, etc., sometimes up to five levels deep. I am trying to avoid using subqueries because of the amount of testing that would be required, some of the lower level queries are used in multip .NET, Access, queries	edperkins_jr
Database - MySQL			top
Title / Updated	Author	Score
MySQL User Defined Functions Updated: 20 Sep 2006 Tutorial on writing your own MySQL User Defines Functions C, SQL, VC6, Windows, SQL Server, Visual Studio, MySQL, DBA, Dev	DarkLizener	4.85
SQL Server to SQL Server Compact Edition Database Copy Utility - Unedited Updated: 26 Jun 2008 Create and manage your mobiles database using SQL Management Studio and export them to SQL Compact Edition databases C#, SQL, Windows, SQL Server (SQL 2000, SQL 2005, SQL CE), WinForms, Dev	johnnycantcode	4.80
Tracing SQL Queries in Real Time for MySQL Databases using WinDbg and Basic Assembler Knowledge Updated: 26 Oct 2009 Assembly and MySQL. ASM, Windows, Win32, MySQL, DBA, Dev, QA	Rene Pally	4.75
Site Statistics with PHP and MySQL Updated: 22 Apr 2009 Site statistics with PHP and MySQL PHP, MySQL	Ghaffar Khan	4.67
Connect csharp to Mysql - Unedited Updated: 17 Nov 2009 Connect C# to mysql using MySql Connector/Net, Insert, Update, Select, Delete example, Backup and restore mysql database from C# or .net application C#, .NET, Visual Studio, Dev	Etienne Rached	4.60
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 C# (C# 1.0, C# 2.0, C# 3.0), SQL, .NET (.NET 1.0, .NET 1.1, .NET 2.0, Mono, DotGNU, .NET 3.0, .NET 3.5), MySQL, DBA, Dev	lzcampbell	4.20
Working C# code for MySql Stored Procedures IN, OUT, and INOUT parameters - Unedited Updated: 15 May 2009 An article on how to get parameters into and out of MySql stored procedures. C# (C# 2.0), SQL, Windows (WinXP), .NET (.NET 2.0), Win32, Visual Studio (VS2005), WinForms, MySQL, Dev	ken.tachyon	4.20
C# MYSQLWrapper Class and PHPWrapper-Script Updated: 7 Nov 2007 Accessing the MYSQL Database at your webspace from any remote computer C# 2.0, Windows, .NET 1.1, .NET 2.0, PHP, MySQL, VS.NET2003, VS2005, DBA, Dev	cellarjay	4.13
Minimalistic Driver-less Native MySql Client - Unedited Updated: 11 May 2009 Native MySql Client not requiring any special driver or library C++, C++/CLI, C, SQL, Windows (Win2K, WinXP, Win2003, Vista, TabletPC, Embedded, Win2008), Win Mobile, Win32, SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), Visual Studio, MySQL, Architect, DBA, Dev	Ladislav Nevery	4.02
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 C++, SQL, Windows, SQL Server, Visual Studio, MySQL, DBA, Dev	Richard Lin	3.79
Mysql Data Access Layer Updated: 20 Apr 2009 This an easy way to interact with your mysql database. C# (C# 1.0, C# 2.0, C# 3.0), SQL, .NET (.NET 2.0, .NET 3.0), ASP.NET, ADO.NET, MySQL, Architect, Dev	titandeveloper	3.46
Accelerate database performance using In Memory CSQL Cache - Unedited Updated: 3 Jun 2008 CSQL Cache is an open-source high performance, bi-directional updateable data-caching infrastructure that sits between the clustered application process and back-end data sources to provide unprecedented high throughput to your application C++, C++/CLI, SQL, CEO, Architect, Dev, Design	praba_tuty	1.78
Upload images into MySQL database using VC++ - Unedited Updated: 24 Sep 2009 Upload images into MySQL BLOB field using ODBC driver C++ (VC6, VC7, VC7.1, VC8.0), C++/CLI, C	$uresh $hanmugam	1.50
MySQL Table Manager Updated: 4 May 2008 The MySQL engine permits user level locks. This article explains how to manipulate these lock types. C#, SQL, .NET (.NET 2.0), WinForms, Dev	AKA MAJO
Security Manager - Full Control of MySQL Users and Their Privileges - Unedited Updated: 9 Oct 2008 A new free tool to easily manage database users, their privileges and more. SQL	docsmaker
MySQL backup,compress and FTP from WinForms - Unedited Updated: 27 Mar 2009 Backup entire MySQL database, compress it and send it with FTP to a ftp server Visual Studio (VS2008), DBA	Kunjal999
Database - ODBC			top
Title / Updated	Author	Score
ODBCTracer Updated: 4 Aug 2005 Using Microsoft's tracing infrastructure for ODBC. SQL, VC6, VC7.1Win2K, WinXP, SQL Server, VS.NET2003, DBA, Dev	Doga Arinir	4.73
CODBCRecordset class Updated: 6 Jan 2001 CODBCRecordset class is intended to be full replacement of all ClassWizard generated CRecordset derived classes in MFC projects. SQL, VC6, SQL Server, Visual Studio, MFC, DBA, Dev	Stefan Chekanov	4.72
Database info tool Updated: 26 Oct 2000 Explore the structure of tables (and views) SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	Massimo Colurcio	4.68
The CODBCDynamic class Updated: 14 Mar 2000 A class to dynamically read data from any ODBC data source SQL, VC6, SQL Server, MFC, DBA, Dev	Tom Archer	4.65
CODBCAccess: a CDatabase and CRecordset Wrapper Updated: 12 Mar 2003 A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases SQL, VC6, VC7Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev	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. SQL, VC7.1WinXP, MFC, STL, SQL 2000, VS.NET2003, DBA, Dev	Dave Handley	4.63
Interactive SQL Tool (using ODBC) Updated: 17 Jan 2000 A tool that allows you to query ODBC sources SQL, VC6, SQL Server, MFC, DBA, Dev	George Poulose	4.61
A set of ODBC Classes Updated: 27 Aug 2001 Two classes that make easy to work with ODBC SQL, VC6Win2K, SQL Server, Visual Studio, MFC, DBA, Dev	Carlos Antollini	4.60
DataLayer - Freeware ODBC Library Updated: 10 Jan 2006 An article on a simple ODBC SDK wrapper library. SQL, VC6Win2K, WinXP, SQL Server, DBA, Dev	darkoman	4.47
Two classes for parameterized SQL statement and stored procedure Updated: 13 Oct 2002 An article on using parameterized SQL statement and stored procedure with ODBC SQL, VC6, VC7Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev	dapeng lin	4.44
EasyODBC Updated: 19 Aug 2003 An easy to use C++ wrapper class for ODBC. SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	Vijay Mathew Pandyalakal	4.17
Parameterized CODBCRecordset Class Updated: 16 Jul 2001 CODBCRecordset that support parameter prior to opening table(s) SQL, VC6Win2K, SQL Server, Visual Studio, MFC, DBA, Dev	Sasa Kajic	4.00
Simple ODBC classes without MFC Updated: 3 Nov 2001 A collection of simple classes to connect to ODBC capable DBMS and share those connections SQL, VC6, SQL Server, Visual Studio, DBA, Dev	Justin Kirby	3.83
Simple ODBC Wrapper Updated: 2 Jul 2004 Simple ODBC Wrapper + Connection classes for several database types. SQL, VC7Win2K, WinXP, Win2003, Visual Studio, SQL 2000, DBA, Dev	TomKat	3.80
Rails-like Model Base Class for C# .NET Using an ODBC Connection Updated: 10 Feb 2009 This is a base class that can be used to create model objects for database connectivity via ODBC in C# .NET. C#, .NET, ADO.NET, Dev	Derwin Dexter Sy
Database - OLE DB			top
Title / Updated	Author	Score
A Visual SQL Query Designer Updated: 23 Oct 2009 This article describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OLEDB connection string. C#, VB, SQL, Windows, .NET, ADO.NET, DBA, Dev	Bernardo Castilho	4.88
Database Development using Visual C++ and OLE DB: Establishing the connection Updated: 28 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. C++, SQL, Windows, Visual Studio, ATL, SQL 2000, DBA, Dev	emadns	4.85
The Dynamic Database Class Based on ATL/OLE DB Updated: 23 Apr 2002 A class to dynamically manipulate databases data using ATL/OLE DB technology SQL, VC6Win2K, WinXP, SQL Server, ATL, DBA, Dev	Eugene Khodakovsky	4.73
Using MS DataGrid control with OLE DB consumer Updated: 22 Sep 2001 Use the MS DataGrid control in your C++ app with OLE DB Consumer Templates SQL, VC6Win2K, SQL Server, MFC, ATL, DBA, Dev	Rashid Thadha	4.41
OLE DB consumer using basic C++ Updated: 12 Nov 2001 This article is the first of a series OLE DB articles that cover database access using the OLE DB Templates SQL, VC6, VC7Win2K, SQL Server, MFC, DBA, Dev	Anthony Roach	4.21
Microsoft Indexing Service and OLEDB Updated: 15 Apr 2008 How we can access the Windows Indexing Service using OLEDB. SQL, Windows, SQL Server (SQL 2000, SQL 2005), ADO.NET, Dev	Ali Hamdar	4.06
High Performance OLE DB library : Ease of ADO, power of OLE DB Updated: 2 Dec 2001 Introduction to OLE DB extended classes SQL, VC6Win2K, WinXP, SQL Server, DBA, Dev	Ghanshyam Naik	3.66
Creating an OLE DB Data Provider Updated: 12 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. SQL, VC6Win2K, WinXP, SQL Server, MFC, DBA, Dev	David Utz	3.54
Intermeadiate OLE DB Consumer in C++ Updated: 4 Dec 2001 This article expands on my previous article and introduces recordset operations and database entry operations. SQL, VC6, VC7Win2K, WinXP, SQL Server, MFC, DBA, Dev	Anthony Roach	3.38
An OLE-DB DLL that you can use in ANSI-C Updated: 3 Jul 2002 An OLE-DB DLL that you can use in ANSI-C SQL, VC6Win2K, SQL Server, MFC, DBA, Dev	roboo	3.33
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 SQL, VC7, VC7.1, VC8.0Win2K, WinXP, SQL Server, ATL, STL, VS.NET2003, DBA, Dev	Jörgen Sigvardsson	3.28
Raw OLEDB Class Library Updated: 13 Jun 2005 This class provides a raw OLEDB class library. C++, SQL, Windows, SQL Server, VS2005, DBA, Dev	esob	3.17
Memory Leaks in ATL OLEDB Consumer Objects on CCommand Updated: 23 Apr 2009 Reports the memory leak issue on the ATL OLEDB CCommand object, and describes the reason and provides a solution. VC6, VC7, VC7.1, VC8.0, Windows, ATL, Dev	jason lue	3.00
Building a Database Application using OLE DB Updated: 11 May 2004 An article on building a Database Application with OLE DB SQL, VC6, Windows, SQL Server, DBA, Dev	Yulianto	1.67
ATL OLEDB Memory Leak 2: CDynamicParameterAccessor Updated: 27 Apr 2009 A subtle memory leak problem on CDynamicParameterAccessor on special occasions C++ (VC6, VC7, VC7.1, VC8.0), C++/CLI, C	jason lue
Database - Oracle			top
Title / Updated	Author	Score
Sql180 Developer Updated: 25 Oct 2008 A Graphic tool for Oracle developers and DBAs C#, SQL.NET 2.0, WinXP, Win2003, Vista, .NET 3.0, .NET 3.5, Oracle, VS2005, VS2008, DBA, Dev	Guy Haim	4.60
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! SQL, VC6, VC7, Windows, SQL Server, Visual Studio, Architect, DBA, Dev	Koushik Biswas	4.24
Instant Oracle Using C# Updated: 7 May 2007 Connecting to Oracle using C# without using Oracle Developer Tools for Visual Studio .NET. Managing Oracle connectivity with a minimal footprint using Oracle Instant Client. C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev	Paul Groetzner	4.17
OraLib - a lightweight C++ wrapper over Oracle's OCI library Updated: 3 Jul 2002 6 classes that provide a lightweight C++ wrapper over Oracle's OCI library SQL, VC6, SQL Server, DBA, Dev	Bobi B.	4.12
Returning Multiple Ref Cursors from Oracle using DAAB Updated: 9 Jun 2009 How to return multiple ref cursors from Oracle using DAAB C# (C# 1.0, C# 2.0, C# 3.0), .NET, ASP.NET, Oracle, DBA, Dev	himanshu2561	3.86
C++ wrapper for Oracle's OCI Interface Updated: 27 Sep 2002 This article will provide a cross platform C++ wrapper for Oracle's OCI interface. C, SQL, VC6Win2K, WinXP, SQL Server, DBA, Dev	lihaijian	3.50
A Very Simple Oracle Query Tool Updated: 11 Jul 2008 This is a very simple tool, to query an Oracle XE database C# 2.0.NET 2.0, WinXP, Visual Studio, Oracle, Dev	Syed M Hussain	3.41
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. C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev	rovshan_b	3.39
Auto-discover Oracle TNS service names with COSidHelper class Updated: 5 Sep 2003 An article on how to discover Oracle TNS service names. SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, MFC, DBA, Dev	li@agileinfollc.com	3.39
OraToolDotNet Updated: 25 Jan 2008 An oracle database query, schematic view and query export tool C# (C# 2.0), Windows, .NET (.NET 2.0), ADO, DBA, Dev	cato35ksk	2.60
Oracle connection and cursor class for Visual C++ in a VB Style Updated: 19 Dec 2002 A class to connect Oracle using OCI8 libs, that simplifies the connection and the access to data using SQL strings. SQL, VC6, VC7Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev	jperez	2.56
TNSNames Reader Updated: 13 Nov 2008 An article explaining how to list oracle data sources from tnsnames.ora file C#, Oracle, DBA, Dev	ciro_vladimir	1.67
Creating and Modifying Database Objects - Unedited Updated: 30 Mar 2008 oracle 10g	Ali Etoom
Other databases			top
Title / Updated	Author	Score
Building an embedded database engine in C# - Unedited Updated: 10 Jun 2009 DbfDotNet is a very fast and compact fully managed standalone database/entity framework, for the .Net Framework. C# (C# 1.0, C# 2.0, C# 3.0), Dev	Pascal Ganaye	4.93
SQLiteTbl, A C++ class that provides a CRecordSet like interface for SQLite Updated: 2 Dec 2008 A CRecordSet like interface for a SQLite database table. C++ (VC6, VC7, VC7.1, VC8.0), C, Dev	Brad Kremer	4.88
Writing UDFs for Firebird Embedded SQL Server Updated: 23 Oct 2009 We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications C++, C#, SQL, Windows, Architect, Dev	Ivan_Komarov, Apriorit Inc	4.74
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. C++/CLI, C#, VB, VC7.1.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, VistaVS.NET2003, DBA, Dev	CastorTiu	4.69
Uploading and Downloading BLOBs to Microsoft Access Updated: 21 Dec 2006 Illustrates how to upload and download BLOB data to Microsoft Access. C#, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	zam664	4.67
Fulltext Search for Firebird SQL Updated: 9 Mar 2005 How to search data stored in a Firebird SQL database using a fulltext index. C#, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev	Dan Letecky	4.62
An introduction to LINQ for db4o - Unedited Updated: 8 May 2008 A demo web application for demonstrating the power of LINQ for db4o. C# (C# 3.0), .NET, ASP.NET, LINQ, Dev	edwin_vermeer	4.61
MySqlUtil - TableAdapters for MySql Updated: 3 Aug 2006 A program which generates Typed DataSets and TableAdapters for MySQL databases C# 2.0, Windows, .NET 2.0, MySQL, VS2005, DBA, Dev	Ian Semmel	4.59
The Lob Stream Framework, Part 1 Updated: 5 Jul 2007 Providing a few classes and types that aid in the use of lob streams C#, Windows, .NET, Visual Studio, DBA, Dev	Peter De Jonghe	4.58
Embedded Firebird: Full-Featured Embedded Database with 2 MB Runtime Updated: 28 Jan 2005 An example that shows how Firebird database excels in embedding. C#, SQL, Windows, .NET 1.1, ADO.NET, WinForms, VS.NET2003, DBA, Dev	Dan Letecky	4.53
Oracle Service Manager Updated: 13 May 2004 Manage the state of Oracle services to conserve resources -- just like Microsoft SQL Server Service Manager. C#.NET 1.1, Win2K, WinXP, Win2003VS.NET2003, DBA, Dev	Rob Kayman	4.53

Language ASM VB VB 7.x VB 8.0 VB 9.0 VB 10 VB 6 VBScript C Objective C C++ VC6 VC7 VC7.1 VC8.0 VC9.0 C++/CLI C# C# 1.0 C# 2.0 C# 3.0 C# 4.0 CSS eVC eVC 3.0 eVC 4.0 F# Forth.NET HTML Java Javascript JScript .NET MSIL Perl Python IronPython Python 2.4 Python 2.3 Python 2.2 Ruby IronRuby Ruby 1.8 SQL UML X++ XML XHTML XSLT Erlang	Platform Windows Win2008 R2 Win 7 Win2008 Vista Win2003 WinXP Win2K TabletPC Embedded Win Mobile PocketPC 2002 WinMobile2003 WinMobile5 WinMobile6 Mobile PalmOS iPhone Android Blackberry .NET .NET 1.0 .NET 1.1 .NET 2.0 .NET 3.0 .NET 3.5 .NET 4.0 Mono DotGNU .NET CF Java JavaSE 6 J2SE 5 J2SE 4 J2EE J2ME Linux Office XBox	Technology All Topics Ajax ADO.NET ADO ASP.NET ASP Apache ATL AWT COM COM+ DirectX Flash GDI GDI+ Hardware IIS IIS 5.1 IIS 6 IIS 7 JNDI jQuery JDBC JNI LINQ MFC MVC MySQL Oracle OpenGL SAP PHP Silverlight SQL Server SQL 2000 SQL 2005 SQL CE SQL 2008 STL Swing Visual Studio VS.NET2003 VS2005 VS2008 VS2010 Win32 Win64 WebForms WinForms WTL WPF AppFabric Azure WCF XAML PowerShell Groovy	Audience CEO Architect Dev DBA Design QA SysAdmin Marketing Sales	Skill Level Beginner Intermediate Advanced	Topic economics C++ and SQL vb.net VS.NET 2005 vb .net "Silverlight Marquee" programing tips VLGxFAnNSGMqcy "SQL Recursive Self Referencing" 4Ca2ox moss2007 2Dk8K vc++.net vs2008 NYBzl DOrmb2 7zMMh Google Map Sharp Map Jz2sv C# 3.5 C#.NET Rashid FtpWebRequest C#.net 3.5 scheme vb6.0 sql oracle H9kHHi Threading YwsljrtccgbPxeol mYeSpgWnuaEQqvF IgUbCOVe QulmWpmGWdFUuNeJMN fFBBHeosX HbbFbaWQQ JqNdjAvkoPCS psuuIMQx dmVHfqwBaAvEIVJx USweCzAV uURcyJBq MtGgXNkXjiROD WTHDpNZSRa uJxQurtTBnNc gEuBlAazYbvXxnxkHU kTbqueDNUuighp var lpik0 keyboard hook low level nkZneOxJNHrxIENeW Excel Encryption Decryption ubuntu XqVHccXWdwz Filter SRDqSCKqdeAQQhkUgM KpsqOYORdDLO ojdJrmzRp cPSmOratUAav KeBwqXiMkKjXE SnQaNGsjLc qsVWOuiSLBjlMxqt vdXOQmKZrWxOh pKtEsAoriqiRMk CNtFDanAWAxxNySx ydCASUGOqvcSyGZy pEwrLKoC sWYYxZwk AtRJWQlo BZyBaKfUIcclR UoLkybWZPVSBl whIhVYYpa BUaxiojuT onqIcdEsb PbUxODnfib "Asp .net Browsing the Button" .net3.5 c# winforms c# winforms jdk Visual C++ 2008 Sharepoint sdf sqlce ActiveX HKebzKeVWABCCRnZ MEDrFzsYNxqUcB aLDoYdTVo progress bar msi windows installer java and sql BcqvBaxCHJAP java sql JGRiUYThSpHHDvhjezd KeeBkVSfBIW game learn rjoXEmAYZElUcX tcUdUOgD mZczxYcQQmkNm uzoWaXcDBvfRZds enIlbrOcmyfhu YqBBhSxJmyexteHU sgxVYVeLNLB FWeWngrIPsLY LLTfFFsyQxUR ePYXXEoBZlPyLVY bdaNfesENGqMIqfLh nqydPPsnU vnHcWHjTdEYqsSkWj tOMLYhCXIF XCXOnjrryfoXXmLNV JKHWZyQUYAExYSxhPvr oxtondambr lindelparr Exception Handling question Gridview Sorting Bidirection DateTime format smalldatetime liwHByTiEcX kmVnfrmeMSOVDdhXm xKDPHShuKQCwxegNoN jdjfEkabXKWjlswNaa JSqriUkJRDNTkzri gZvJhZKoczBYaCZpK tizFCdZdwE mSrwvHBIbDNVYIG zGEOqOcSddZTAtZJf TZGjogyysO LJmbLedVgBrRYdJ ESsFtAexWnyvGJkMg MVUXuwEdOpV NHMSwFUMfySHAVe OPvlJsgoFcqr pTVgdyEgdxyeDOAAf lezsReLuUwhhMomr oCOYdbqwElJiMOeWdDX yYxRVpFLWIEXz YHcsidXxWE Access queries keyhook lowlevel global GRCdfhFUBobsIoveD CqKbHjflLaPgRMfFwB DataGridView struts exception interceptor M9qUkk d5leep XMMZqX
Clear AllMatch all selected tags? (default is: match 1 or more)

Database

Contents