|
top |
| Title /
Updated |
Author |
Score |
|
A set of ADOX Classes
Updated: 19 Jun 2002
Simple database catalog access using a set of ADOX classes
SQL, VC6, VC7Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev
|
Carlos Antollini |
4.84 |
|
ADO Connection Strings
Updated: 23 Jul 2002
A list of ODBC DSN Connection Strings.
SQL, VC6, VC7.NET 1.0, Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev
|
Carlos Antollini |
4.83 |
|
A set of ADO classes - version 2.20
Updated: 6 Sep 2005
Simple database access using an ADO class.
SQL, VC6Win2K, SQL Server, MFC, ADO, DBA, Dev
|
Carlos Antollini |
4.81 |
|
dbAx: a C++ Library for ActiveX Data Objects (ADO)
Updated: 21 Jan 2009
C++ class wrapper for ADO
C++, Windows, Win32, COM, ADO, DBA
|
Ross White |
4.76 |
|
Loading image files from a database, using ADO
Updated: 27 Jan 2006
Putting and retrieving images files to and from a database, via ADO.
SQL, VC7.1Win2K, WinXP, Visual Studio, SQL 2000, SQL 2005, DBA, Dev
|
Bahrudin Hrnjica |
4.67 |
|
Interactive SQL Tool (using ADO)
Updated: 17 Jan 2000
A tool that allows you to query OLE DB sources
SQL, VC6, SQL Server, DBA, Dev
|
George Poulose |
4.57 |
|
ADO at a glance
Updated: 10 Jun 2001
A simple introduction to using ADO
SQL, VC6Win2K, SQL Server, MFC, DBA, Dev
|
M. Shokuie Nia |
4.42 |
|
ADO Data Bound Class Wizard
Updated: 27 Sep 2000
ADO Data Bound Class Wizard
SQL, VC6, SQL Server, MFC, ATL, DBA, Dev
|
Ly Nguyen |
4.41 |
|
Using MS DataGrid control with ADO
Updated: 2 Sep 2001
Use the MS DataGrid control in your C++ app with ADO
SQL, VC6Win2K, SQL Server, MFC, DBA, Dev
|
Rashid Thadha |
4.34 |
|
Another Simple ADO Class
Updated: 13 Mar 2001
Another simple yet cool ADO class for your project - from zCoders.com!
SQL, VC6Win2K, SQL Server, Visual Studio, DBA, Dev
|
Christopher W. Backen |
4.10 |
|
Efficient data processing with ADO in C++: Method GetRows
Updated: 6 Jul 2005
Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.
SQL, VC6, VC7, VC7.1, VC8.0Win2K, WinXP, Win2003, Vista, TabletPC, COM, ADO, SQL 2000, SQL 2005, VS.NET2003, VS2005, SQL CE, DBA, Dev
|
Vitaly Tomilov |
3.96 |
|
ADO : 101-level tutorial
Updated: 2 May 2004
101-level tutorial on ActiveX Data Objects
SQL, VC6, VC7, VC7.1, Windows, SQL Server, VS.NET2003, DBA, Dev
|
Kevin Wittmer |
3.93 |
|
Two ADO Wrapper Classes
Updated: 4 Apr 2001
Make ADO operations easier with 2 simple classes
SQL, VC6Win2K, SQL Server, MFC, DBA, Dev
|
Dogu Tumerdem |
3.69 |
|
ADO MFC Wrapper classes
Updated: 11 Aug 2002
ADO classes that closely resemble CDatabase and CRecordset.
SQL, VC6, VC7, SQL Server, MFC, DBA, Dev
|
Tim Kohler |
3.69 |
|
Generic Database Class Using ADO to execute Stored Procedures
Updated: 3 May 2001
Use this class to separate all database calls hidden to the callers. Nobody has to take care of how database retrieval is going on!
SQL, VC6, VB 6Win2K, SQL Server, ATL, DBA, Dev
|
Amir Samdani |
3.63 |
|
Use XSLT to convert ADO Recordsets into delimited files
Updated: 29 Oct 2001
Transform any XML persisted ADO Recordset into a delimited text file.
C++, XML, SQL, Windows, SQL Server, Visual Studio, ADO, DBA, Dev
|
simulant |
3.60 |
|
How to return Disconnected ADO Recordset from COM
Updated: 18 Mar 2002
An article on how to return disconnected ADO Recordset from COM using VC.
SQL, VC6Win2K, WinXP, SQL Server, Visual Studio, MFC, ATL, DBA, Dev
|
Siau Tan Long |
3.33 |
|
WrapSP - A Wrapper Class Generator for SQL Stored Procedures
Updated: 8 Aug 2009
A simple to use tool that generates ADO based classes for calling SQL Stored Procedures. Only a few clicks, and you can access any Stored Procedure in your database.
C++, SQLWin2K, WinXP, MFC, ADO, Dev
|
_Reinhard |
3.29 |
|
Create Table with AutoNumber Indexed Field
Updated: 6 May 2009
Create a new Table and re-create Table to set existent Field as Primary Key
VB (VB 6), Windows (WinXP, Vista), ADO
|
Mostafa Kaisoun |
3.00 |
|
Breaking data on comma
- Unedited
Updated: 22 Feb 2008
to break data on comma delimiter
SQL, SQL Server (SQL 2000, SQL 2005, SQL CE), DBA
|
shekharshashi |
1.00 |
|
|
top |
| Title /
Updated |
Author |
Score |
|
Performance and the Entity Framework
Updated: 12 Aug 2009
An article describing the best practices for Entity Framework performance
C#, .NET (.NET 3.5), ADO.NET, Architect, Dev
|
Perry Marchant |
4.88 |
|
Edit Almost Anything in a DataGrid
Updated: 27 Feb 2005
Allow your DataGrid to edit pictures and a whole range of other data types.
C#, VB, Windows, .NET 1.1, ADO.NET, WinForms, VS.NET2003, Dev
|
Declan Brennan |
4.72 |
|
How to Manually Create a Typed DataTable
Updated: 28 Oct 2008
When you override GetRowType, you also need to override NewRowFromBuilder().
C#, Windows, ADO.NET, Dev
|
Marc Clifton |
4.72 |
|
Implementing Audit Trail using Entity Framework - Part 1
Updated: 27 Mar 2009
Implementing Audit Trail using Entity Framework's caching entries
C#, .NET (.NET 3.5), SQL Server (SQL 2005), ADO.NET, Dev, Design
|
Morshed Anwar |
4.71 |
|
Declarative Transactions using ADO.NET and without Enterprise Services.
Updated: 26 Oct 2001
Sometimes it is nice to prototype up a simple database application. This code may help, by providing the automatic transactional model of COM+ in a non-COM+ environment. This example uses "Interception" to provide automatic transactioning support for non-COM+ classes.
C#, Windows, .NET 1.0, ADO.NET, Dev
|
Sandy Place |
4.70 |
|
Introduction to the Entity Framework
Updated: 12 Feb 2009
Looking at the EF and database association patterns.
C#.NET 3.5, ADO.NET, Architect, DBA, Dev, Design
|
Marc Clifton |
4.69 |
|
Programmatically using ADO.NET and XML
Updated: 15 Sep 2004
With ADO.NET, a database can be regarded as a virtual XML document. XPath query and XSLT transformation are naturally available.
C#, Windows, .NET 1.0, .NET 1.1, ADO.NET, VS.NET2003, DBA, Dev
|
Xinjie ZHANG |
4.68 |
|
DataGrid Copy Helper Component
Updated: 28 Jul 2005
A component providing Copy functionality to a Windows Forms DataGrid. Copied data can then be pasted in Excel or a text editor.
VB, Windows, .NET 1.1, WinForms, VS.NET2003, Dev
|
patgrape |
4.68 |
|
Use SQL Parameters to Overcome Ad Hoc Performance Issues
Updated: 12 Jan 2007
Defining (rather loosely) ad hoc queries as SQL commands built as strings by an SQL client application and submitted to SQL Server.
C#, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev
|
Mark J. Miller |
4.67 |
|
Light ORM Library for .NET
Updated: 25 Dec 2008
This article is about the Light Object-Relational Mapping library.
C#, Windows, .NET, SQL Server, Visual Studio, ADO.NET, DBA, Dev
|
Sergey Busel |
4.64 |
|
Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005
Updated: 29 Dec 2006
This article shows how to use CLR integration to compress data in SQL Server 2005
C#, Windows, .NET, Visual Studio, DBA, Dev
|
yolousa72 |
4.63 |
|
C# 2.0 Nullable Data Readers
Updated: 20 Jan 2006
An article on nullable data readers for .NET 2.0 nullable types.
C#, Windows, .NET 2.0, ADO.NET, VS2005, DBA, Dev
|
Steve Michelotti |
4.59 |
|
Component to access databases in the .NET environment
Updated: 31 May 2004
An extremely flexible and easy-to-use library that retrieves data in XML format, supports simple parameterized queries, stored procedures, and transactions. It can also be used as a web service.
C#, VB, VC7.NET 1.0, Win2K, WinXP, ASP.NET, Dev
|
Xiangyang Liu 刘向阳 |
4.59 |
|
Custom DataBindable BusinessObjects and The Typed DataSet
Updated: 3 Jan 2007
An article about Custom Businessobjects in conjunction with the DataSet to Retrieve Data
C#, Windows, .NET, Visual Studio, DBA, Dev
|
Emmanuel71 |
4.58 |
|
Using ADO.NET for beginners
Updated: 12 Sep 2005
ADO.NET for beginners.
C#, SQL.NET 1.1, WinXP, ADO.NET, VS.NET2003, DBA, Dev
|
Huseyin Altindag |
4.58 |
|
ADO.NET for the Object-Oriented Programmer – Part Two
Updated: 19 Jan 2006
In this second part of the article series, we will revisit the ADO.NET CRUD operations. Only this time, we will use an application with far better architecture. Once that is done, we will move on to data binding with objects.
C#, Windows, .NET, Visual Studio, ADO.NET, Dev
|
David Veeneman |
4.57 |
|
Object Mapping Part I - The Row Cursor
Updated: 17 Dec 2006
A row cursor implementation suitable for synchronizing and navigating a DataView against with object-mapped instance.
C#, Windows, .NET, Visual Studio, DBA, Dev
|
Marc Clifton, J. Dunlap |
4.53 |
|
Accesing CommandTimeout properties in a TableAdapter
Updated: 9 Feb 2006
Describes adding public properties to a TableAdapter to access the CommandTimeouts of the private DataAdapter.
C#, Windows, .NET 2.0, ADO.NET, VS2005, DBA, Dev
|
PIEBALDconsult |
4.53 |
|
Inserting relational data using DataSet and DataAdapter
Updated: 15 Mar 2003
This article describes the process of inserting data in a DataSet and then submitting this changes to the database. It targets the issue when having IDENTITY/AutoNumber columns in the database.
C#, VC7.NET 1.0, Win2K, WinXP, DBA, Dev
|
Mauricio Ritter |
4.52 |
|
DataSet Watch 2.0
Updated: 29 Dec 2006
An enhanced DataSet Visualizer for Visual Studio 2005.
C# 2.0, Windows, .NET 2.0VS2005, Dev
|
Osama Abbas |
4.52 |
|
Fill a DataSet from delimited text files
Updated: 18 Apr 2004
Explains how to fill a dataset with the information stored in a delimited text file
C#, Windows, .NET, Visual Studio, DBA, Dev
|
CoderForRent |
4.50 |
|
LogParser DataProvider for ADO.NET
Updated: 11 May 2007
The article shows how to use SQL features of Microsoft LogParser with ADO.NET
C# 2.0, VB 7.x, Windows, .NET 1.1, .NET 2.0, ASP.NET, SQL Server, IIS, VS.NET2003, CEO, DBA, Dev
|
FrankNight |
4.50 |
|
Using Oracle Stored Procedures in SqlDataSource Select Command
Updated: 5 Jan 2009
How to use Oracle (and other non Microsoft) SP in SqlDataSource Select command
C#, SQL, Windows, .NET (.NET 2.0), ASP.NET, ADO.NET, Dev
|
Petrovik Aleksandar |
4.50 |
|
ADO.NET Entity Framework as Data Access Layer
Updated: 30 Oct 2009
ADO.NET Entity Framework as Data Access Layer
C#, .NET (.NET 3.5), ADO.NET
|
sarvesh.upadhyay |
4.43 |
|
ADO.NET for the Object-Oriented Programmer – Part One
Updated: 19 Jan 2006
This article will show how to accomplish these goals—use ADO.NET as a thin data transport layer, while still taking advantage of the data-binding capabilities of .NET user interface controls. As it turns out, it’s pretty easy.
Windows, .NET, Visual Studio, Dev
|
David Veeneman |
4.37 |
|
DatabaseAccessor
Updated: 23 Aug 2007
A simple base class that encapsulates basic database access functionality
C#, Windows, .NET 2.0, Visual Studio, ADO.NET, DBA, Dev
|
PIEBALDconsult |
4.32 |
|
ADO.NET for the Object-Oriented Programmer – Part Three
Updated: 10 Feb 2006
In this article, we will see how to use ADO.NET to serialize an object model. Once we have finished with serialization, we will look at how to bind our object model to user controls.
C#, Windows, .NET, Visual Studio, ADO.NET, Dev
|
David Veeneman |
4.32 |
|
.NET DataSet to ADODB Recordset Conversion
Updated: 8 Mar 2006
A description of how how to convert a .NET DataSet to an ADODB Recordset.
VB, Windows, .NET, ASP.NET, Visual Studio, ADO, ADO.NET, Dev
|
KRucker |
4.29 |
|
Auto Saving DataGridView Rows to a SQL Server Database
Updated: 26 Jan 2006
Saving a changed row in the DataGridView automatically to the database seems to be a basic task, but is challenging to implement. Read here why the most intuitive approaches fail and how to get it working.
C#, Windows, .NET, Visual Studio, ADO.NET, WinForms, DBA, Dev
|
Peter Huber SG |
4.26 |
|
Build database independent ADO.NET programs with Mimer Provider Manager
Updated: 31 Mar 2004
Write database independent ADO.NET applications
C#, Windows, .NET 1.1, Visual Studio, DBA, Dev
|
fral |
4.25 |
|
Inherit from ADO.NET DataSet to create your own business objects
Updated: 27 Oct 2004
Extend generated Strong Typed Datasets, add your own business-specific functionality to a real DataSet object. Binding to forms and updating to a database is all done by the .NET framework. This is built on Shawn Wildermuth's a.k.a. ADO Guy's DataSetGenerator.
C#, VB, SQL.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP.NET, ADO.NET, VS.NET2003, DBA, Dev
|
Pinx |
4.24 |
|
Object Mapping Part II - Schema Code Generator
Updated: 17 Dec 2006
Generate an object mapping class from a schema definition.
C#, Windows, .NET, Visual Studio, DBA, Dev
|
Marc Clifton, J. Dunlap |
4.22 |
|
The ADO.NET OleDbDataReader class
Updated: 22 Aug 2003
Accessing database information using the DataReader class from ADO.NET in C#
C#, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev
|
Chris Maunder |
4.19 |
|
Using ADO.NET in MFC Projects
Updated: 9 Aug 2003
Mixing managed and unmanaged code and using .NET library in MFC projects
C++/CLI, VC6, VC7, VC7.1, .NET, Win2K, WinXP, Win2003, MFC, Dev
|
Majid Shahabfar |
4.18 |
|
Introduction to ADO.NET Sync Services
Updated: 18 Sep 2008
This article shows how easily we can create occasionally connected WinForms application using ADO.NET Sync services.
VB, Windows, .NET (.NET 3.5), ADO.NET, Dev
|
Vishal Shukla |
4.18 |
|
A Filter Dialog for a DataGridView
Updated: 28 Sep 2006
This is a dialog window that allows filtering a DataGridView. It can build filters with any depth of parentheses.
VB, Windows, .NET 2.0, ASP.NET, WinForms, VS2005, Dev
|
nauthiz69_3 |
4.09 |
|
How to avoid writing SQL for ADO.NET DataAdapter
Updated: 17 Jan 2005
Automatic creation of SQL for CRUD operations when Strongly Typed DataSets are used.
C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003VS.NET2003, DBA, Dev
|
Dejan Grujic |
4.08 |
|
WQL DataProvider for ADO.NET
Updated: 1 Sep 2004
WQL DataProvider for ADO.NET
Windows, .NET, Visual Studio, Dev
|
Maxim Kazitov |
4.07 |
|
ADO.NET and Stored Procedures Code Generator
Updated: 4 Sep 2008
A VB code generator that reads a SQL Server table and generates ADO.NET code and also Stored Procedures.
VB (VB 8.0, VB 9.0), SQL, Windows, .NET, ASP.NET, SQL Server, ADO.NET, DBA, Dev
|
Johnny Worker |
4.07 |
|
SQL Bulk Copy with C#.Net
Updated: 24 Jan 2007
An article about copying data to SQL within your application.
C#, SQL, Windows, .NET, SQL Server, Visual Studio, DBA, Dev
|
Kadir Camoglu. |
4.03 |
|
ADO.NET Primer using Managed C++
Updated: 30 Jul 2002
A primer on using ADO.NET with Managed extensions for Visual C++ .NET
C++/CLI, VC7, Windows, .NET 1.0, Visual Studio, Dev
|
Bill Ferreira |
4.00 |
|
Simplified .NET Data Access API
Updated: 10 Jul 2006
An API to simplify access to databases through ADO.NET.
C#, XML, Windows, .NET 1.1, .NET 2.0, Visual Studio, ADO.NET, DBA, Dev
|
BoneSoft |
4.00 |
|
Yet Another Filter Library
Updated: 1 May 2009
A class library that helps to create WHERE clauses in a SQL statement or a filter expression for a System.Data.DataRow select operation.
C#, .NET, ADO.NET, Dev
|
Antonello Genuario |
4.00 |
|
Using InfoMessage Event of SqlConnection Object
Updated: 8 Jun 2009
This article explores the usage of InfoMessage event of SqlConnection object
C#, SQL, .NET (.NET 3.5), ADO.NET, DBA, Dev, Design
|
Balamurali Balaji |
4.00 |
|
SqlBulkCopy in ADO.NET 2.0, SqlBulkCopy Class in C#, SqlBulkCopy help, SqlBulkCopy guide, SqlBulkCopy class, SqlBulkCopy tutorial
Updated: 28 Sep 2007
SqlBulkCopy in ADO.NET 2.0, SqlBulkCopy Class in C#, SqlBulkCopy help, SqlBulkCopy guide, Transferring Data Using SqlBulkCopy - SqlBulkCopy - Copy Table Data Between SQL Servers at High Speeds, perform bulk copies with .NET 2.0's SqlBulkCopy class, SqlBulkCopy tutorial
C#, SQL.NET 1.0, .NET 1.1, .NET 2.0, WinXP, .NET 3.0, ASP.NET, ADO.NET, WebForms, SQL 2000, VS.NET2003, VS2005, DBA, Dev
|
idreeskhan |
3.97 |
|
Convert XML to Strongly Typed DataSets
Updated: 3 Dec 2003
An example of using an XML document to generate a typed DataSet and load it.
C#, Windows, .NET, Visual Studio, Dev
|
Paperless |
3.95 |
|
Compressing Persisted DataSets
Updated: 19 Jun 2005
Using .NET 2.0 DeflateStream and GZipStream to compress persisted DataSets.
VB, XML.NET 2.0, WinXP, ADO.NET, VS2005, Dev
|
Adrian_Moore |
3.91 |
|
Implementing Audit Trail using Entity Framework - Part 2
Updated: 1 Apr 2009
Implementing Audit Trail using Entity Framework's caching entries
C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 3.5), ADO.NET, Architect, Dev
|
Morshed Anwar |
3.86 |
|
DRY Database Interactions (.NET 2.0)
Updated: 17 Oct 2009
Don't Repeat Yourself (DRY) when working with your database. Simple and easy code that makes it harder to make common mistakes.
C#, SQL.NET 2.0, ASP.NET, ADO.NET, Dev
|
Mark Ericksen |
3.83 |
|
Business Logic with Entity Framework
Updated: 26 May 2009
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 3.0, .NET 3.5, .NET 4.0), SQL Server (SQL 2005, SQL 2008), Visual Studio (VS2008), ADO.NET, WinForms, WebForms, LINQ, Architect, DBA, Dev, QA
|
Bishoy Ghaly |
3.76 |
|
ADO.NET – Get the notification events from Managed Providers
Updated: 3 May 2001
How to use the event handlers for various ADO.NET connection & data objects.
C#, VC7, Windows, .NET 1.0, Dev
|
Naveen K Kohli |
3.74 |
|
Simple ADO.NET Database Read, Insert, Update and Delete using C#.
Updated: 30 May 2001
An easy introduction to accessing databases using the ADO classes. It includes how to read and write integers, strings and dates.
C#.NET 1.0, Win2K, Visual Studio, Dev
|
John McTainsh |
3.73 |
|
Bulk Record Insert for Access
Updated: 5 Jan 2007
This article demonstrates how perform a bulk 'Insert' with MS Access.
C#, Windows, .NET, Visual Studio, DBA, Dev
|
jason_lakewhitney |
3.69 |
|
Add custom validation to data columns in ADO.NET
Updated: 14 Nov 2005
This article describes how to add custom validation to a data column in ADO.NET.
C#, Windows, .NET 1.1VS.NET2003, DBA, Dev
|
Karthik Krishnaswami |
3.67 |
|
A Handy Code to Get Your Project Connected to Any Database by ADO.NET
Updated: 16 Jul 2009
Purely object oriented ADO code component to get your project running, no matter what database you are using at the backend. Specialised for SQL Server.
C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 1.1, .NET 2.0, .NET 3.0, .NET 3.5), ASP.NET, ADO.NET, DBA, Dev
|
MeraMBA.com |
3.63 |
|
Replace SqlDataReader with a DynamicSqlDataReader
Updated: 31 May 2009
Remove those strings from your .NET 4.0 applications using the dynamic feature.
C#.NET 4.0, ADO.NET, Dev
|
TimMerksem |
3.60 |
|
ADO.NET
Updated: 23 Dec 2008
Understanding ADO.NET
C#, ADO.NET, WinForms, Dev
|
logicchild |
3.50 |
|
Simple Sample with Entity Framework
Updated: 9 Jul 2009
Simple sample with entity framework in 3 layers with ASP.NET
C# (C# 3.0), .NET (.NET 3.5), ASP.NET, ADO.NET, Dev
|
stexavcar |
3.43 |
|
A generic data reader with ILGenerator
Updated: 1 Mar 2007
Generating a delegate at runtime that reads from a DataReader. By reflection, it’s possible to bind directly a simple query to a list of objects.
C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev
|
Henri G Demers |
3.42 |
|
Multiple Database Connection File Manager
Updated: 31 Jul 2008
Utility to manage multiple DB connection strings for an application.
C#, XML, Windows (WinXP, Win2003, Vista), .NET (.NET 3.5), SQL Server (SQL 2000, SQL 2005), ADO.NET, Oracle, DBA, Dev, QA, SysAdmin
|
TSells |
3.40 |
|
Using SqlBulkCopy with ASP.NET 2.0
Updated: 25 Dec 2008
An article to explain the use of SqlBulkCopy class in ASP.NET
C# (C# 2.0), ASP, ASP.NET, ADO.NET, WebForms
|
Aman Bhullar |
3.40 |
|
How to save data from a DataSet into a T-SQL table
Updated: 5 Nov 2008
This article tells you how to save data from a DataSet into T-SQL tables.
C# (C# 1.0, C# 2.0, C# 3.0), XML, SQL, Windows, ASP.NET, ADO.NET, Dev
|
Sandeep Aparajit |
3.35 |
|
Schema.ini override and bulk upload using SQLXML
Updated: 15 Mar 2007
Schema.ini override and bulk upload using SQLXML
C#, VB, XML, SQL, Windows, .NET 1.1, Visual Studio, SQL 2000, DBA, Dev
|
Aravind Rajagopal K |
3.33 |
|
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 |
|
Database Transactions with Multiple TableAdpaters
Updated: 13 Mar 2008
An article on using Transactions with Strongly Typed Datasets and multiple Table Adpaters while taking advantage of Partial Classes.
C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 2.0), Visual Studio (VS2005), ADO.NET, Dev
|
Brice Schagane |
3.28 |
|
ADO.NET 2.0 Features
Updated: 24 Nov 2007
This article summarises the new and updated features of ADO.NET 2.0, which ships with .NET Framework 2.0.
C# 2.0, Windows, .NET 3.0, ASP.NET, Visual Studio, WebForms, Dev
|
Murali Krishna .Y |
3.25 |
|
DLinqEntityGenerator – SqlMetal-like DLinq entities generator, using XSL templates
Updated: 2 Jan 2007
This article explains how to generate DLinq entities mapped on SQL Server database objects, using an Add-In application on VS.NET.
C#, Windows, .NET, Visual Studio, LINQ, DBA, Dev
|
Dan Radu |
3.21 |
|
Working with DataGrid in VC++.NET
Updated: 15 Dec 2004
This article demonstrates the DataGrid , ADO.NET components, and storing data into the database and retrieving from the same.
C++/CLI, VC7, VC7.1, Windows, .NET, ADO.NET, VS.NET2003, Dev
|
Arul Nayagam C A |
3.20 |
|
AutoIncrement in a disconnected DataSet
Updated: 25 Sep 2005
Working with disconnected DataSets that contain autoincrement count.
C#, Windows, .NET CF, .NET 1.1, ADO.NET, VS.NET2003, Dev
|
balazs_hideghety |
3.20 |
|
Check if a table or field exists in a database
Updated: 13 Nov 2008
Function to check if a table or field exists in an MS Access or SQL Server database.
VB, .NET, ADO.NET, Dev
|
R. Syed |
3.18 |
|
DataTable Generator Using Attributes
Updated: 29 Jan 2007
This article demonstrates the first version of a DataTable Generator. This generator uses information found in custom attributes on any class and transforms the class, or several instances of it, to a System.Data.DataTable.
C#, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev
|
TeX HeX |
3.00 |
|
Converting a DataSet to a Generic List
Updated: 18 Jul 2009
Presents a simple utility framework that helps in converting DataSets to generic Lists.
C# 1.0, C# 2.0, C# 3.0, Windows, .NET 3.5, ADO.NET, Dev
|
Benzi K. Ahamed |
3.00 |
|
The SqlReader Object
Updated: 29 Dec 2006
Cutting your code time in half using a smart SQL frontend.
C#, Windows, .NET, Visual Studio, DBA, Dev
|
David Morton |
2.92 |
|
Recommended ADO.NET Data Access Strategies
Updated: 15 Sep 2002
ADO.NET provides two basic strategies for how you work with the disconnected data model
C#, VB, Windows, .NET 1.0, ASP.NET, Visual Studio, Dev
|
reddy123987 |
2.89 |
|
Portable SQL with ANTLR
- Unedited
Updated: 25 Feb 2008
Architectural overview of the MacroScope portable SQL ADO.NET provider
C# (C# 1.0, C# 2.0, C# 3.0)
|
vb3 |
2.88 |
|
Interbase and Visual C# .NET
Updated: 11 Jun 2008
A solution managing InterBase DB's with C# .NET
C# (C# 1.0, C# 2.0, C# 3.0), Windows (WinXP, Win2003, Vista), Visual Studio (VS.NET2003, VS2005, VS2008), WinForms, Dev
|
pechan00000 |
2.83 |
|
Generate Stored Procedure Wrapper Methods and Associated Wrapper Classes
Updated: 28 Sep 2008
This tool helps developers generate their ADO.NET stored procedure wrapper methods and any related strongly-typed data object class.
C#, .NET, ASP.NET, ADO.NET, Architect, Dev
|
Sunny Ahuwanya |
2.83 |
|
Using Data Relation with Data Table
Updated: 6 Apr 2007
This article exemplifies how to use the Data Relation of ADO.NET with Data Table to create the in memory Data Relation between two tables.
VB 7.x, Windows, .NET 1.1, Dev
|
Aakash Jain |
2.65 |
|
An Overview on ADO.NET
Updated: 22 Aug 2009
How to understand data access in .NET.
C# 1.0, C# 2.0, C# 3.0, .NET, ADO.NET, Dev
|
logicchild |
2.27 |
|
Localizable DataSet
Updated: 23 Nov 2004
Put language-dependent column captions in the DataSet itself and use it in your code wherever you need it!
C#, VB, JScript .NET, Forth.NET, .NET CF, Mobile, .NET 1.1, Win2K, WinXP, ADO.NET, VS.NET2003, Dev
|
Pinx |
2.25 |
|
.NET DataSet filter demonstration
Updated: 26 Jul 2007
This article explains how to filter rows in a DataSet/DataTable. The example provided will help you get information faster.
C#, Windows, .NET 1.0, .NET 1.1, .NET 2.0, .NET 3.0VS.NET2003, VS2005, Dev
|
NinethSense |
2.11 |
|
DataQuicker 0.9.0
Updated: 27 Sep 2005
DataQuicker takes the transparent level, speeds up your application building and reduces the coupling between application and database. It supports convertion from table/view to DAL directly with accessional tools. It can nearly cut off all your efforts on DAL design and coding...
C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP.NET, ADO, VS.NET2003, Dev
|
Eunge |
2.00 |
|
SQL Classes Encapsulation (simplified stored procedure calls, queries and DataSet returns with .NET)
Updated: 30 Jul 2005
A class that encapsulates SQL connection classes to make queries and stored procedures very easy to run in .NET. Contains methods like ExecuteStoredProcedure and ExcuteSelectStatement to return DataSets.
C#, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev
|
Xodiak |
1.73 |
|
ADO.NET and OPENXML to Perform Bulk Database Operations
Updated: 17 Dec 2007
Explains how to send bulk records to a database using OPENXML.
XML, C# 1.0, C# 2.0, C# 3.0.NET 1.0, .NET 1.1, .NET 2.0, .NET 3.0, .NET 3.5, ADO.NET, SQL 2000, SQL 2005, DBA, Dev
|
mfmaneef |
|
|
Changing column collations through C# and ADO.NET
- Unedited
Updated: 28 Sep 2009
Today we look into how collations in Sql Server bugged me while trying to get code generation to work on a database different from what it was originally build on. We also look at how I solved the problem (which is with some cool C# and WPF code).The problem contextLets take a look at the big pictu
All Topics
|
mrjvdveen |
|
|
|
top |
| Title /
Updated |
Author |
Score |
|
Exposing tabular data from your COM object - Part 2
Updated: 28 Jul 2000
The ATL OLE DB Provider templates appear to rely on the fact that your data is kept in a simple array, but that's not really the case at all!
SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev
|
Len Holgate |
4.95 |
|
How to Integrate an OLE Object with SQL Server
Updated: 15 Jun 2009
This article will demonstrate how we can integrate T-SQL with an external application.
C# (C# 2.0, C# 3.0, C# 4.0), .NET (.NET 2.0, .NET 3.0, .NET 3.5), SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), Visual Studio (VS2008), COM, COM+
|
Md. Marufuzzaman |
4.83 |
|
Exposing tabular data from your COM object - Part 3
Updated: 28 Jul 2000
Adding bookmark functionality is relatively easy and it enables our ADO recordset to be used with a greater number of data bound controls.
SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev
|
Len Holgate |
4.82 |
|
How to Integrate an OLE Object with SQL Server v2
- Unedited
Updated: 22 Aug 2009
This article will give you an idea about how to integrate an OLE Object that is a com+ api with SQL Server and write a message into a windows event log.
SQL, Windows, SQL Server (SQL 2000), Architect, DBA
|
Md. Marufuzzaman |
4.76 |
|
Making ATL OLE DB Provider templates support updating of data - Part 1
Updated: 20 Feb 2000
The ATL OLE DB Provider templates only seem to support read-only rowsets and making them support updating of data isn't as easy as you'd expect!
SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev
|
Len Holgate |
4.50 |
|
Exposing tabular data from your COM object - Part 1
Updated: 28 Jul 2000
ADO seems to be the ideal way to expose tabular data from your own COM objects and the ATL OLE DB Provider templates can help!
SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev
|
Len Holgate |
4.33 |
|
Making ATL OLE DB Provider templates support updating of data - Part 2
Updated: 20 Feb 2000
The ATL OLE DB Provider templates only seem to support read-only rowsets and making them support updating of data isn't as easy as you'd expect!
SQL, VC6, VB 6, SQL Server, MFC, DBA, Dev
|
Len Holgate |
3.60 |
|
|
top |
| Title /
Updated |
Author |
Score |
|
Using Data Access Objects (DAO) with WTL
Updated: 5 May 2008
DAO is old, obsolete, yet it is still very versatile and developer friendly.
C++ (VC8.0), Windows (WinXP), WTL, Dev
|
CodeWizard1951 |
4.74 |
|
CByteArrayFile - storing objects in databases using DAO
Updated: 17 Mar 2000
A class used to serialize object into a database field
SQL, VC6, SQL Server, MFC, DBA, Dev
|
Daniel Kaminski |
4.33 |
|
DAO library extension
Updated: 4 Mar 2002
My added DAO functionality makes database reading and writing easier
SQL, VC6, SQL Server, MFC, DBA, Dev
|
Kevin Smith |
3.47 |
|
Using CompactDatabase function with AppWizard's database application
Updated: 17 May 2004
This article shows how to use CompactDatabase() function with database application created with AppWizard, and how to calculate compression ratio. Solved problems: closing database instances, and reopening database without being noticed by users.
SQL, VC6WinXP, SQL Server, DBA, Dev
|
Anton P. Ivanov |
3.14 |
|
How to use DAO in Visual C++ without MFC
Updated: 26 Mar 2006
Use the #import directive and discover the DAO type library.
C++, Windows, Visual Studio, COM, Dev
|
Yuriy Tkachenko |
3.00 |
|
MTDaoRecordset : A DAO Class that supports MultiThreading
Updated: 4 Sep 2002
If you're sufferring from dao cracks in multithreaded environment, this article will be useful to you
SQL, VC6, VC7, Windows, SQL Server, Visual Studio, MFC, DBA, Dev
|
Kevin Hua |
2.78 |
|
|
top |
| Title /
Updated |
Author |
Score |
|
Fast and Easy Data Access with oSo.SimpleSql
Updated: 20 Jun 2009
A Data Access Framework using Generics, Lambda Expressions, Fluent Interfaces, and the SqlProviderFactory.
C# (C# 3.0), .NET (.NET 3.5), ASP.NET, ADO.NET, Dev
|
Charles T II |
4.94 |
|
Design and Implementation of an Attribute-Driven, Caching Data Abstraction Layer
Updated: 21 Jul 2008
An easy-to-use, attribute-driven data abstraction layer with multi-database support, intelligent caching, transparent encryption, multi-property sorting, property change tracking, etc.
C# (C# 1.0, C# 2.0, C# 3.0), Architect, Dev
|
owen654321 |
4.82 |
|
A Detailed Data Binding Tutorial
Updated: 25 Mar 2008
Demonstrates a variety of Windows Forms data binding features through several simple examples.
C# (C# 2.0, C# 3.0), .NET CF, .NET (.NET 2.0, .NET 3.0, .NET 3.5), Visual Studio (VS2005, VS2008), ADO.NET, Dev
|
Qwertie |
4.76 |
|
NHibernate and Complex Types for Native Keys
- Unedited
Updated: 3 Jun 2009
Learn how to use complex classes as primary (not composite!) keys with NHibernate.
C#, Windows, .NET (.NET 3.0, .NET 3.5), ASP.NET, Architect, DBA, Dev
|
Jeremy Likness |
4.71 |
|
Abstract Data Access Layer Design
Updated: 5 Sep 2009
The present document tries to describe the architecture of a specific layer of access to data for relational databases. This document tries to present/display a form to automate tasks of access to data.
C# (C# 1.0, C# 2.0, C# 3.0), SQL, All Topics, Architect, Design
|
Anwar Ibáñez O'Kamell |
4.60 |
|
Extending TableAdapters for Dynamic SQL
Updated: 9 Jul 2007
This article discusses ADO.NET TableAdapters – especially how to extend TableAdapter functionality using Visual Basic .NET
VB, Windows, .NET, Visual Studio, Dev
|
MikeInNH |
4.59 |
|
Implementing Repository Pattern With Entity Framework
Updated: 11 Jun 2009
Implement Repository Pattern in data access layer with Entity Framework
All Topics, Architect
|
Morshed Anwar |
4.57 |
|
Oracle Stored Procedure Wrapper
Updated: 11 Aug 2004
This small VB.NET application allows you to quickly generate VB.NET wrapper code for your Oracle stored procedures.
VB, SQL, Windows, .NET 1.1VS.NET2003, DBA, Dev
|
Barry Etter |
4.50 |
|
A Fast CSV Writer Using ATL
Updated: 7 Jun 2007
A Fast CSV Writer Using ATL
VC6, VC8.0, C# 2.0.NET 2.0, Win2K, WinXP, ATL, COM, ADO, VS2005, Dev
|
callmepls |
4.50 |
|
Microsoft Indexing Service How-To
Updated: 9 Jul 2007
This article describes how to provide full text search using Microsoft Indexing Service in .NET applications.
C# 1.0, C# 2.0, C# 3.0, Windows, .NET 1.1, .NET 2.0, .NET 3.0, ADO.NET, DBA, Dev
|
Ilya Verbitskiy |
4.46 |
|
Simulating Recordsets with ADO.NET
Updated: 2 Oct 2004
A proposed class to simulate the ADODB.Recordset behavior in .NET.
VB, SQL, Windows, .NET 1.0, .NET 1.1, ADO, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev
|
Alberto Venditti |
4.45 |
|
Schema Compare Tool for Oracle
Updated: 20 Jul 2004
This small VB.NET application allows you to compare Oracle database schemas against one another. This is very helpful when making sure your development instance is the same as your production instance; especially when implementing front-end changes.
VB, SQL, Windows, .NET 1.1VS.NET2003, DBA, Dev
|
Barry Etter |
4.40 |
|
DataGrid101: Using Windows.Forms DataGrid
Updated: 14 May 2003
Tutorial on the usage of Windows.Forms.DataGrid
VB, Windows, .NET 1.0, Dev
|
omri |
4.38 |
|
ADO.NET RecordSet Library
Updated: 18 Jul 2006
An ADO.NET recordset class.
VB, Windows, .NET, Visual Studio, ADO.NET, Dev
|
João Martins |
4.37 |
|
Use of custom attributes to serialise objects to/from SQL Server tables
Updated: 1 Nov 2005
Shows how you can use custom attributes to save .NET classes directly to an SQL Server table.
VB, SQL, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev
|
Duncan Edwards Jones |
4.25 |
|
QuickWhere: create complex forms for searching into databases
Updated: 21 Feb 2004
QuickWhere is component that helps you in the creation of complex forms for searching into databases.
VB.NET 1.0, Win2K, WinXP, Win2003, Dev
|
DragD |
4.19 |
|
Data binding concepts in .NET windows forms
Updated: 15 Feb 2003
A detailed look at the concepts involved in data binding and controlling data binding.
C#, VB 6.NET 1.0, Win2K, WinXP, Dev
|
Tarun Jain |
4.14 |
|
Dynamic Reports UsingSQL Queries
Updated: 23 Nov 2005
Dynamic report by using the PrintDocument component with SQL queries.
VB, Windows, .NET 1.1, ADO.NET, WinForms, VS.NET2003, CEO, Architect, DBA, Dev, QA
|
Pakorn Indhatep |
4.12 |
|
Simple Data Access in C#
Updated: 11 Jan 2009
Fast and easy to use data access class library.
C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 2.0, .NET 3.0, .NET 3.5), SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), Visual Studio (VS2005, VS2008), ADO.NET, Architect, Dev
|
6opuc |
4.04 |
|
Data Access Component
Updated: 30 Apr 2009
An open source Data Access Component
C# (C# 2.0), XML, SQL, Windows, .NET, ASP.NET, SQL Server, ADO.NET, LINQ, MySQL, Oracle, Architect, Dev, Design
|
zhongzf |
3.86 |
|
ADO.NET and UDL
Updated: 30 Sep 2005
Using Data Link files with SQLClient and OracleClient.
C#, VB, Windows, .NET 1.1, ADO.NET, VS.NET2003, Dev
|
ra1234567890 |
3.83 |
|
Article 2 - Display data using DataSet and DataGrid controls through Whidbey (VB.NET)
Updated: 9 May 2004
This article explains how we can display data using DataSet and DataGrid control after the database is created.
VB, VC6, VC7, VC7.1.NET 2.0, Win2K, WinXP, Win2003, MFC, VS2005, Dev
|
benoyraj |
3.83 |
|
Caching Data in WinForms DataGridView in NET 2.0
Updated: 4 May 2006
An article on how to show large amounts of records using DataGridView's virtual mode in paging.
VB, Windows, .NET 2.0, ADO.NET, VS2005, Dev
|
Nikhil Contractor |
3.81 |
|
How to Perform a Database-independent Databind with UDLA Framework
Updated: 12 Dec 2008
How to perform a database-independent databind with UDLA (Universal Database Layer Access)
C#, .NET, ASP.NET, Win32, Win64, ADO.NET, Dev
|
Sir Zeppa'Man |
3.80 |
|
Easy Data Access Layer
Updated: 10 Mar 2009
This library gives an easy data access tool for different data sources.
C# 2.0, C# 3.0, .NET, ADO.NET, Dev
|
eng. Plamen Kovandjiev |
3.79 |
|
ATL COM and ADO
Updated: 3 Apr 2001
An ATL Component that uses ADO for data.
VC6, VB 6, ATL, Dev
|
Amit Dey |
3.69 |
|
Data Access Layer (Part I)
Updated: 26 Oct 2005
This is the first part of the development of a Data Access Layer.
VB, Windows, .NET, Visual Studio, Dev
|
Settas Antonis |
3.68 |
|
Implementing a Provider Independent Data Access Layer in .NET
Updated: 3 Nov 2003
This article tells how you can implement a DAL which is provider independant.
VB, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev
|
Manoj G |
3.67 |
|
Database Connector
Updated: 28 Jan 2009
A system of plug-ins that provide very simple database access
C#.NET 2.0, ADO.NET, DBA
|
PIEBALDconsult |
3.60 |
|
Creating a DAL with SubSonic
Updated: 8 Nov 2007
Creating a DAL with SubSonic.
C# 2.0, Windows, .NET 2.0SQL 2000, SQL 2005, VS2005, DBA, Dev
|
Michael Ceranski |
3.56 |
|
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 |
|
Database local cache
Updated: 14 Dec 2007
A C# class that uses the local file system to cache binary objects stored in a database.
C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 2.0, .NET 3.0, .NET 3.5), SQL Server (SQL 2000, SQL 2005), ADO.NET, Dev
|
konamiman34 |
3.40 |
|
EasyData - A simple and fast way to work with data
Updated: 11 Apr 2005
This code shows a very simple way to work with data, using XML serializer, and a little trick with ArrayLists.
VB, XML.NET 1.1, WinXPVS.NET2003, Dev
|
rmaax |
3.36 |
|
Custom Data Grid with Field Chooser functionality
Updated: 1 Jan 2003
A datagrid control with field chooser context menu
C#, VB.NET 1.0, Win2K, WinXP, Dev
|
GKris |
3.32 |
|
Runtime Connection Wizard
Updated: 10 Feb 2007
A control to define and save SQL Connections in runtime
VB, Windows, .NET, Visual Studio, WinForms, Dev
|
Jakob Lithner |
3.29 |
|
SQL Database Editor
Updated: 25 Aug 2004
An article on a SQL database editor.
VB, SQL.NET 1.1, Win2K, WinXP, Win2003, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev
|
Charl Pohlmann |
3.29 |
|
Data Accessor Class for VB.NET and ASP.NET
Updated: 19 Mar 2003
Wrap up Routine Data Accessing Code into a class
VB, Windows, .NET 1.0, ASP.NET, Visual Studio, Dev
|
David Bernett |
3.24 |
|
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.17 |
|
Table Adapters and Generics in Visual Studio 2005
Updated: 12 Jun 2007
Using Generics to minimize duplicate code when using Table Adapters in a Data Access Layer (DAL)
VB, Windows, .NET 2.0VS2005, Dev
|
The Burger |
3.00 |
|
Easier Database Access with Diamond Binding (Part 2)
Updated: 18 Sep 2007
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
SQL, C# 2.0.NET 2.0, Win2K, WinXP, Win2003, Vista, .NET 3.0, WebForms, SQL 2000, SQL 2005, VS2005, Architect, DBA, Dev
|
Matty22 |
2.93 |
|
Databinding with Cross Reference table (many to many)
Updated: 20 Apr 2004
This article shows how to databind master and details DataGrids (Winforms) when using a cross reference table.
VB, .NET, Win2K, WinXP, Win2003, Visual Studio, Dev
|
ss2art |
2.93 |
|
Developing Abstract Functions for Accessing Stored Procedures
Updated: 3 Apr 2008
This article explains about developing abstract functions for accessing Stored Procedures.
VB (VB 7.x, VB 8.0, VB 9.0, VB 6), Windows, .NET, ADO.NET, Dev
|
Ben Kotvis |
2.87 |
|
Inheriting Data Access Layer functions
Updated: 19 Jul 2004
Simplify DAL by using Reflection and database table naming conventions
VB, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev
|
Nigel-Findlater |
2.45 |
|
Download binary data from database using a Windows application
Updated: 14 Mar 2005
Function to download and open a file saved as IMAGE data in an SQL database.
VB, Windows, .NET, Visual Studio, Dev
|
SUNILT |
2.40 |
|
Generating a data layer using SubSonic
Updated: 20 May 2008
This article will demonstrate how to generate a data access layer using SubSonic.
C# (C# 1.0, C# 2.0, C# 3.0), XML, .NET, ADO.NET, Dev
|
dnpro |
2.20 |
|
A uniform interface for large texts for a C# SQL client
Updated: 26 Jul 2009
The article provides a simple interface for handling large text in SqlClient and C# file streams.
SQL, C# 1.0, C# 2.0, C# 3.0.NET 2.0, .NET 3.0SQL 2005, SQL 2008, Dev
|
AlexS9999 |
|
|
|
top |
| Title /
Updated |
Author |
Score |
|
A SQLite Server/Client Implementation
Updated: 23 Jan 2008
Implementing server/client architecture for the great SQLite!
C++, C++/CLI, C, DBA, Dev
|
Daniel Cohen Gindi |
4.91 |
|
Script SQL Server 2005 diagrams to a file
Updated: 7 Aug 2006
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
SQL, Windows, .NET 2.0, Visual Studio, SQL 2000, SQL 2005, DBA, Dev
|
craigd |
4.76 |
|
Stored Procedure Invocation Code Generator for VB, C# and JScript.NET
Updated: 14 Jun 2003
Stored Procedure Invocation Code Generator for VB, C# and JScript.NET
C#, VB, JScript .NET, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev
|
Simon Wilson |
4.71 |
|
DevShot - Database Snapshots for Developers
Updated: 25 Nov 2005
How to create runtime backups from SQL Server 2005 and restore them.
VB, SQL, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev
|
Tommi G |
4.67 |
|
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.67 |
|
Accessing XML Using Insert/Update/Delete/Query Statements
Updated: 12 Apr 2005
A psuedo-database for XML.
C#, Windows, .NET 1.1VS.NET2003, Dev
|
Marc Clifton |
4.64 |
|
Introducing Distributed Messaging using Service Broker in SQL Server 2005
Updated: 28 Sep 2005
An article on distributed messaging using Service Broker in SQL Server 2005.
SQL, Windows, .NET, Visual Studio, SQL 2005, DBA, Dev
|
Akram Hussein |
4.63 |
|
An introduction to a post-relational database for .NET : Matisse - Part 5
Updated: 29 Mar 2004
Object-oriented programming with a post-relational database
C#, VB.NET 1.1, Win2K, WinXP, Win2003, ASP.NET, Visual Studio, Dev
|
John Sasak |
4.62 |
|
An introduction to a post-relational database for .NET, Matisse - Part 1
Updated: 14 Jun 2004
Step by step introduction to a new generation database for .NET.
C#, VB.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP.NET, Visual Studio, Dev
|
John Sasak |
4.62 |
|
Generate SQL Insert statements for your SQL Server 2000 Database
Updated: 13 Apr 2004
Deploy your SQL Server 2000 database with scripts.
VB.NET 1.1, Win2K, WinXPVS.NET2003, Dev
|
daffrey |
4.60 |
|
.NET Data Access Class for Exchange 2000 Webstore
Updated: 16 Aug 2005
Assembly written in VB.NET that accesses Exchange 2000 Webstore data, using WEBDAV.
C#, VB, Windows, .NET 1.0, Visual Studio, Dev
|
clementsm |
4.59 |
|
SQL Agent: A Job Scheduler Framework
Updated: 8 May 2008
An easy-to-use .NET solution for Job Scheduling with pluggable actions that runs on a Windows Service. Back up your SQL Server Express and much more!
VB, XML, Windows, .NET 2.0SQL 2005, VS2005, DBA, Dev
|
Danilo Corallo |
4.54 |
|
XML data type tips in SQL Server 2005
Updated: 9 Nov 2006
Techniques for using the XML data type for storing data.
C#, VB, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev
|
Howard Richards |
4.54 |
|
Extending C# to Support SQL Syntax at Compile Time
Updated: 13 Jun 2005
Ever wished you could truly embed SQL functionality in your C# code without using strings or late binding? Imagine being able to write complex Where clauses purely in C#.
C#, Windows, .NET 1.1, ADO.NET, VS.NET2003, Dev
|
Chad Z. Hower aka Kudzu |
4.53 |
|
Oracle to SQL Server VB.NET Utility application
Updated: 7 Jun 2007
A utility program that allows you to enter SQL to select data from Oracle, the program will then create a table in SQL Server and copy the data using SQLBulkCopy.
VB, C# 2.0, Windows, .NET 2.0SQL 2000, VS.NET2003, VS2005, DBA, Dev
|
hoquet |
4.49 |
|
Connect to DB2 from Microsoft .NET
Updated: 28 Aug 2003
Microsoft .NET and Db2 conenction
C#, .NET, Win2K, WinXP, Win2003, Visual Studio, Dev
|
Sreejumon |
4.46 |
|
SQL Server backup utility
Updated: 3 Jun 2006
Restore/backup selected objects in SQL Server.
VB.NET 2.0, WinXP, Visual Studio, SQL 2000, SQL 2005, DBA, Dev
|
Shabdar Ghata |
4.46 |
|
An introduction to a post-relational database for .NET, Matisse - Part 3
Updated: 25 Mar 2004
Step by step guide for .NET programming with a Post-Relational Database
C++, C#, VB.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP, ASP.NET, Visual Studio, MFC, Dev
|
John Sasak |
4.38 |
|
Read Tables from SAP R/3 using SAP.NET Connector
Updated: 19 Feb 2004
Reading SAP R/3 made easy.
C#, Windows, .NET 1.1VS.NET2003, Dev
|
hardteck |
4.36 |
|
An introduction to a post-relational database for .NET : Matisse - Part 4
Updated: 26 Apr 2004
ADO.NET programming with a post-relational database
C++, C#, VB.NET 1.1, Win2K, WinXP, Win2003, ASP.NET, Visual Studio, MFC, Dev
|
John Sasak |
4.34 |
|
An Oracle Query Tool (part 1)
Updated: 23 Feb 2006
An Oracle query tool with syntax highlighting and a tabbed MDI interface.
VB, Windows, .NET, ADO.NET, WinForms, VS2005, DBA, Dev
|
Danilo Corallo |
4.34 |
|
VB DataGridView Automatically Saving Updates to a Bound Database
Updated: 11 Jul 2006
Demonstrates how to configure a DataGridView control to automatically store edits to bound datasets into the source database.
VB, SQL, Windows, .NET 2.0, Visual Studio, SQL 2005, DBA, Dev
|
Andrew Timberlake-Newell |
4.30 |
|
Optimizing building trees from a database
Updated: 20 Jan 2005
How a different way of looking at a problem can result in better performance.
C#, Windows, .NET 1.1, ADO.NET, VS.NET2003, Dev
|
NielsHoldijk |
4.29 |
|
An Approach to Viewing the Structure of a Database Using VB 2005
Updated: 14 Sep 2006
This article describes an easy approach to examining all of the tables, views, and columns in a database.
VB, SQL, Windows, .NET 2.0, ADO, ADO.NET, SQL 2000, SQL 2005, VS2005, DBA, Dev
|
salysle |
4.29 |
|
PostgreSQL & PostGis Operations
Updated: 10 Jun 2009
In this article, I would like to show you how to (backup, restore) DB & converting between PostGIS & Esri shape file
C# (C# 3.0), Windows (Win2003), Visual Studio (VS2008), DBA, Dev
|
Thabet Tech |
4.29 |
|
UI architecture for managing DTS packages
Updated: 3 Aug 2005
This articles details a UI architecture for managing DTS packages.
Windows, .NET, Architect, DBA, Dev
|
Narayana Rao Surapaneni, krmpradeep |
4.27 |
|
NetBase - A Minimal .NET Database with a Small SQL Parser, Part 1
Updated: 3 Nov 2009
This is a small database system that reads and writes to DBF-like files, with a SQL front-end.
C#, SQL, Windows, .NET, Visual Studio, Architect, Dev
|
buttonpusher |
4.23 |
|
.NET Data Persistence: SQL Server vs. Matisse vs. FastObjects
Updated: 10 May 2004
An article with source code examining the development speed and performance capability of .NET, Matisse and FastObjects
C#, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev
|
A.Z. Rosenberg |
4.21 |
|
DataLoaders - Unified Data to Object Binding
Updated: 31 Oct 2004
A framework to completely separate objects from their data source - allowing any data source to be used without prior consideration in your code or designs. Databases, text files, web services and potentially anything else can all be used or swapped transparently.
C#, VB, SQL, Windows, .NET 1.1, ADO.NET, VS.NET2003, Architect, DBA, Dev
|
David Wulff |
4.13 |
|
Object-Oriented database design with the DatabaseObjects library
Updated: 31 Jan 2007
Demonstrates creating object-oriented database systems with the DatabaseObjects library.
VB, Windows, .NET, Visual Studio, Dev
|
Toby Wicks |
4.00 |
|
LWDbComponents - Another Database Component
Updated: 10 Dec 2006
A full featured and easy to use DB component.
VB, XML, SQL, Windows, .NET 2.0, ADO.NET, VS2005, DBA, Dev
|
Luis Angel R.C. |
4.00 |
|
Single Object Property Database
Updated: 30 Oct 2007
Object Properties Snapshot Management
C# 2.0, Windows, .NET, Visual Studio, Dev
|
Tigran Martirosyan |
4.00 |
|
dbObject - Database code generation using attributes
Updated: 26 Jan 2006
A poor man's OR tool for generating VB.NET database code against a MySQL database.
VB, SQL, Windows, .NET, Visual Studio, DBA, Dev
|
wduros1 |
3.95 |
|
DataQuicker (ORM) 0.9.4: Introduction
Updated: 27 Sep 2005
DataQuicker helps build a clear application structure, accelerates developement, and decreases maintenance costs. It's more possible to provide our customer a perfect on-time project, and release us from over-time working and other delays.
C#.NET 1.1, Win2K, WinXP, Win2003, Vista, ADO.NET, VS.NET2003, Dev
|
Eunge |
3.92 |
|
Getting Started With Object Databases
Updated: 13 Jul 2006
A programmatic introduction to object database storage and a short comparison of ODBMS and RDBMS systems
C#, Windows, .NET, Visual Studio, Dev
|
carlos.muentes |
3.92 |
|
Database Resetter
Updated: 5 Oct 2004
A little tool to make life while developing with databases a little easier.
VB, SQL, Windows, .NET 1.1SQL 2000, VS.NET2003, DBA, Dev
|
Michiel de Rond |
3.85 |
|
Creating Managed Objects in SQL Server 2005
Updated: 21 Dec 2005
Creating managed objects in SQL Server 2005.
C#, Windows, .NET, Visual Studio, SQL 2005, DBA, Dev
|
Nishith Pathak |
3.84 |
|
NHibernate vs. NEO: Face to Face. Part I
Updated: 20 Jun 2005
The first article in the Nhibernate vs. NEO series. Introduction to NEO O/R mapping tool.
C#, SQL, Windows, .NET, ASP.NET, Visual Studio, ADO, ADO.NET, Architect, DBA, Dev
|
firefalcon |
3.83 |
|
An introduction to a post-relational database for .NET, Matisse - Part 2
Updated: 23 May 2004
Step by step introduction to a new generation database for .NET: Schema definition.
C#, VB.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, ASP, ASP.NET, Visual Studio, Dev
|
John Sasak |
3.82 |
|
Avoid Max Open Cursor Error In .NET
Updated: 18 Aug 2004
Handling Oracle Max Open cursor error when fetching multiple rows in .NET.
C#, SQL.NET 1.0, .NET 1.1, Win2KVS.NET2003, Architect, DBA, Dev
|
Vivek Shaurya |
3.80 |
|
Stop writing connection management code every time you access the database
Updated: 6 Jan 2006
A simple class library for database access without the pervasive and often-fragile connection management details.
C#, VB, SQL, Windows, .NET 1.1, .NET 2.0, ADO.NET, VS.NET2003, VS2005, DBA, Dev
|
Alvaro Mendez |
3.79 |
|
VB.NET Class Library: Access Table Interface
Updated: 12 Sep 2006
A toolkit that simplifies querying and updating Access database tables.
VB, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev
|
George B Gilbert |
3.67 |
|
Trouble with Installing SQL 2005 After Uninstalling CTP/Beta
Updated: 17 Dec 2005
After uninstalling the SQL Server 2005 CTP, if you are unable to install the release version, here is what you should do.
SQL, Windows, .NET, Visual Studio, SQL 2005, Architect, DBA, Dev
|
Dewey Vozel |
3.59 |
|
Using SQLParameters with VB.NET/C#
Updated: 2 Sep 2004
Using SqlParameters with stored procedures in .NET.
C#, VB, SQL, Windows, .NET 1.0, .NET 1.1, ASP.NET, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev
|
dotScott |
3.53 |
|
Using a generic data abstraction layer for database access in .NET
Updated: 22 Oct 2003
The proposed solution removes the hard coding of SQL statements in the application, therefore maximizing the portability of the program, while minimizing the risk of introducing new bugs.
C#.NET 1.0, .NET 1.1, Win2K, WinXP, Visual Studio, Dev
|
Rob van der Veer |
3.48 |
|
An OO Persistence Approach using Reflection and Attributes in C#
Updated: 9 Jun 2003
Describes how to use C# attributes , ADO.NET and C# to persist objects to databases.
C++, C#, .NET, Win2K, WinXP, Win2003, Visual Studio, MFC, Dev
|
Dan Bunea |
3.44 |
|
SQL Database Relation Builder
Updated: 23 Aug 2004
An article on automatically building the relationships between tables in a DataSet.
VB, SQL.NET 1.1, Win2K, WinXP, Win2003, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev
|
Charl Pohlmann |
3.33 |
|
Custom Configuration SQL Connection String Section
Updated: 23 Jan 2006
This solution demonstrates enforcing valid SQL connection strings in the App.Config file.
C#, XML, XSLT, Windows, .NET 1.1VS.NET2003, Dev
|
Ted Bouskill |
3.30 |
|
.NET MySQL Connexion V 1.2
Updated: 17 Jul 2003
Class Library for MySQL request
VB.NET 1.0, Win2K, WinXP, ASP.NET, MySQL, Dev
|
Romelard Fabrice (Alias F___) |
3.26 |
|
Simulating Stored Procedures in Microsoft Access using Enterprise Library Application Blocks
Updated: 25 Jul 2005
Simulating stored procedures in Microsoft Access using Enterprise Library Application Blocks.
VB, Windows, .NET 1.1VS.NET2003, Dev
|
defwebserver |
3.26 |
|
Convert DateTime To .NET Ticks Using T-SQL
Updated: 28 Dec 2003
Convert a datetime value to .NET-compatible Ticks using a T-SQL User-Defined Function. Useful for interoperation between .NET and unmanaged environments such as ASP and VB6
SQL, Windows, .NET 1.0, .NET 1.1SQL 2000, DBA, Dev
|
Eron Wright |
3.25 |
|
Creating and populating MS Access files from other databases, using DTS
Updated: 31 May 2006
An article on creating and populating an automated MS Access file from other databases.
VB, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev
|
Malik Nasir |
3.14 |
|
Controlling Text Field Input on Key Press
Updated: 31 Oct 2007
Shows the basics of controlling input on a controls key press event
VB 8.0, Windows, .NET, Visual Studio, DBA, Dev
|
The ANZAC |
2.71 |
|
Best Practice in File Storage while Building Applications - Database (Blob Storage) Vs File System
Updated: 7 Aug 2008
This article explains the best strategy to be followed while designing data storage applications by System Architects
Windows, .NET, Win32, SQL Server, Visual Studio, ADO, ADO.NET, Architect, DBA, Dev, Design
|
Ziyad Mohammad |
2.25 |
|
|
top |
| Title /
Updated |
Author |
Score |
|
SQL. How to find holes in sequences.
- Unedited
Updated: 17 Jun 2009
Hello,Did you ever been asked to find all holes in document numbers (docs are sequentially numbered)? I had to do this search twice. Once for auditing purposes: holes may mean some sort of forgery. And now customers want to reuse numbers of deleted docs. And how do you think holes can be found using
WCF
|
Anton Burtsev |
5.00 |
|
SQL. Running Totals.
- Unedited
Updated: 20 Jun 2009
Running totals... Accountants like them so much. But there is no way in SQL to make efficient query that calculate running total. Why? What is running total? It is just previous running total plus current value. But SQL syntax does not give an access to previous rows.
WCF
|
Anton Burtsev |
5.00 |
|
SQL. Fast GUID List Generator.
- Unedited
Updated: 27 Jun 2009
The article shows how one can use MS SQL Server to generate millions of guids in seconds.
WCF
|
Anton Burtsev |
5.00 |
|
SQLite for C# – Part 8 – Loading CSV/Pipe into SQLite via command line
- Unedited
Updated: 19 Sep 2009
Ever wondered how hard it would be to load a CSV file into a SQLite database?
SQL, DBA, Dev
|
GarethI |
5.00 |
|
Remotable Multi-tiered Object-centric Domain Framework
Updated: 23 Jul 2007
An article on building an agile multi-tiered business framework
C# 2.0, Windows, .NET 2.0, Visual Studio, WinForms, DBA, Dev
|
Emmanuel Nuyttens |
4.84 |
|
Introduction to WTL OLE DB Database Applications
Updated: 20 Jul 2002
How to create a basic WTL database application using an ATL wizard-generated OLE DB consumer and WTL's version of Dynamic Data Exchange (DDX)
SQL, VC6Win2K, WinXP, SQL Server, ATL, WTL, DBA, Dev
|
Ed Gadziemski |
4.84 |
|
Hands on how to configure the Microsoft MSDE
Updated: 14 Nov 2004
An article on how to setup and configure the MSFT MSDE 2000.
C++, SQLWin2K, WinXP, Win2003, Visual Studio, SQL 2000, DBA, Dev
|
Lars-Inge Tønnessen |
4.83 |
|
Implementing complex data binding in custom controls
Updated: 29 Aug 2006
An article on implementing complex data binding (DataSource and DataMember) on a custom control.
C#, Windows, .NET 2.0, ADO.NET, VS2005, DBA, Dev
|
Sascha Knopf |
4.82 |
|
Generic Solution Framework to Saving History of Records Using MSSQL Server 2005 Xml Column
Updated: 14 Mar 2007
An article about How to Save Old Versions of Records Using MSSQL Server 2005 Xml Column
C#, SQL, Windows, .NET, DBA, Dev
|
yincekara |
4.82 |
|
Dynamic... But Fast: The Tale of Three Monkeys, A Wolf and the DynamicMethod and ILGenerator Classes
Updated: 21 Jul 2008
How to use the DynamicMethod and ILGenerator classes to create dynamic code at runtime that outperforms reflection
VB, C# 2.0, C# 3.0, Windows, .NET 2.0, .NET 3.0, ASP.NET, VS2005, Dev
|
Herbrandson |
4.79 |
|
FileHelpers v2.0 - Delimited (CSV) or Fixed Data Import/Export Framework
Updated: 10 Jul 2007
An easy to use .NET library to read/write strong typed data from files with fixed length or delimited records (CSV). Also has support to import/export data from different data storages (Excel, Acces, SqlServer, MySql)
C# 1.0, C# 3.0, VB 7.x, VB 9.0, Windows, .NET CF, Mobile, .NET 1.0, .NET 1.1, .NET 2.0, Mono, .NET 3.0, ASP.NET, Visual Studio, ADO.NET, WebForms, Architect, Dev
|
Marcos Meli |
4.79 |
|
CppSQLite - C++ Wrapper for SQLite
Updated: 28 Oct 2004
A C++ wrapper around the SQLite embedded database library.
SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, VS.NET2003, DBA, Dev
|
Rob Groves |
4.79 |
|
SQL Injection Attacks and Some Tips on How to Prevent Them
Updated: 23 Jan 2005
Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.
C#, SQL, .NET, Win2K, WinXP, Win2003, Vista, TabletPC, Embedded, Visual Studio, SQL 2000, SQL 2005, SQL CE, Architect, DBA, Dev
|
Colin Angus Mackay |
4.78 |
|
Using CLongBinary for BLOBs
Updated: 30 Nov 1999
SQL, VC6, SQL Server, DBA, Dev
|
Shekar Narayanan |
4.78 |
|
Stored Procedure Class Wizard (SPCW)
Updated: 8 May 2001
A tool to generate class files to implement stored procedures
SQL, VC6, SQL Server, DBA, Dev
|
George Poulose |
4.77 |
|
NHibernate Made Simple
Updated: 31 Oct 2007
A simple, straightforward tutorial that will get you up to speed on the fundamentals of NHibernate as quickly as possible
C#, SQL, Windows, .NET, Visual Studio, DBA, Dev
|
David Veeneman |
4.75 |
|
Using Blobs with WTL OLE DB Database Applications
Updated: 6 Sep 2002
Describes an extension to DDX that can read and write blobs using OLE DB providers. Includes sample WTL OLE DB database projects for SQL Server "Pubs" and MS Access "Northwind"
VC6, VC7Win2K, WinXP, WTL, Dev
|
Ed Gadziemski |
4.75 |
|
The alxBase classes for work with DBF files
Updated: 5 Nov 2002
The alxBase classes for work with dbf files.
SQL, VC6, VC7Win2K, WinXP, SQL Server, MFC, DBA, Dev
|
Alexey |
4.73 |
|
Best Practice for Binding WinForms ListControls
Updated: 26 Sep 2004
This article demonstrates the best technique for databinding the ListBox and ComboBox controls in .NET Windows Forms
C#, VB, Windows, .NET 1.0, .NET 1.1VS.NET2003, Dev
|
Scott McMaster |
4.72 |
|
The CAccessReports class
Updated: 14 Mar 2000
A class for Printing and Viewing MS Access Reports
SQL, VC6, SQL Server, MFC, DBA, Dev
|
Tom Archer |
4.71 |
|
A scripted SQL query generation framework with IDE: SQLpp (v1.4)
Updated: 12 Sep 2003
A helper framework for generation of SQL queries in C++ and Lua
SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, STL, DBA, Dev
|
Jonathan de Halleux |
4.70 |
|
Accessing the Borland Database Engine (BDE) from Visual C++
Updated: 17 Nov 1999
SQL, VC6, Windows, SQL Server, DBA, Dev
|
Robert Pittenger |
4.70 |
|
Universal Database Admin for ASP.NET and SQL Server (Reloaded)
Updated: 15 Apr 2006
A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.
C#, SQL, Windows, .NET CF, Mobile, .NET 1.1, ASP.NET, SQL 2000, VS.NET2003, DBA, Dev
|
Quartz. |
4.68 |
|
Use Table-Valued Functions as Arrays in SQL Server
Updated: 6 Jun 2007
Provide array functionality in SQL Server using T-SQL or the CLR
C#, SQL, Windows, .NET, Visual Studio, DBA, Dev
|
Mark J. Miller |
4.68 |
|
Modeling Hierarchies
Updated: 17 Aug 2002
A solution to the problem of storing hierarchical data in a relational database.
C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev
|
Tomaž Štih |
4.68 |
|
StP Database Administrator
Updated: 26 Aug 2003
Web-based administration toolkit for MS Access databases
Win2K, WinXP, ASP, Dev
|
Philip Patrick |
4.65 |
|
Implement Phonetic ("Sounds-like") Name Searches with Double Metaphone Part IV: SQL Server and Advanced Database Topics
Updated: 19 Mar 2007
Presents a SQL Server Extended Stored Procedure wrapper around the author's C++ implementation, and discusses use of Double Metaphone with relational databases in general.
SQL, VC7Win2K, WinXP, Win2003, SQL Server, Visual Studio, DBA, Dev
|
Adam Nelson |
4.64 |
|
Persisted Permutations
Updated: 4 May 2004
An article on how to persist permutations of items in relational databases.
C++, SQL, Windows, Visual Studio, SQL 2000, DBA, Dev
|
Daniel Aioanei, Adi Malinaru, Andrei Postolache |
4.63 |
|
Lite ORM library (v2)
Updated: 28 Jul 2008
A small ORM library.
C# (C# 1.0, C# 2.0, C# 3.0), XML, .NET (.NET 2.0), ADO.NET, Dev
|
Sergey Busel |
4.63 |
|
Data Access Layer (DAL) with SqlWrapper library
Updated: 13 Jun 2005
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
C#, VB, SQL, VC7.1, Windows, .NET 1.1, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev
|
Andrey Shchurov |
4.63 |
|
A db grid control using ASP
Updated: 27 Aug 2001
A grid control for ASP written in JavaScript to display recordsets.
Windows, ASP, IIS, Dev
|
Bjornar Henden |
4.61 |
|
A sorting and paging DataGrid loading data on-demand, saving changes in bulk from and to an Oracle database, in ASP.NET
Updated: 22 Aug 2005
This article demonstrates how to implement a paging DataGrid with an Oracle database. It also demonstrates how to limit the volume of data to exchange between the Web Server and the browser by retrieving only the rows necessary and updating changes in bulk.
C#, SQL, Windows, .NET 1.1, ASP.NET, ADO.NET, VS.NET2003, DBA, Dev
|
Patrice Borne |
4.60 |
|
How To Automatically restart MySQL on Windows
Updated: 2 May 2005
This article provides a small executable (36K) which configures MySQL (or another Windows Service) to automatically restart whenever it fails/crashes.
SQL, VC7Win2K, WinXP, Win2003, SQL Server, MySQL, Architect, DBA, Dev
|
Emmanuel Kartmann |
4.59 |
|
Membership and Role providers for MySQL
Updated: 20 Dec 2005
This article provides two files that contain a Membership Provider and a Role Provider for ASP.NET v2.0.
C#, Javascript, XML, Windows, .NET, ASP.NET, Visual Studio, Ajax, MySQL, Architect, Dev
|
Rakotomalala Andriniaina |
4.59 |
|
Optimizing Performance in NHibernate: Part 2: A Collection of Enhancements
Updated: 9 May 2007
This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer.
SQL, C# 1.0, C# 2.0, Windows, .NET 1.1, .NET 2.0SQL 2000, SQL 2005, VS.NET2003, VS2005, Architect, DBA, Dev
|
Peter Weissbrod |
4.58 |
|
Auto-Generating a Comprehensive C# Data Access Layer
Updated: 6 Nov 2006
Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.
SQL, C# 2.0, Windows, .NET 2.0, SQL Server, ADO.NET, WinForms, VS2005, DBA, Dev
|
adamAFA46 |
4.58 |
|
LocalTranGuard - a TransactionScope Fix/Wrapper for LocalTransactions
Updated: 18 Apr 2007
Supporting LocalTransactions only with TransactionScope by avoiding escalation to MSDTC.
C# 2.0, Windows, .NET 2.0, SQL Server, Visual Studio, Architect, DBA, Dev
|
balazs_hideghety |
4.58 |
|
Insert Field (not append) Using ADOX
Updated: 2 Jun 2003
Using ADOX to insert field into a MS Access table.
SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, ATL, WTL, STL, DBA, Dev
|
Ferdie |
4.57 |
|
TransactionScope in .NET 1.1
Updated: 1 Jun 2005
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
C#, SQL, .NET, WinXP, Win2003, ASP.NET, Visual Studio, COM+, ADO.NET, SQL 2000, SQL 2005, Architect, DBA, Dev
|
Alexander Shirshov |
4.57 |
|
A Data Access Layer to persist business objects using attributes and reflection - Part III
Updated: 20 Mar 2002
Persistance to business objects through attributes and reflection
C#, Windows, .NET 1.0, Visual Studio, DBA, Dev
|
xicoloko |
4.56 |
|
Pluggable Sample Data Generator Framework and GUI
Updated: 7 Nov 2006
A framework for writing sample data generators and a GUI that allows these generators to be effectively used
C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev, QA
|
Troy Magennis |
4.56 |
|
DataTable Transaction Logger
Updated: 28 Feb 2006
Undo/Redo DataTable transactions by logging row changes (insert/delete) and field changes.
C#, Windows, .NET, Visual Studio, ADO.NET, Architect, DBA, Dev
|
Marc Clifton |
4.55 |
|
Database Deadlocks for Dummies
Updated: 2 Oct 2008
Explaining Database deadlocking to non-technical people
SQL, SQL Server (SQL 2000, SQL 2005, SQL CE), CEO, Architect, DBA, Dev, QA, Design, SysAdmin
|
Andrew J Dixon |
4.54 |
|
DeveelDB - A Brief Introduction
Updated: 22 Oct 2009
A description of the base functionalities and usage of a full-featured open-source pure .NET/Mono embedded RDBMS
C# (C# 1.0, C# 2.0), SQL, .NET (.NET 1.1, .NET 2.0), Linux, ADO.NET, Architect, DBA, Dev
|
Antonello Provenzano |
4.54 |
|
Database Programming With MySQL
- Unedited
Updated: 26 Jun 2008
Getting MySQL running and programming it with KDevelop
Linux, MySQL, Dev
|
pseudonym67 |
4.53 |
|
Passing an array or DataTable into a stored procedure
Updated: 27 Sep 2003
This article describes how to pass the equivalent of an array, into a stored procedure, showing a number of different data types. This technique doesn't have the size limitations that a number of other techniques suffer from.
C#, Windows, .NET 1.0, .NET 1.1, Visual Studio, DBA, Dev
|
Gareth Edwards |
4.52 |
|
SQL Tuning Tutorial - Understanding a Database Execution Plan (1)
Updated: 17 Apr 2005
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
C#, SQL, Windows, .NET, Visual Studio, ADO.NET, SQL 2000, SQL 2005, SQL CE, DBA, Dev, QA
|
Gael Fraiteur |
4.52 |
|
Databinding the SqlTypes
Updated: 1 May 2003
Databinding the SqlTypes using the PropertyDescriptor class and the ITypedList Interface
C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, Visual Studio, DBA, Dev
|
Dan Glass |
4.52 |
|
PostgreSQL/libpqxx Class Generator
Updated: 18 Aug 2006
Automated generation of PostgreSQL data transfer classes.
SQL, VC7.1, Windows, SQL Server, VS.NET2003, DBA, Dev
|
_oti |
4.50 |
|
How to link different data sources together
Updated: 11 Jun 2005
Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.
C#, SQL, Windows, .NET, ASP.NET, Visual Studio, ADO.NET, SQL 2000, SQL 2005, Architect, DBA, Dev
|
klaus_salchner@hotmail.com |
4.50 |
|
Easy way to create your Join queries
Updated: 26 Apr 2006
An easy graphical way to create complex nested SQL Join queries.
SQLWin2K, WinXP, Win2003, Vista, Visual Studio, SQL 2000, DBA, Dev
|
Emad Al-Ashi |
4.50 |
|
Approach to unit testing of .NET database applications with NDbUnit and XPath queries
Updated: 22 Jun 2007
The focus is on how one can test the content of a database to see if it adheres to certain assumptions
C#, XML, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev, QA
|
Serioja Sidorov |
4.50 |
|
Entity Framework Performance
Updated: 31 Oct 2009
A comparison of performance between ADO.NET and Entity Framework.
C# 3.0, C# 4.0.NET 3.5, .NET 4.0, SQL Server (SQL 2008), ADO.NET, Architect, DBA, Dev
|
Mark Nischalke |
4.50 |
|
Data Access and Transaction Handling Framework
Updated: 13 Jan 2005
Generic data access component for different datasources, sprocs/SQL, implicitly propagated transactions, explicitly managed transaction contexts etc.
C#, Windows, .NET 1.0, .NET 1.1VS.NET2003, DBA, Dev
|
Deyan Petrov |
4.50 |
|
QuickQuery - a database querying tool
Updated: 7 Feb 2005
A tool for querying all types of databases.
SQL, VC6Win2K, WinXP, SQL Server, MFC, DirectX, DBA, Dev
|
BlackDice |
4.49 |
|
ADO.NET Generic Copy Table Data Function
Updated: 25 Jul 2007
This generic function will allow you to copy data between any two ADO.NET providers with one simple method call
C# 2.0, Windows, .NET 2.0, Visual Studio, ADO.NET, DBA, Dev
|
Michael Ceranski |
4.48 |
|
Creating Excel Sheets using ODBC
Updated: 12 Jan 2000
Writing to Excel spreadsheets using only ODBC
SQL, VC6, SQL Server, Visual Studio, DBA, Dev
|
Alexander Mikula |
4.48 |
|
Project RDL - Open Source Report Definition Language implementation in C#
Updated: 9 Jan 2005
The RDL Project is an open source (GPL) implementation of the RDL for the .NET environment created by fyiReporting Software. RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Project RDL is a compact implementation of RDL.
C#, SQL.NET 1.1, WinXPSQL 2000, VS.NET2003, DBA, Dev
|
Kim Sheffield |
4.47 |
|
DB2 Access Classes
Updated: 27 Nov 2003
A set of classes to encapsulate DB2 CLI APIs in ADO style.
SQL, VC6, VC7, VC7.1Win2K, WinXP, Win2003, SQL Server, Visual Studio, STL, DBA, Dev
|
nickadams |
4.47 |
|
Create many-to-many relationships in LINQ for SQL
Updated: 1 Sep 2006
Creating many-to-many relationships in LINQ for SQL.
C#, SQL, Windows, .NET 2.0, LINQ, VS2005, DBA, Dev
|
Galin Iliev [Galcho] |
4.46 |
|
Identifying NHibernate-Related Bottlenecks through Performance Monitoring
Updated: 10 Jun 2007
A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues
SQL, C# 1.0, C# 2.0, .NET, Win2K, WinXP, Win2003, Vista, ASP.NET, SQL 2000, VS.NET2003, DBA, Dev
|
Peter Weissbrod |
4.46 |
|
Implementation of a B-Tree Database Class
Updated: 29 Jun 2006
An article and source code regarding the implmentation of B-Trees in C++.
SQL, VC7.1Win2K, WinXP, Win2003, SQL Server, VS.NET2003, DBA, Dev
|
_oti |
4.45 |
|
Another Embedded Database For C++
Updated: 14 Jan 2007
A C++ wrapper to SQLite database
SQL, VC6, Windows, SQL Server, DBA, Dev
|
Vijay Mathew Pandyalakal |
4.45 |
|
Correct Column Ordinals of an ADOX Table Object
Updated: 2 Jun 2003
Getting the correct column ordinals of an ADOX Table object.
SQL, VC6, VC7, VC7.1, VC8.0Win2K, WinXP, SQL Server, MFC, ATL, WTL, STL, DBA, Dev
|
Ferdie |
4.44 |
|
Database Visualization
Updated: 31 May 2006
This article aims to create a simple tool for visualizing database tables and relations, a database map to refer to.
C++, SQL, Windows, SQL Server, Visual Studio, DBA, Dev
|
VGirish |
4.44 |
|
Using a LLBLGen-generated data-access tier
Updated: 24 Aug 2002
An article which describes how to use the data-access tier, generated by the free, open source data-access tier generator for .NET: LLBLGen. The sourcecode for LLBLGen v1.2 in C# is included, plus the generated data-access tier used in this article (C# and T-SQL) and the creation script for the data
C#, Windows, .NET 1.0, DBA, Dev
|
Frans Bouma |
4.44 |
|
Database Independent Access
Updated: 5 Jan 2005
Use different database providers without tying implementation to one.
C#, SQL, Windows, .NET 1.0, .NET 1.1, ASP.NET, ADO.NET, VS.NET2003, Architect, DBA, Dev
|
Jaryl Sim |
4.43 |
|
Distributed Database Management System
Updated: 5 Dec 2008
A distributed database management system, having a main server-LookupServer, several DatabaseServers and Clients, using java.nio for communicating.
Java, Java (JavaSE 6), Dev
|
Alina Simion |
4.43 |
|
Installing MSDE with .NET Application
Updated: 28 Nov 2005
This article shows how to distribute or install MSDE with a .NET application.
C#, SQL.NET 1.1, Win2K, WinXPSQL 2000, VS.NET2003, DBA, Dev
|
Mukund Pujari |
4.42 |
|
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
- Unedited
Updated: 17 Nov 2007
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
C++, SQL, Windows, Visual Studio, SQL 2005, DBA, Dev
|
pinaldave |
4.42 |
|
Compact and Repair Access Database using C# and late binding
Updated: 20 Jul 2004
The code compacts and repairs an MS Access database from C# code using a JRO.JetEngine COM-object. Binding occurs at runtime, no references, no interops. Pure System.Reflection.
C#.NET 1.0, .NET 1.1, Win2K, WinXP, Win2003, COM, COM+, VS.NET2003, DBA, Dev
|
Alexander Yumashev |
4.42 |
|
Full Database Abstraction Layer Generator
Updated: 22 Oct 2003
Yet another DAL generator with SQL generation, multi database support, C# code generation, etc...
C#, VC6, VC7, VC7.1, .NET, Win2K, WinXP, Win2003, Visual Studio, DBA, Dev
|
Jonathan de Halleux |
4.41 |
|
Minimum Database Permissions Required for SqlDependency
Updated: 22 Mar 2006
This article explains how to give a user the minimum rights required for SqlDependency to work
C#, SQL, Windows, .NET 2.0, ADO.NET, SQL 2005, VS2005, DBA, Dev
|
Michael Vanhoutte |
4.41 |
|
ADO Recordset Paging in ASP
Updated: 21 Jun 2000
How to display multiple pages of records in ASP
Win2K, ASP, IIS, ADO, Dev
|
Konstantin Vasserman |
4.40 |
|
An Implementation of Dynamic Connection String and Cursor Handling using Enterprise Library 2.0 in an ASP.NET 2.0 Application with an Oracle Database
Updated: 14 Jun 2006
This article will explore some solutions for dynamic connection string and cursor handling using Enterprise Library 2.0 in an ASP.NET 2.0 applications with an Oracle database.
C#, SQL, Windows, .NET, ASP.NET, Visual Studio, DBA, Dev
|
Yunyou Yao |
4.40 |
|
Database Schema Versioning Management 101
Updated: 10 Apr 2007
An introductory approach to synchronizing database schema versions
SQL, Windows, Visual Studio, SQL 2000, SQL 2005, Architect, DBA, Dev, Design
|
Peter Weissbrod |
4.40 |
|
Easy Data Access
- Unedited
Updated: 23 Oct 2006
Run-time data accessor generation
VB, C# 1.0, C# 2.0, Windows, .NET 1.1, .NET 2.0, .NET 3.0, SQL Server, ADO.NET, VS.NET2003, VS2005, Architect, DBA, Dev
|
Igor Tkachev |
4.39 |
|
@@IDENTITY VS SCOPE_IDENTITY() in TSQL
Updated: 22 Jul 2009
Advantage of SCOPE_IDENTITY() over @@IDENTITY
SQL, SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), DBA, Dev
|
Robin_Roy |
4.38 |
|
Reading Excel files using ODBC
Updated: 12 Jan 2000
A discussion and demonstration of reading Excel files using ODBC
SQL, VC6, SQL Server, DBA, Dev
|
Alexander Mikula |
4.38 |
|
Discard changes in business objects
Updated: 16 Nov 2006
How to build a business object with the option to discard changes
C#, Windows, .NET, Visual Studio, DBA, Dev
|
Galin Iliev [Galcho] |
4.38 |
|
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 |
|
An XML Database Schema And Data Editor
Updated: 29 Sep 2002
View and edit your XML database schema and data
C#.NET 1.0, Win2K, WinXP, DBA, Dev
|
Marc Clifton |
4.37 |
|
C++ Object Oriented Database Generator
Updated: 17 Nov 1999
This project is a code generator to produce CObject-dervied data classes for Object-Oriented database management
SQL, VC6, Windows, SQL Server, Visual Studio, DBA, Dev
|
Robert Pittenger |
4.36 |
|
C# - CSV Import Export
Updated: 4 Nov 2008
This article introduces import and export functions between a flat CSV file and a SQL server.
C#, Windows, .NET 2.0, SQL Server, ADO.NET, WinForms, VS2005
|
Slyuch, András |
4.36 |
|
Saving Master-Details form using XML
Updated: 14 Apr 2004
This article shows how to save a master-details form using XML.
C#.NET 1.0, .NET 1.1, WinXP, Dev
|
Muffadal Jaorawala |
4.36 |
|
CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet
Updated: 15 Feb 2002
A Class to Read and Write to Excel and Text Delimited Spreadsheet
SQL, VC6, VC7Win2K, WinXP, SQL Server, Visual Studio, MFC, DBA, Dev
|
Yap Chun Wei |
4.35 |
|
How to make a random selection from an SQL table
Updated: 2 Mar 2005
A simple technique for selecting random records from a table.
C#, SQL, Windows, .NET CF, .NET, Mobile, ASP, ASP.NET, Visual Studio, ADO, ADO.NET, DBA, Dev
|
Ach1lles |
4.35 |
|
A Custom Business Objects Helper Class
Updated: 24 Jul 2006
This article shows how to construct a custom business object helper that will populate business objects from a datareader using generics, reflection, and custom attributes
C#, Windows, .NET, Visual Studio, DBA, Dev
|
adargel |
4.35 |
|
Typed SQLDataReader
Updated: 16 Aug 2004
This article would describe how to read column values based on column names, using SQLDataReader.
C#, Windows, .NET 1.0, .NET 1.1VS.NET2003, DBA, Dev
|
S Sansanwal |
4.33 |
|
BindingSource, Transaction Sandboxes, and Pre vs. Post Add Modalities
Updated: 13 Mar 2006
An investigation into different data entry modalities and the need for a transaction sandbox.
C#, Windows, .NET, Visual Studio, ADO.NET, Architect, DBA, Dev
|
Marc Clifton |
4.33 |
|
Using SQL DMO to Alter the Data Type of Table Columns
Updated: 1 Jun 2006
This article describes the usage of SQL DMO to automate few aspects of DB maintenance.
VBScript, SQL, Windows, Visual Studio, SQL 2000, DBA, Dev
|
Sarith Sutha |
4.33 |
|
Parameter Discovery on Microsoft Access With XML option. Using Microsoft Patterns and Practices
Updated: 13 Mar 2007
Automation of command parameter building targeting Microsoft Access
C#, Windows, .NET 2.0, WinForms, SQL 2005, VS2005, DBA, Dev
|
Patrickquinn1212 |
4.33 |
|
TDD using SqlCE and NHibernate
Updated: 10 Apr 2007
This article walks through setting up a SqlCE test bench when using TDD
XML, SQL, C# 2.0, Windows, .NET 2.0, SQL Server, VS2005, Architect, DBA, Dev, QA
|
Sean Chambers |
4.33 |
|
Using a Database Over a Webservice
Updated: 29 May 2007
This article shows an example implementation of a database used over a Web-Service
C# 2.0, Windows, .NET 2.0VS2005, Architect, DBA, Dev
|
Tetyana Loskutova |
4.33 |
|
How to Read Microsoft Excel 2007 Using a Connection String in C#
Updated: 28 Nov 2007
This article explains how to connect to Microsoft Excel 2007 using a connection string and populate DataGridView
C# 1.0, C# 2.0.NET 1.1, .NET 2.0, Win2K, WinXP, Win2003, .NET 3.0, .NET 3.5, ADO.NET, WinForms, VS2005, DBA, Dev
|
Mihadh |
4.33 |
|
C# Code Generator for Stored Procedures
Updated: 20 Feb 2006
This stored procedure will generate all the C# code for calling any Stored Procedure
C#, SQL, Windows, .NET, Visual Studio, ADO.NET, SQL 2000, DBA, Dev
|
PaulMcKenzie |
4.32 |
|
Data Access Component - declarative transactions at the method level without EnterpriseServices, different data sources supported, Part 1
Updated: 29 Oct 2002
Data Access Component - thin wrapper of ADO.NET eliminating the need for the transactional support provided by COM+, supplying a uniform interface to different data sources thus allowing for easy switching to another data source eventually
C#, Windows, .NET 1.0, DBA, Dev
|
Deyan Petrov |
4.31 |
|
A Data Access Layer to persist business objects using attributes and reflection - Part I
Updated: 20 Mar 2002
Persistance to business objects through attributes and reflection
C#, Windows, .NET 1.0, Visual Studio, DBA, Dev
|
xicoloko |
4.31 |
|
Web control to generate database design documents in HTML
Updated: 24 Jan 2006
Just 200 lines of VB.NET to document your SQL Server databases.
VB, SQL, Windows, .NET, ASP.NET, Visual Studio, ADO.NET, SQL 2000, DBA, Dev
|
Olivier Giulieri |
4.31 |
|
Database Viewer and Updater for any Database
Updated: 25 Jul 2006
View and update any database table and metadata. Includes sample databases.
C#, Windows, .NET 2.0, ASP.NET, IIS, Visual Studio, ADO.NET, SQL 2000, SQL 2005, DBA, Dev
|
avronp |
4.31 |
|
Prevent Circular References in Database Design
Updated: 2 Aug 2009
Circular reference can make your data inconsistent and potentially hazardous even if you have been following up on normal forms and constraints strictly
All Topics, Architect, DBA, Dev, Design
|
truongpham |
4.31 |
|
Web SQL Utility
Updated: 30 Aug 2006
A simple ASP.NET application to run queries against your databases. Stores history and favourites.
Javascript, C# 1.0, Windows, .NET 1.1, ASP.NET, VS.NET2003, Dev
|
Ashley van Gerven |
4.31 |
|
Implementing Dynamic WHERE-Clause in Static SQL
Updated: 8 Nov 2007
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
SQL, Windows, .NET, Visual Studio, SQL 2000, SQL 2005, DBA, Dev
|
John P Harris |
4.30 |
|
Managing Connection Strings for Web Farms in ASP.NET 2.0
Updated: 27 Apr 2006
How to manage database connection strings and connection string encryption for a web farm, in ASP.NET 2.0.
C#, XML, Windows, .NET 2.0, ASP.NET, WebForms, VS2005, Dev
|
Chris Cole |
4.29 |
|
SQL Server Permissions - Fixing Orphaned Users
Updated: 4 Nov 2003
A short article on recovering orphaned users when moving a database from one server to another.
C++, SQLWin2K, WinXP, Win2003, SQL Server, Visual Studio, DBA, Dev
|
Megan Forbes
|
4.29 |
|
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 |
|
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.27 |
|
Asynchronous Query Execution
Updated: 8 Dec 1999
Two classes that provide support for asynchronous SQL execution.
SQL, VC6, SQL Server, Visual Studio, DBA, Dev
|
Vachik Hovhannisyan |
4.25 |
|
Figure Out the Default Values of Stored Procedure Parameters
Updated: 3 Feb 2006
When working with Microsoft SQL JDBC driver, you cannot invoke a stored procedure without specifying all the parameters, including the optional parameters that have default values. Learn how to fix that problem here.
C#, SQL, Windows, .NET, SQL Server, Visual Studio, ADO, ADO.NET, DBA, Dev
|
Rafael Mizrahi, Laurence Moroney |
4.25 |
|
dexleapFTC, a full text engine made of pure stored procedures
- Unedited
Updated: 16 Jul 2006
Implement a full text engine by using stored procedures for all MS SQL server editions
C#, Windows, .NET, Visual Studio, DBA, Dev
|
Simon Pang |
4.25 |
|
Concurrent model in ADO.NET, ways that allow to negotiate disconnected model restrictions for Oracle databases
Updated: 5 Dec 2006
Using ADO.NET conrurrent model in Oracle databases.
C#, SQL, Windows, .NET, Visual Studio, ADO.NET, DBA, Dev
|
Michael Milonov |
4.25 |
|
Securely backup your SQL Server database and other files to a remote machine
Updated: 15 Apr 2007
An effective utility to securely backup an SQL Server database and/or a group of files to a remote machine
C#, SQL, Windows, .NET, Visual Studio, SQL 2000, DBA, Dev
|
vooose |
4.25 |
|
LINQ to SQL
Updated: 10 Dec 2007
How to use LINQ to SQL
C# (C# 1.0, C# 2.0, C# 3.0), .NET (.NET 1.0, .NET 1.1, .NET 2.0, Mono, DotGNU, .NET 3.0, .NET 3.5), SQL Server (SQL 2000, SQL 2005, SQL CE), ADO.NET, LINQ, DBA, Dev
|
Le Sourcier |
4.24 |
|
Microsoft Enterprise Library Data Access Block [DAAB] on Oracle Provider [ODP.NET]
- Unedited
Updated: 15 Jan 2008
Microsoft Enterprise Library Data Access Block [DAAB] on Oracle Provider [ODP.NET]
C# 2.0, Windows, .NET 2.0VS2005, DBA, Dev
|
Rain Man Alex |
4.24 |
|
Using the Foreach ADO Enumerator in SSIS
Updated: 4 Jun 2006
SSIS has a built in function for loops. In this blog article, I want to demonstrate how to use SSIS's Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e.g. name, language, version, etc.) about them.
SQL, Windows, .NET, Visual Studio, ADO, SQL 2005, DBA, Dev
|
r.stropek |
4.24 |
|
View Database Structure Using C#
Updated: 20 Jan 2008
An article on how to view a database structure using C#
C#, SQL Server, VS2005, Dev
|
salysle |
4.24 |
|
Determining Stored Procedure Parameters with SQL 2005
Updated: 18 Jun 2006
Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005
C#, SQL, Windows, .NET, Visual Studio, ADO.NET, SQL 2000, SQL 2005, DBA, Dev
|
gtamir |
4.23 |
|
MySQL 5 C# sample code using ObjectDataSources
Updated: 15 May 2006
A simple example using MySQL 5 and stored procedures with ObjectDataSources and Generics, in ASP.NET 2.0.
C#, SQL, HTML, Windows, .NET 2.0, ASP.NET, ADO.NET, MySQL, VS2005, DBA, Dev
|
defwebserver |
4.22 |
|
Creating Auto-Suggest Textbox Using ASP.NET 2.0 Client Callbacks
Updated: 15 Jun 2007
Implementing an auto-completion feature using ASP.NET 2.0 client callbacks
C++, Windows, .NET, ASP.NET, Visual Studio, WebForms, SQL 2000, DBA, Dev
|
azamsharp |
4.22 |
|
agStoredProc
Updated: 19 Nov 2004
With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.
C#, SQL, Windows, .NET 1.1, ADO.NET, SQL 2000, VS.NET2003, DBA, Dev
|
Alexander German |
4.20 |
|
Object-oriented database programming with db4o
Updated: 12 Oct 2007
An introduction to object persistence with db4o, an object-oriented database management system. Topics include storing, updating, deleting, and querying objects. All three db4o's query APIs will be explored.
C# 2.0, Windows, .NET 2.0VS2005, Architect, DBA, Dev
|
Buu Nguyen |
4.19 |
|
Passing an Array as Parameter to SQL Server Procedure
Updated: 13 May 2009
Passing an array as parameter to SQL server Procedure
SQL, SQL Server (SQL 2000, SQL 2005, SQL CE, SQL 2008), MySQL, Oracle, DBA
|
Mohammad Al Hoss |
4.18 |
|
OLE DB Templates - A light and simple Data Access Method
Updated: 22 Nov 1999
SQL, VC6, SQL Server, Visual Studio, DBA, Dev
|
Richard Warg |
4.15 |
|
Checking the New DST 2007 from a DBA Perspective
Updated: 31 Jan 2007
How to check if your Microsoft SQL Server 2005 is ready for the new DST 2007
C#, SQL, Windows, .NET 2.0, Visual Studio, SQL 2005, DBA, Dev
|
jamesplewis |
4.14 |
|
Accessing Microsoft Access databases in ASP using ADO
Updated: 26 Apr 2000
A simple introduction to using Access .mdb databases in your ASP pages
Win2K, ASP, ADO, Dev
|
Chris Maunder |
4.12 |
|
Strange behaviors of an access database
- Unedited
Updated: 3 Aug 2007
I invite any one who doesn't know about MS access mdb files safty (specially compact and repair) to read this, before it's too late!
SQL, VC6, VC7, VC7.1, VC8.0Win2K, WinXP, Win2003, SQL Server, MFC, VS.NET2003, VS2005, DBA, Dev, QA
|
Hamed Mosavi |
4.12 |
|
Digging SSIS object model
Updated: 19 May 2007
Describes SQL server 2005 Integration Service object model and different data flow components
SQL, C# 2.0, C# 3.0.NET 2.0, Vista, .NET 3.0SQL 2 |