|
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.NET1.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.71 |
|
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, SQL2000, SQL2005, 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, SQL2000, SQL2005, 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 |
|
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!
VB6, SQL, VC6Win2K, 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
VB6, VB, 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 (SQL2000, SQL2005, SQL-CE), DBA
|
shekharshashi |
1.00 |
|
|
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 (.NET3.5), ADO.NET, Architect, Dev
|
Perry Marchant |
4.88 |
|
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.74 |
|
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, .NET1.1, ADO.NET, WinForms, VS.NET2003, Dev
|
Declan Brennan |
4.72 |
|
An Experimental Performance Comparison on the Methods to Pass Structured Data to SQL Server Stored Procedures from ADO.NET
Updated: 23 Dec 2009
This article makes an experimental comparison on the performance of the different methods to pass structured data to SQL Server Stored Procedure parameters from ADO.NET.
C#, SQL, .NET, SQL-Server, ADO.NET, Architect, DBA, Dev
|
Dr. Song Li |
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 (.NET3.5), SQL-Server (SQL2005), 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, .NET1.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, .NET1.0, .NET1.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, .NET1.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#.NET3.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, SQL2000, SQL2005, 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 |
|
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.60 |
|
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.NET1.0, Win2K, WinXP, ASP.NET, Dev
|
Xiangyang Liu 刘向阳 |
4.59 |
|
Using ADO.NET for beginners
Updated: 12 Sep 2005
ADO.NET for beginners.
C#, SQL.NET1.1, WinXP, ADO.NET, VS.NET2003, DBA, Dev
|
Huseyin Altindag |
4.58 |
|
C# 2.0 Nullable Data Readers
Updated: 20 Jan 2006
An article on nullable data readers for .NET 2.0 nullable types.
C#, Windows, .NET2.0, ADO.NET, VS2005, DBA, Dev
|
Steve Michelotti |
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, .NET2.0, ADO.NET, VS2005, DBA, Dev
|
PIEBALDconsult |
4.53 |
|
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, VB7.x, Windows, .NET1.1, .NET2.0, ASP.NET, SQL-Server, IIS, VS.NET2003, CEO, DBA, Dev
|
FrankNight |
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.NET1.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, .NET2.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 |
|
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 (.NET2.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.38 |
|
ADO.NET Entity Framework as Data Access Layer
Updated: 30 Oct 2009
ADO.NET Entity Framework as Data Access Layer
C#, .NET (.NET3.5), ADO.NET
|
sarvesh.upadhyay |
4.33 |
|
DatabaseAccessor
Updated: 23 Aug 2007
A simple base class that encapsulates basic database access functionality
C#, Windows, .NET2.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 |
|
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.30 |
|
.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 |
|
Build database independent ADO.NET programs with Mimer Provider Manager
Updated: 31 Mar 2004
Write database independent ADO.NET applications
C#, Windows, .NET1.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.NET1.0, .NET1.1, Win2K, WinXP, Win2003, ASP.NET, ADO.NET, VS.NET2003, DBA, Dev
|
Pinx |
4.24 |
|
ADO.NET DataTable as XML parameter to an Oracle/SQL Server Database Stored Procedure
Updated: 27 Jan 2010
ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.
C#, Windows, ASP.NET, SQL-Server, ADO.NET, Oracle, Dev
|
Bibhas Paul |
4.23 |
|
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 |
|
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 (.NET3.5), ADO.NET, Dev
|
Vishal Shukla |
4.20 |
|
The ADO.NET OleDbDataReader class
Updated: 22 Aug 2003
Accessing database information using the DataReader class from ADO.NET in C#
C#, Windows, .NET1.0, .NET1.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 |
|
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, .NET2.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#.NET1.0, .NET1.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 |
|
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.06 |
|
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, .NET1.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, .NET1.1, .NET2.0, Visual-Studio, ADO.NET, DBA, Dev
|
BoneSoft |
4.00 |
|
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 (VB8.0, VB9.0), SQL, Windows, .NET, ASP.NET, SQL-Server, ADO.NET, DBA, Dev
|
Johnny Worker |
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 (.NET3.5), ADO.NET, DBA, Dev, Design
|
Balamurali Balaji |
4.00 |
|
Generating Class Representations Of SQL Tables
Updated: 24 Dec 2009
Automatically parses SQL tables into C# classes with functions like insert, select, etc.
C# (C#3.0), .NET (.NET3.5), SQL-Server (SQL2008), ADO.NET
|
dr.ozgur.sonmez |
4.00 |
|
Data Access Component
Updated: 24 Dec 2009
A simple data access component for connecting with different types of data sources.
C#, .NET, ADO.NET, Dev
|
Aj 2010 |
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.NET1.0, .NET1.1, .NET2.0, WinXP, .NET3.0, ASP.NET, ADO.NET, WebForms, SQL2000, 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.NET2.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 (.NET3.5), ADO.NET, Architect, Dev
|
Morshed Anwar |
3.91 |
|
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.NET2.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 (.NET3.0, .NET3.5, .NET4.0), SQL-Server (SQL2005, SQL2008), Visual-Studio (VS2008), ADO.NET, WinForms, WebForms, LINQ, Architect, DBA, Dev, QA
|
Bishoy Ghaly |
3.76 |
|
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#.NET1.0, Win2K, Visual-Studio, Dev
|
John McTainsh |
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, .NET1.0, Dev
|
Naveen K Kohli |
3.74 |
|
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, .NET1.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, .NET3.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 (.NET1.1, .NET2.0, .NET3.0, .NET3.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#.NET4.0, ADO.NET, Dev
|
TimMerksem |
3.60 |
|
Building Insert and Update Statements Automatically
Updated: 31 Jan 2010
Classes to build insert and update statements for Microsoft SQL, OleDb and ODBC dataprovider
C#, .NET, ADO.NET, Dev
|
Arno Petersen |
3.60 |
|
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 (.NET3.5), ASP.NET, ADO.NET, Dev
|
stexavcar |
3.50 |
|
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, .NET2.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 (.NET3.5), SQL-Server (SQL2000, SQL2005), ADO.NET, Oracle, DBA, Dev, QA, SysAdmin
|
TSells |
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.39 |
|
ADO.NET
Updated: 23 Dec 2008
Understanding ADO.NET
C#, ADO.NET, WinForms, Dev
|
logicchild |
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 (.NET2.0), Visual-Studio (VS2005), ADO.NET, Dev
|
Brice Schagane |
3.32 |
|
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.30 |
|
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, .NET3.0, ASP.NET, Visual-Studio, WebForms, Dev
|
Murali Krishna .Y |
3.25 |
|
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, .NETCF, .NET1.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 |
|
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.17 |
|
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, .NET1.1, Visual-Studio, SQL2000, DBA, Dev
|
Aravind Rajagopal K |
3.14 |
|
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 |
|
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 |
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, .NET1.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 |
|
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.
VB7.x, Windows, .NET1.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 |
|
.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, .NET1.0, .NET1.1, .NET2.0, .NET3.0VS.NET2003, VS2005, Dev
|
NinethSense |
2.26 |
|
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, .NETCF, Mobile, .NET1.1, Win2K, WinXP, ADO.NET, VS.NET2003, Dev
|
Pinx |
2.25 |
|
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, SQL2000, 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#.NET1.0, .NET1.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.NET1.0, .NET1.1, .NET2.0, .NET3.0, .NET3.5, ADO.NET, SQL2000, SQL2005, 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 |
|
|
|
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!
VB6, SQL, VC6, 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 (.NET2.0, .NET3.0, .NET3.5), SQL-Server (SQL2000, SQL2005, SQL-CE, SQL2008), 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.
VB6, SQL, VC6, 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 (SQL2000), 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!
VB6, SQL, VC6, 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!
VB6, SQL, VC6, 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!
VB6, SQL, VC6, SQL-Server, MFC, DBA, Dev
|
Len Holgate |
3.60 |
|
|
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.75 |
|
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 |
|
|
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.NET2.0, .NET3.0SQL2005, SQL2008, 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 (.NET3.5), ASP.NET, ADO.NET, Dev
|
Charles T II |
4.94 |
|
Don't hard code your DataProviders
Updated: 1 Feb 2010
Correctly using provider factories to create database independant code.
XML, C#2.0, C#4.0.NET2.0, .NET3.0, .NET3.5, .NET4.0, ADO.NET, Dev
|
Alaric Dailey |
4.88 |
|
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.83 |
|
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), .NETCF, .NET (.NET2.0, .NET3.0, .NET3.5), Visual-Studio (VS2005, VS2008), ADO.NET, Dev
|
Qwertie |
4.78 |
|
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.74 |
|
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 (.NET3.0, .NET3.5), ASP.NET, Architect, DBA, Dev
|
Jeremy Likness |
4.71 |
|
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.61 |
|
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 |
|
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, .NET1.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.NET2.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, .NET1.1, .NET2.0, .NET3.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, .NET1.0, .NET1.1, ADO, ADO.NET, SQL2000, 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, .NET1.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, .NET1.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, SQL2000, SQL2005, 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.NET1.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.
VB6, C#.NET1.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, .NET1.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 (.NET2.0, .NET3.0, .NET3.5), SQL-Server (SQL2000, SQL2005, SQL-CE, SQL2008), Visual-Studio (VS2005, VS2008), ADO.NET, Architect, Dev
|
6opuc |
4.11 |
|
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, .NET1.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.NET2.0, Win2K, WinXP, Win2003, MFC, VS2005, Dev
|
benoyraj |
3.83 |
|
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.82 |
|
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, .NET2.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 |
|
ATL COM and ADO
Updated: 3 Apr 2001
An ATL Component that uses ADO for data.
VB6, VC6, 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, .NET1.0, .NET1.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#.NET2.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, .NET2.0SQL2000, SQL2005, 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.NET1.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 (.NET2.0, .NET3.0, .NET3.5), SQL-Server (SQL2000, SQL2005), 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.NET1.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.NET1.1, Win2K, WinXP, Win2003, ADO.NET, SQL2000, 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, .NET1.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, .NET2.0VS2005, Dev
|
The Burger |
3.18 |
|
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.NET2.0, Win2K, WinXP, Win2003, Vista, .NET3.0, WebForms, SQL2000, SQL2005, 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.
VB6, VB (VB7.x, VB8.0, VB9.0), 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, .NET1.0, .NET1.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 |
|
|
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 |
|
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.88 |
|
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, .NET2.0, Visual-Studio, SQL2000, SQL2005, 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, .NET1.0, .NET1.1VS.NET2003, Dev
|
Simon Wilson |
4.71 |
|
DevShot - Database Snapshots for Developers
Updated: 25 Nov 2005
How to create runtime backups from SQL Server 2005 and restore them.
VB, SQL, Windows, .NET2.0SQL2005, 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, .NET1.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, SQL2005, 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.NET1.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.NET1.0, .NET1.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.NET1.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, .NET1.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, .NET2.0SQL2005, VS2005, DBA, Dev
|
Danilo Corallo |
4.55 |
|
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, SQL2000, 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, .NET1.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, .NET2.0SQL2000, 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.NET2.0, WinXP, Visual-Studio, SQL2000, SQL2005, 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.NET1.0, .NET1.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, .NET1.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.NET1.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, .NET2.0, Visual-Studio, SQL2005, DBA, Dev
|
Andrew Timberlake-Newell |
4.32 |
|
Optimizing building trees from a database
Updated: 20 Jan 2005
How a different way of looking at a problem can result in better performance.
C#, Windows, .NET1.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, .NET2.0, ADO, ADO.NET, SQL2000, SQL2005, VS2005, DBA, Dev
|
salysle |
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, .NET1.0, .NET1.1VS.NET2003, Dev
|
A.Z. Rosenberg |
4.21 |
|
Reading and Writing BLOB Data to MS SQL or Oracle Database
- Unedited
Updated: 22 Dec 2009
In this article, i will examine how to store and retrieve binary files such as image or PDF into MS SQL or Oracle database.
C#, SQL, .NET, ADO.NET, Dev
|
Farooq Kaiser |
4.17 |
|
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, .NET1.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, .NET2.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#.NET1.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 |
|
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 |
3.88 |
|
Database Resetter
Updated: 5 Oct 2004
A little tool to make life while developing with databases a little easier.
VB, SQL, Windows, .NET1.1SQL2000, 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, SQL2005, 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.NET1.0, .NET1.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.NET1.0, .NET1.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, .NET1.1, .NET2.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, SQL2005, 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, .NET1.0, .NET1.1, ASP.NET, ADO.NET, SQL2000, 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#.NET1.0, .NET1.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.NET1.1, Win2K, WinXP, Win2003, ADO.NET, SQL2000, 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, .NET1.1VS.NET2003, Dev
|
Ted Bouskill |
3.30 |
|
.NET MySQL Connexion V 1.2
Updated: 17 Jul 2003
Class Library for MySQL request
VB.NET1.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, .NET1.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, .NET1.0, .NET1.1SQL2000, 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
VB8.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 |
|
|
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 |
|
SQL Server Recursive Fetch From Self Referencing Table
- Unedited
Updated: 19 Nov 2009
CREATE PROC GetChildNodes (@ID uniqueidentifier)ASBEGINWITH PermissionList (PermissionID, PermissionName, Level)AS(SELECT ap.PermissionID, ap.PermissionName, 0 AS LevelFROM Permission AS apWHERE PermissionID = @IDUNION ALLSELECT ap.PermissionID, ap.PermissionName, Level + 1FROM
SQL, Recursive
|
Anish M |
5.00 |
|
Get Column values as comma seperated string
- Unedited
Updated: 19 Jan 2010
Ever wondered that how to get a comma (pipe or whatever) seperated result for a column in a table.The following statement show a simple example you can take as a starting point.Select (Stuff((Select ', ' + FName From Accounts FOR XML PATH('')),1,2,''))
SQL
|
Manas Bhardwaj |
5.00 |
|
Working with durations in MSSQL server
- Unedited
Updated: 31 Jan 2010
In dealing with durations in MSSQL server, I have found the following three resources helpful: :thumbsup: If you need to report a duration in a certain granularity such as "Task runs for ## minutes ## seconds", then refer to this[^] post:/*CREATE TABLE Tasks( ID INT IDENTITY PRIMARY...
DATEDIFF, duration, MSSQL
|
Ilka Guigova |
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, .NET2.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, SQL2000, DBA, Dev
|
Lars-Inge Tønnessen |
4.83 |
|
Generic Solution Framework to Saving History of Records Using MSSQL Server 2005 Xml Column
Updated: 14 Mar 2007
An article about How to Save Old Versions of Records Using MSSQL Server 2005 Xml Column
C#, SQL, Windows, .NET, DBA, Dev
|
yincekara |
4.82 |
|
Implementing complex data binding in custom controls
Updated: 29 Aug 2006
An article on implementing complex data binding (DataSource and DataMember) on a custom control.
C#, Windows, .NET2.0, ADO.NET, VS2005, DBA, Dev
|
Sascha Knopf |
4.81 |
|
SQL Query Optimization FAQ Part 1 (The SQL Plan)
- Unedited
Updated: 2 Feb 2010
SQL Query Optimization FAQ Part 1 (The SQL Plan)
SQL, .NET (.NET1.0, .NET1.1, .NET2.0, .NET3.0, .NET3.5, .NET4.0), SQL-Server (SQL2000, SQL2005, SQL2008), Architect
|
Shivprasad koirala |
4.80 |
|
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, VB7.x, VB9.0, Windows, .NETCF, Mobile, .NET1.0, .NET1.1, .NET2.0, Mono, .NET3.0, ASP.NET, Visual-Studio, ADO.NET, WebForms, Architect, Dev
|
Marcos Meli |
4.80 |
|
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 |
|
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, .NET2.0, .NET3.0, ASP.NET, VS2005, Dev
|
Herbrandson |
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, SQL2000, SQL2005, 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.76 |
|
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.74 |
|
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, .NET1.0, .NET1.1VS.NET2003, Dev
|
Scott McMaster |
4.73 |
|
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 |
|
Accessing the Borland Database Engine (BDE) from Visual C++
Updated: 17 Nov 1999
SQL, VC6, Windows, SQL-Server, DBA, Dev
|
Robert Pittenger |
4.70 |
|
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 |
|
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, .NETCF, Mobile, .NET1.1, ASP.NET, SQL2000, 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 |
|
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, SQL2000, 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 (.NET2.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, .NET1.1, ADO.NET, SQL2000, 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, .NET1.1, ASP.NET, ADO.NET, VS.NET2003, DBA, Dev
|
Patrice Borne |
4.60 |
|
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 |
|
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 |
|
Strongly Typed DataSet Generator
Updated: 2 Dec 2009
Generate strongly typed datasets
C#, XML, SQL, .NET, SQL-Server, ADO.NET
|
Akram Mellice |
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, .NET1.1, .NET2.0SQL2000, SQL2005, 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, .NET2.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, .NET2.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, SQL2000, SQL2005, 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, .NET1.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, .NET2.0VS2005, DBA, Dev, QA
|
Troy Magennis |
4.56 |
|
Entity Framework Performance
Updated: 31 Oct 2009
A comparison of performance between ADO.NET and Entity Framework.
C#3.0, C#4.0.NET3.5, .NET4.0, SQL-Server (SQL2008), ADO.NET, Architect, DBA, Dev
|
Mark Nischalke |
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 (SQL2000, SQL2005, 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 (.NET1.1, .NET2.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, .NET1.0, .NET1.1, Visual-Studio, DBA, Dev
|
Gareth Edwards |
4.52 |
|
Databinding the SqlTypes
Updated: 1 May 2003
Databinding the SqlTypes using the PropertyDescriptor class and the ITypedList Interface
C#.NET1.0, .NET1.1, Win2K, WinXP, Win2003, Visual-Studio, DBA, Dev
|
Dan Glass |
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, SQL2000, SQL2005, SQL-CE, DBA, Dev, QA
|
Gael Fraiteur |
4.51 |
|
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, SQL2000, SQL2005, 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, SQL2000, 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 |
|
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, .NET1.0, .NET1.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 |
|
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.NET1.1, WinXPSQL2000, VS.NET2003, DBA, Dev
|
Kim Sheffield |
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, .NET2.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 |
|
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, SQL2000, VS.NET2003, DBA, Dev
|
Peter Weissbrod |
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, .NET2.0, LINQ, VS2005, DBA, Dev
|
Galin Iliev [Galcho] |
4.46 |
|
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, .NET2.0, SQL-Server, VS2005, Architect, DBA, Dev, QA
|
Sean Chambers |
4.45 |
|
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, .NET1.0, DBA, Dev
|
Frans Bouma |
4.44 |
|
Get Started with QT and Embedded FireBird
- Unedited
Updated: 14 Dec 2009
This article is the description of the first steps in setting QT, Visual Studio and FireBird.
C++, Windows, Visual-Studio (VS2005, VS2008), CEO, Architect, Dev
|
Sergey Timoschuk, Apriorit Inc |
4.44 |
|
Database Independent Access
Updated: 5 Jan 2005
Use different database providers without tying implementation to one.
C#, SQL, Windows, .NET1.0, .NET1.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 (JavaSE6), Dev
|
Alina Simion |
4.43 |
|
Using Common Table Expressions and Recursion in SQL Server 2008
- Unedited
Updated: 1 Jan 2010
By using recursion (and CROSS JOINS) you can generate data without looping or hard-coding INSERT statements into a temporary table.In the example below, you can use recursion to generate a week of scheduling data. -- Count variable, set to 7 for a week's worth of data.DECLARE @seed...
SQL2008
|
gkushner |
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.NET1.1, Win2K, WinXPSQL2000, VS.NET2003, DBA, Dev
|
Mukund Pujari |
4.42 |
|
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
Updated: 17 Nov 2007
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
C++, SQL, Windows, Visual-Studio, SQL2005, 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#.NET1.0, .NET1.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, .NET2.0, ADO.NET, SQL2005, 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, SQL2000, SQL2005, 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, .NET1.1, .NET2.0, .NET3.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 (SQL2000, SQL2005, SQL-CE, SQL2008), 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 |
|
An XML Database Schema And Data Editor
Updated: 29 Sep 2002
View and edit your XML database schema and data
C#.NET1.0, Win2K, WinXP, DBA, Dev
|
Marc Clifton |
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 |
|
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, .NET2.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#.NET1.0, .NET1.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, .NETCF, .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 |
|
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.NET1.1, .NET2.0, Win2K, WinXP, Win2003, .NET3.0, .NET3.5, ADO.NET, WinForms, VS2005, DBA, Dev
|
Mihadh |
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, .NET1.0, .NET1.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, SQL2000, 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, .NET2.0, WinForms, SQL2005, VS2005, DBA, Dev
|
Patrickquinn1212 |
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, .NET2.0VS2005, Architect, DBA, Dev
|
Tetyana Loskutova |
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, SQL2000, 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, .NET1.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, .NET1.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, SQL2000, DBA, Dev
|
Evoluteur |
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, .NET2.0, ASP.NET, IIS, Visual-Studio, ADO.NET, SQL2000, SQL2005, 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, .NET1.1, ASP.NET, VS.NET2003, Dev
|
Ashley van Gerven |
4.31 |
|
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, .NET2.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 |
|
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, SQL2000, SQL2005, DBA, Dev
|
John P Harris |
4.28 |
|
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 |
|
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.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: 4 Feb 2010
Microsoft Enterprise Library Data Access Block [DAAB] on Oracle Provider [ODP.NET]
C#2.0, Windows, .NET2.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, SQL2000, 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 (.NET1.0, .NET1.1, .NET2.0, Mono, DotGNU, .NET3.0, .NET3.5), SQL-Server (SQL2000, SQL2005, 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, SQL2005, DBA, Dev
|
r.stropek |
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, SQL2000, SQL2005, 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, .NET2.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, SQL2000, 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, .NET1.1, ADO.NET, SQL2000, 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, .NET2.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 (SQL2000, SQL2005, SQL-CE, SQL2008), 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, .NET2.0, Visual-Studio, SQL2005, DBA, Dev
|
jamesplewis |
4.14 |
|
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.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
Updated: 3 Aug 2007
I invite anyone who doesn't know about Microsoft Access MDB files safety (specially compact and repair) to read this, before it's too late!
C++ (VC6, VC7, VC7.1, VC8.0), SQL, Windows (Win2K, 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.
VB6, C#, SQL.NET1.1, Win2K, WinXPSQL2000, VS.NET2003, DBA, Dev
|
Mukund Pujari |
4.11 |
|
SQL Server Objects in SourceSafe using SMO and Visual SourceSafe Automation
Updated: 3 Apr 2006
Useful tool to script database objects using SMO and check in Visual Source Safe
C#, Windows, .NET, Visual-Studio, DBA, Dev
|
Levent Soyalp |
4.10 |
|
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, .NET1.1, ADO.NET, SQL2000, VS.NET2003, DBA, Dev
|
netbard |
4.10 |
|
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.NET2.0, Vista, .NET3.0SQL2005, 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 |
|
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#, .NETCF, .NET1.1, Win2K, WinXPVS.NET2003, Dev
|
MRSumra |
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, SQL2000, SQL2005, 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, .NET2.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.NET1.0, .NET1.1, .NET2.0, WinXP, ASP.NET, ADO.NET, SQL2000, 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, .NET1.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, .NET1.1, ADO.NET, VS.NET2003, DBA, Dev
|
WillemM |
4.00 |
|
TOP WITH TIES clause in SELECT queries
- Unedited
Updated: 24 Nov 2009
The SELECT TOP N query always returns exactly N records, and randomly drops any record that have the same value as the last record in the group.SELECT TOP 5 price, Booktitle FROM BookTitles ORDER BY price DESCThis query will give 5 records from table BookTitles in descending order by price. ProblemS
SQL2005
|
Virendra Dugar |
4.00 |
|
An Algorithm For Grouping Data on One or More Fields Using a DataReader In .NET
- Unedited
Updated: 7 Jan 2010
Introduction...
VB, database
|
jfernand |
4.00 |
|
MSSQL doesn’t (completely) support IEEE754 floating points (NaNs and infinity)
- Unedited
Updated: 4 Jan 2010
After looking for quite a while (it is unbelievable, no?) I have to accept that Microsoft’s SQL Server 2000, 2005 and 2008 do not fully support IEEE-754 floating point numbers. Specifically NaN (Not-a-Number) and +/- Infinity are not allowed. While the 2000 Server seemingly allows such values to...
SQL
|
DavidSchmitt |
4.00 |
|
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.96 |
|
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, .NET1.0, .NET1.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, SQL2000, IIS5.1, DBA, Dev
|
Todd Denlinger |
3.96 |
|
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
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
Updated: 8 Oct 2007
Presenting a lightweight method to cut out most of the repetitive work of creating data classes.
SQL, C#2.0, Windows, .NET2.0, ASP.NET, Visual-Studio, WebForms, SQL2000, SQL2005, Architect, DBA, Dev
|
Nick Higgs |
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#.NET1.1, Win2K, WinXPSQL2000, VS.NET2003, DBA, Dev
|
Mukund Pujari |
3.93 |
|
MyByteFX.DataHelper
Updated: 30 Mar 2004
A simple Data Link Property Dialog that can create connection strings used in ByteFX.MySqlClient provider.
C#.NET1.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, .NET1.1VS.NET2003, DBA, Dev
|
Creepy Gnome |
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 Microsoft Access within a C# Project
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 Microsoft Access built-in import functionality.
C# (C#1.0, C#2.0), Windows (Win2K, WinXP, Win2003, Vista), .NET (.NET1.0, .NET1.1, .NET2.0), SQL-Server (SQL2005), Visual-Studio (VS.NET2003, VS2005), COM, ADO.NET, DBA, Dev
|
Muaddubby |
3.90 |
|
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, .NET1.1, SQL-Server, VS.NET2003, DBA, Dev
|
Stephan Meyn |
3.88 |
|
Generating Database Tables using Attributes
Updated: 14 Feb 2004
Generate database schema information from C# classes.
C#.NET1.0, .NET1.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.NET1.1, Win2K, WinXP, Win2003SQL2000, VS.NET2003, DBA, Dev
|
poodull76 |
3.87 |
|
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, .NET1.0, DBA, Dev
|
Anthony Roach |
3.86 |
|
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, .NETCF, .NET1.0, .NET1.1, .NET2.0, ADO.NET, SQL2000, SQL2005, VS.NET2003, VS2005, SQL-CE, DBA, Dev
|
Chad Z. Hower aka Kudzu |
3.86 |
|
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 (.NET3.5), Visual-Studio, LINQ, Architect, Dev
|
Buu Nguyen |
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.NET2.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.NET1.1, Win2K, WinXPSQL2000, 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.NET1.1, WinXP, ASP.NET, SQL2000, VS.NET2003, DBA, Dev
|
Boo! |
3.83 |
|
Processing with C#, Oracle Transactions and Oracle Exceptions
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, Windows (Win2K, WinXP, Win2003, Vista), .NET (.NET1.0, .NET1.1, .NET2.0, .NET3.0), ASP.NET, SQL-Server, Visual-Studio (VS.NET2003, VS2005), WebForms, DBA, Dev
|
Dimitar Madjarov |
3.83 |
|
Multi User Contact Management System using Three Tier Architecture
Updated: 1 Mar 2007
A Simple Multi User Contact Management System that will help programmers to use some tricks
C#2.0.NET2.0, WinXP, WinForms, VS2005, DBA, Dev
|
Zakaria Bin Abdur Rouf |
3.83 |
|
Database build tool
Updated: 17 Sep 2004
An extensible tool to package and deploy database schema objects.
C++, VB, SQL, Windows, .NET1.0, .NET1.1, ADO.NET, SQL2000, VS.NET2003, Architect, DBA, Dev
|
Duncan Edwards Jones |
3.80 |
|
C#: Avoiding DTC with Typed DataSets and SQL Server 2000
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.NET3.0, .NET3.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, .NET1.0, .NET1.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#.NET1.0, .NET1.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, .NET2.0, ADO.NET, SQL2005, 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, .NET1.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#.NET1.0, Win2K, WinXP, DBA, Dev
|
Martin Cook |
3.78 |
|
Building Dynamic SQL In a Stored Procedure
Updated: 9 Oct 2007
This article explains about building and executing a Dynamic SQL in a stored procedure.
SQL, Windows, Visual-Studio, SQL2000, 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, .NET1.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, .NET1.1, ADO.NET, VS.NET2003, DBA, Dev
|
Vinod Giri T |
3.76 |
|
How to Truncate Log File in SQL Server 2005
Updated: 9 Jun 2006
How to truncate log file in SQL Server 2005
C#, SQL, Windows (WinXP, Win2003), .NET, SQL-Server (SQL2005), Visual-Studio, ADO.NET, Architect, DBA, Dev
|
hong_wei_li@yahoo.com |
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, .NET1.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, .NET1.1VS.NET2003, Dev
|
Hayder Marzouk |
3.75 |
|
Compact and Repair an Access Database Programmatically Using C#
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, .NET2.0, ASP.NET, COM, ADO, WebForms, VS2005, DBA, Dev
|
Jeremy T. Fuller |
3.75 |
|
DataTable with SelectDistinct in C#
Updated: 11 Oct 2007
Allows you to perform a Distinct query against a Datatable
C# (C#2.0), Windows, .NET (.NET2.0), SQL-Server (SQL2000, SQL2005), Visual-Studio (VS2005), ADO.NET, 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.NET2.0, VistaSQL2005, 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, SQL2000, SQL2005, 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
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
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.NET2.0, Win2K, WinXP, Win2003SQL2000, SQL2005, VS2005, DBA, Dev
|
Ali Ozgur |
3.71 |
|
Advanced SQL 2005 SQLNotificationRequest Functionality with C#
Updated: 24 Mar 2007
Using the SQLNotificationRequest object and the Service Broker to get row and column change notifications, mimicking supposed SQLDependency capabilities
C# (C#2.0), Windows (Win2003), .NET, Visual-Studio, SQL2005, DBA, Dev
|
Todd Wilder |
3.70 |
|
Read Text File (txt, csv, log, tab, fixed length)
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.
VB6, C#, VB, .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 |
|
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
Updated: 15 Jan 2007
How to copy data from a modified dataset into a SQL Server Database
C#2.0, Windows, .NET2.0, SQL-Server, ADO.NET, VS2005, DBA, Dev
|
Aaron VanWieren |
3.65 |
|
GridView Order Page Shopping Cart Page ASP.NET SQL
Updated: 23 Feb 2007
GridView Image order page shopping cart page
C# (C#2.0), Windows, .NET (.NET2.0), Visual-Studio (VS2005), SQL2005, DBA, Dev
|
T.Ashraf |
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.NET1.1, Win2K, WinXP, Win2003, VistaSQL2000, 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 |
|
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, .NET1.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, .NET1.0, Dev
|
Petervu |
3.60 |
|
Data Archive
Updated: 30 Jun 2004
This article describes creating indexed search systems using relational databases
C#, SQL, Windows, .NET1.0, .NET1.1SQL2000, VS.NET2003, DBA, Dev
|
Nikolai Serdiuk |
3.60 |
|
Creating a Date Process Library and WCF Service for Date and Age Processing
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.
C# (C#2.0), SQL, Windows (WinXP, Win2003, Vista), .NET (.NET2.0, .NET3.0), SQL-Server (SQL2005), Visual-Studio (VS2005), ADO.NET, WCF, 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, .NET1.0, DBA, Dev
|
Anthony Roach |
3.58 |
|
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
Updated: 6 Sep 2007
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
C++, SQL, Windows, SQL-Server (SQL2000, SQL2005), 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#.NET1.0, .NET1.1, Win2K, WinXPVS.NET2003, DBA, Dev
|
Bas Goedemans |
3.56 |
|
DataRow Indexing Performance (Integer vs. String)
Updated: 5 Feb 2007
Integer and string indexing of System.Data.DataRow columns - head to head
C#2.0, Windows, .NET2.0, Visual-Studio, ADO.NET, DBA, Dev
|
Juraj Borza |
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 |
|
DBF2DataSet
Updated: 24 Aug 2007
An article for converting DBF files to dataset XML files
C#2.0, Windows, .NET3.0, Visual-Studio, DBA, Dev
|
canozurdo |
3.55 |
|
How to Send SMS Messages from C# using an SQL Database
Updated: 16 Aug 2007
Send SMS messages from C# using an SQL database server and an SMS Gateway
C# (C#2.0), SQL, Windows, .NET, ASP.NET, SQL-Server (SQL2000, SQL2005, SQL-CE), Visual-Studio (VS.NET2003, VS2005), ADO.NET, WebForms, IE6.0, IE7, 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, .NET1.0, .NET1.1, ADO.NET, VS.NET2003, DBA, Dev
|
Miloslav Beno |
3.50 |
|
A Better Loader for ORM Frameworks
Updated: 10 Feb 2006
Generate loader classes for faster operation using Reflection.Emit
C#, MSIL, Windows, .NET2.0VS2005, DBA, Dev
|
Chris Stefano |
3.50 |
|
APPLY Operator of SQL Server 2005
Updated: 3 May 2007
APPLY operator is a new feature in SQL Server 2005 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++, SQLWin2KSQL2005, 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, SQL2000, SQL2005, SQL-CE, SQL2008, 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#.NET1.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
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, .NET2.0SQL2005, VS.NET2003, Architect, DBA, Dev, Design
|
Paul Reynolds |
3.45 |
|
INSERT\UPDATE Query Generator Based on Table Values
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
Updated: 23 Apr 2006
Calculates Annualized Sharpe Ratio and Sortino Ratio for a Portfolio Trading History in SQL
SQL, Windows, .NET, Visual-Studio, DBA, Dev
|
AndrewPeters |
3.42 |
|
SMO - Manage your SQL Server!
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.41 |
|
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, .NET1.0, .NET1.1, Visual-Studio, DBA, Dev
|
Stephan Johnson |
3.40 |
|
Sql Group by
- Unedited
Updated: 8 Feb 2010
How to use Group By clause when joining to table Let's consider one senario where i have two table employee(contains employee detail) and sales(contains infomation about sales done by employee).Structure of Employee...
C, ASP.NET, SQL-Server, ADO.NET, Architect, DBA
|
Pranay Rana |
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.NET1.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.NET1.0, .NET1.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, SQL2000, 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
.NET1.0, Win2K, WinXP, ASP, Dev
|
Megan Forbes
|
3.34 |
|
Binding a two dimensional array to a DataGrid
Updated: 1 Feb 2004
Binding a two dimensional array to a DataGrid
C#, Windows, .NET1.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.NET2.0, WinXP, Win2003SQL2005, 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, SQL2000, DBA, Dev
|
-Dr_X- |
3.31 |
|
Implementing Triggers in 4D
Updated: 10 Mar 2007
The target audience of the article are novice 4D developers. It aims at explaining the usage of Triggers in 4D databases.
SQL, Windows (WinXP), 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, .NET2.0, ASP.NET, WebForms, SQL2000, SQL2005, 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, .NET3.5, ASP.NET, ADO.NET, SQL2005, VS2008
|
bhadeliaimran |
3.27 |
|
Store and Retrieve Trees in SQL under C#
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, .NET2.0SQL2005, 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#.NET1.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, .NET2.0VS2005, DBA, Dev
|
Fiwel |
3.25 |
|
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 |
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, .NET1.0, .NET1.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#.NET1.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, .NET1.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, .NET2.0, Visual-Studio, SQL2005, 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.NET1.1, .NET2.0, Win2K, WinXP, Win2003VS.NET2003, VS2005, Architect, DBA, Dev
|
Mustafa Magdy |
3.17 |
|
Computed Column Specification in SQL Server
Updated: 18 Jul 2007
Computed Column Specification for populating nth column
SQL, WindowsSQL2000, SQL2005, Architect, DBA, Dev, Design
|
Padoor Shiras |
3.17 |
|
Creating SQL Server Login programmatically
- Unedited
Updated: 19 Nov 2009
IntroductionI 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 |
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, .NET1.1, ADO.NET, VS.NET2003, DBA, Dev
|
hestol |
3.13 |
|
SQL-DMO: Search and Regenerate Stored Procedures in Seconds
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, .NET1.1, .NET2.0SQL2000, SQL2005, 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.NET1.1, .NET2.0, Win2K, WinXP, Win2003, .NET3.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.NET2.0, WinXP, Visual-Studio, SQL2005, 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.
VB6, C#, SQL.NET1.1, Win2K, WinXP, Win2003SQL2000, VS.NET2003, CEO, Architect, DBA, Dev, QA
|
dshalimov |
3.09 |
|
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, VB7.x, VB8.0, VB9.0.NET1.0, .NET1.1, .NET2.0, Win2K, WinXP, Win2003, Vista, .NET3.0, SQL-Server, IIS5.1, IIS6, VS.NET2003, VS2005, IIS7, 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#.NET1.0, .NET1.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, .NET1.0, Visual-Studio, DBA, Dev
|
Ennis Ray Lynch, Jr. |
3.07 |
|
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, SQL2000, DBA, Dev
|
SquaredRomi |
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#.NET1.0, .NET1.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 |
|
XmlClient Managed Provider
Updated: 16 Apr 2002
A Class Library that holds a Managed Provider to retreive Load DataSets from Xml sources.
C#, Windows, .NET1.0, DBA, Dev
|
Shawn Wildermuth |
3.00 |
|
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, SQL2000, SQL2005, DBA, Dev, QA
|
Eugene Ochakovski |
3.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 |
3.00 |
|
Insert default value[s] in a table
- Unedited
Updated: 29 Dec 2009
I was facing the problem of inserting a default value on single column table and I have achieved via this way.insert into > default valuesAlso this could be used for many columns in a table defining with default constraints.ThanksMehul Thakkar
SQL2005
|
Mehul M Thakkar |
3.00 |
|
How To Select Record Based on Row Number
- Unedited
Updated: 20 Jan 2010
It is a common issue of many of the guys on how we can fetch a record based on its record number. It is really easy to get first 10 records usingSELECT TOP 10 * FROM EMPBut when we want to fetch records in such a way say I need to fetch record from 40 to 50. This comes very handy when...
SQLSQL2005
|
Abhishek Sur |
3.00 |
|
DLinq Quick Start
- Unedited
Updated: 4 Oct 2007
Start using DLinq in easy steps
C#3.0, Windows, .NET2.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, WinMobile, .NETCF, Mobile, .NET1.0, .NET1.1, .NET2.0, ADO.NET, SQL2000, 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, SQL2000, SQL2005, 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, .NET1.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, .NET1.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.NET1.1, Win2K, WinXP, Win2003, ADO.NET, SQL2000, VS.NET2003, Architect, DBA, Dev
|
Thomas Lykke Petersen |
2.94 |
|
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.NET1.1, WinXP, ASP.NET, Visual-Studio, WebForms, Dev
|
DEEPCHAND KOSTA |
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, SQL2005, 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, SQL2000, 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 |
|
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.89 |
|
C# Data Class
Updated: 27 Jan 2002
A generalised method for calling parameterized stored procedures
C#.NET1.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, .NETCF, Mobile, .NET2.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, .NET2.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, .NET1.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, .NET2.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 |
|
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, .NET1.1, .NET2.0, .NET3.0, ASP.NET, ADO.NET, WebForms, SQL2005, 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 |
|
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 (.NET2.0, .NET3.0, .NET3.5), ASP.NET, SQL-Server (SQL2000, SQL2005), IIS (IIS5.1, IIS6), COM+, ADO.NET, Dev
|
Deepak.M |
2.68 |
|
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.NET1.0, .NET1.1, WinXP, ADO.NET, SQL2000, 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, SQL2000, 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.NET1.1, .NET2.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 |
|
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 |
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#.NET1.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, VB8.0, .NET, WinXP, Visual-Studio, SQL2000, DBA, Dev
|
Srf_World |
2.56 |
|
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.55 |
|
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, SQL2000, 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.NET1.1, Win2K, WinXP, Win2003, Vista, ADO.NET, SQL2000, 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, SQL2000, SQL2005, 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.NET1.0, .NET1.1, Win2K, WinXP, Win2003, ASP.NET, VS.NET2003, DBA, Dev
|
Tamer Ahmed Farrag |
2.52 |
|
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.51 |
|
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, SQL2000, 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, .NET2.0SQL2005, 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, .NET2.0SQL2005, 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, .NET2.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, .NETSQL2000, VS.NET2003, DBA, Dev
|
Mark Williamson |
2.48 |
|
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, .NET1.1, .NET2.0, SQL-Server, ADO.NET, VS.NET2003, VS2005, Architect, DBA, Dev
|
Asif Sayed |
2.47 |
|
Dynamic connection string
Updated: 9 Aug 2004
Creating dynamic connection string on a remote site.
VBScriptWin2K, WinXP, Win2003, ASP, Visual-Studio, IIS5.1, IIS6, 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, .NET2.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 |
|
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, SQL2005, DBA, Dev
|
Himanshu Kumar Sinha |
2.39 |
|
Grove [.NET Develop Component Kit]
- Unedited
Updated: 19 Nov 2003
for database project developer
C#.NET1.0, .NET1.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 (.NET2.0), Visual-Studio (VS2005), Architect, Dev
|
jimbobmcgee |
2.36 |
|
SQL And CSharp
- Unedited
Updated: 13 Jan 2010
generate 100,1000 lines of bakend code and stored procedures by just one click on table name in sql server
C#1.0, Windows, .NET1.1VS.NET2003, DBA, Dev
|
urd_sheir |
2.35 |
|
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, VB7.x, VB8.0, VB9.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, SQL2000, 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, .NET1.0, .NET1.1, .NET2.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, SQL2000, SQL2005, 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, SQL2000, 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, .NET2.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, SQL2000, 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, .NET2.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.NET2.0, WinXPSQL2005, 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 |
|
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, .NETCF, Mobile, .NET1.0, .NET1.1, .NET2.0, Win2K, WinXP, Win2003, Vista, TabletPC, Embedded, ASP, ASP.NET, VS.NET2003, Architect, DBA, Dev
|
Sandip Dalvi Tung |
2.15 |
|
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 |
|
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, SQL2000, Architect, DBA, Dev
|
Syed Asif Iqbal |
2.13 |
|
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, SQL2000, 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, .NET2.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 |
|
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, SQL2005, Architect, DBA, Dev
|
pinaldave |
2.07 |
|
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 |
|
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 |
|
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.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, .NET2.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 (.NET1.0, .NET1.1, .NET2.0, .NET3.0), ASP, ASP.NET, LINQ, Architect, DBA, Dev, Design
|
Prasad Bhalekar(PP) |
2.00 |
|
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 |
|
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.96 |
|
Ilumnis Authentication Module
- Unedited
Updated: 27 Oct 2005
C# MS SQL user / role / right manipulation
C#, Windows, .NET1.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
VB6, XML, SQL, C#1.0.NET1.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.NET2.0, Win2K, WinXP, Win2003, Vista, .NET3.0, .NET3.5, ADO.NET, SQL2000, SQL2005, 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, SQL2000, 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, SQL2000, SQL2005, 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, SQL2000, SQL2005, 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
VB6, C#, VC6, VC7, VC7.1, .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#.NET1.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 |
|
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 (.NET1.0, .NET1.1, .NET2.0, Mono, DotGNU, .NET3.0, .NET3.5), ADO.NET, LINQ
|
Islam ElDemery |
1.79 |
|
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, SQL2000, 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.NET1.1, Win2K, WinXPSQL2000, 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, SQL2000, SQL2005, 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, .NET2.0, .NET3.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, .NET2.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, SQL2005, 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, SQL2000, 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, SQL2000, SQL2005, 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.NET1.1, WinXP, ADO.NET, SQL2000, VS.NET2003, DBA, Dev
|
b_hardman |
1.63 |
|
Using TableAdapters with transactions
- Unedited
Updated: 18 Feb 2007
Use TableAdapters with transactions
C#2.0.NET2.0, WinXP, ADO.NET, SQL2000, VS2005, DBA, Dev
|
Danko Greiner |
1.63 |
|
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, .NET2.0SQL2005, 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, SQL2000, 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, SQL2000, 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 Pro*C
- 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.NET1.1, WinXPSQL2000, 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, eVC4.0, WinMobile, .NET, Mobile, Win2K, Win2003, Visual-Studio, COM, SQL2000, SQL2005, 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, WinXPSQL2000, 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, .NET2.0SQL2005, 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, SQL2000, 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#, WinMobile, .NET1.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, .NET2.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, SQL2000, 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, .NET1.1, .NET2.0, ASP.NET, WebForms, Ajax, SQL2000, 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#, .NETCF, Mobile, .NET2.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, SQL2000, 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.NET1.0, .NET1.1, .NET2.0, Win2K, WinXP, Win2003, Vista, TabletPC, .NET3.0, .NET3.5SQL2000, SQL2005, DBA, Dev
|
vini2k1 |
1.00 |
|
Export data from SQL Server to MS Access
- Unedited
Updated: 19 Nov 2009
IntroductionExporting 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
SQL2000
|
Muhammad Shahid Farooq |
1.00 |
|
How to change ConnectionString easily
- Unedited
Updated: 6 Feb 2010
Changing ConnectionString like an attribute in C#
C# (C#1.0, C#2.0, C#3.0), .NET (.NET1.1, .NET2.0, .NET3.0, .NET3.5), SQL-Server (SQL2005, SQL2008), Visual-Studio (VS2005, VS2008), ADO.NET, Dev, Design, SysAdmin
|
Ali Marzban |
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, .NETCF, Mobile, .NET2.0, SQL-Server, VS2005, DBA, Dev
|
Liam Cavanagh |
|
|
SQLServer2000 Deadlock Analaysis
- Unedited
Updated: 15 Oct 2007
SQLServer2000 deadlock analysis.
C++, SQLWinXP, Win2003, Visual-Studio, SQL2000, 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 (SQL2000, SQL2005, SQL-CE, SQL2008), 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 |
|
|
How to Shrink SQL Server database log files?
- Unedited
Updated: 8 Feb 2010
How to Shrink SQL Server database log files?Database Logs should be truncated when ever you perform a full backup of the database. You can also manually truncate them as following. Code:DECLARE @strDatabaseName nvarchar(255)SET @strDatabaseName = 'YourDatabaseName' BACKUP LOG...
SQL2005
|
thatraja |
|
|
Programitically retrieve the trigger definition
- Unedited
Updated: 19 Jan 2010
I ran into this strange situation where I wanted to get Trigger Definition(the SQL content) of a specific trigger from a database. The following SQL query can used to retrieve the trigger definition programitically.SELECT DB_NAME() AS DataBaseName, dbo.SysObjects.Name AS...
SQL
|
Manas Bhardwaj |
|
|
|
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
Updated: 26 Jun 2008
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
C#, SQL, Windows, SQL-Server (SQL2000, SQL2005, 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 (.NET1.0, .NET1.1, .NET2.0, Mono, DotGNU, .NET3.0, .NET3.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 (.NET2.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, .NET1.1, .NET2.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), WinMobile, Win32, SQL-Server (SQL2000, SQL2005, SQL-CE, SQL2008), Visual-Studio, MySQL, Architect, DBA, Dev
|
Ladislav Nevery |
4.02 |
|
MySQL: Backup, compress, and FTP from WinForms
Updated: 27 Mar 2009
Backup an entire MySQL database, compress it, and send it with FTP to an FTP server.
C#, .NET, Visual-Studio (VS2008), DBA
|
Kunjal999 |
4.00 |
|
Lean and extensible mySQL C++ wrapper
Updated: 26 Feb 2007
An article on a lean (2 header files) C++ template class that provides mySQL query
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 (.NET2.0, .NET3.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.00 |
|
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 (.NET2.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 |
|
|
|
top |
| Title /
Updated |
Author |
Score |
|
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 |
|
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.71 |
|
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, SQL2000, VS.NET2003, DBA, Dev
|
Dave Handley |
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 |
|
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.58 |
|
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 |
|
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.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, SQL2000, 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 |
|
|
|
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.89 |
|
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, SQL2000, 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 (SQL2000, SQL2005), 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 |
|
|
|
top |
| Title /
Updated |
Author |
Score |
|
Sql180 Developer
Updated: 25 Oct 2008
A Graphic tool for Oracle developers and DBAs
C#, SQL.NET2.0, WinXP, Win2003, Vista, .NET3.0, .NET3.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, .NET2.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
|
