Click here to Skip to main content

Submit your article

ADO.NET

ADO.NET

Great Reads

Loading Related Entities with Entity Framework - A Beginner's Primer

by David Rogers Dev

Learn how to load related entities using the Entity Framework with simple examples

Data Debugger Visualizer

by dotnetdan

VS 2005 debug visualizers for DataSet, DataTable, DataView, DataRow and DataColumn objects.

CurionLib Dynamic Data Entry Forms

by LarryCharlton

Dynamic data forms.

Client Side Multi-Column Dynamic Pivot

by Jesús López Méndez

This article introduces you to client side multi-column dynamic pivot, a cleaner, simpler and elegant alternative to the complex and convoluted dynamic server side pivot.

Latest Articles

Power Your .NET REST API with Data Queries and Reports

by Jani Giannoudis

REST API Reporting for .NET

Unit Test Your Database Classes

by freedeveloper

How to create a data access class in a way, that is possible to execute unit test on it

Managing GridView/DataGrid Control Programmatically in Visual Studio (C#) Web Form

by Raphael Adeniji

Many a times, we need to programmatically manage GridView/DataGrid in Visual Studio web applications and this looks very difficult because we do not know what properties or events of the control to use. It may also be as a result of time constraint.

UkrGuru.SqlJson Your Link Between SQL Server and .NET 5

by Oleksandr Viktor (UkrGuru)

Minimally simple UkrGuru.SqlJson package for modern data manipulation

All Articles

ADO.NET

"Mutating" Login

24 Nov 2011 by ortund

Login system with breach redundancy handling.

web_development

.NET DataSet to ADODB Recordset Conversion

8 Mar 2006 by KRucker

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

.NET Installer that automatically installs MSDE

26 Jul 2008 by John Kenedy S.Kom

This project enables developers to create a setup package that automatically installs MSDE and attaches database

SQL-server-2000

.NET Installer that Automatically Installs SQL 2005 Express

28 Jul 2008 by John Kenedy S.Kom

This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it

SQL-Server-2005

.NET Performance Tips & Tricks

27 Mar 2006 by arunlala

.NET Performance Tips & Tricks

12 reasons to consume OData feeds using Simple.OData.Client

22 Nov 2013 by Vagif Abilov

The article describes limitations of WCF Data Services client and shows how Simple.OData.Client can become a better alternative

15 Steps to Develop a Product Management System in Only a Day

23 Mar 2010 by Eunge

The article introduces how to easily develop business solutions in RapidWebDev through developing a product management system with the special requirement step by step.

A .NET State Machine Toolkit - Part III

26 Oct 2006 by Leslie Sanford

Using code generation with the .NET state machine toolkit.

A 21 KB Datalayer For All Your Data Transfer Needs

31 Dec 2010 by Joe Sweeney

How to build a single datalayer DLL that can be used by any application

A Base Windows Form for displaying, editing and automatically updating Many to Many relationships – Part 2

11 Oct 2005 by Gordon Moore

In this part I have added the routines to update the database on exit, and because I felt very generous, I have added in a routine to import data from an Excel datasheet.

A Base Windows Form for displaying, editing and automatically updating Many-to-Many relationships - Part I

29 Sep 2005 by Gordon Moore

A base Windows Form for displaying, editing and automatically updating many-to-many relationships.

A basic DataListView implementation

21 Nov 2005 by Stanciu Vlad

It implements an object that is intended for data viewing; the idea was to derive from a ListView.

A Beginner's Guide to Silverlight

11 Dec 2011 by Raj Lal

Chapter 11 of "Fun with Silverlight 4" More information at http://silverlightfun.com

web_development

A Beginner's Tutorial for Understanding ADO.NET

6 Apr 2012 by Rahul Rajat Singh

A beginner's tutorial for understanding ADO.NET using a simple application.

A Beginner's Tutorial for Understanding Transactions and TransactionScope in ADO.NET

4 Jan 2013 by Rahul Rajat Singh

This article is a beginner's tutorial for understanding what are transactions and how can transactions be implemented using .Net framework and ADO.NET for any ASP.NET web application or any other database driven application.

A Bindable, Sortable, Autosizing ListView

16 May 2005 by Steef D.

A listview with support for Databinding, Sorting & Autofit and upon rebinding data reselection of a previous selected item

A Closer Look Inside RAISERROR - SQLServer 2005

15 Aug 2009 by Abhijit Jana

This article describes how to use RAISERROR in SQL Server 2005

A Comparison of Data Access Methods - Part 2

12 Oct 2013 by Dr. Song Li

This is part 2 of a comparison on Data Access methods in the .NET environment.

A Comparison on Data Access Methods - Part 1

12 Oct 2013 by Dr. Song Li

This is the part 1 of a comparison on Data Access methods in the .NET environment.

A Comparison on Data Access Methods - Part 3

12 Oct 2013 by Dr. Song Li

This is the part 3 of a comparison on Data Access methods in the .NET environment.

A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET

22 Aug 2014 by Gurdeep Singh Toor

A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.

A Data Bound Combo Box

4 Dec 2004 by Stanciu Vlad

This article provides a combo box that is easy to use with data sources.

A Detailed Data Binding Tutorial

25 Mar 2008 by Qwertie

Demonstrates a variety of Windows Forms data binding features through several simple examples.

A Developer's First Look at Visual Studio 2010

19 Sep 2009 by jebarson

New features of Visual Studio 2010 discussed

A generic Collection to DataTable Mapper

27 Apr 2015 by Jörgen Andersson

A high performance extension for creating a DataTable from a Generic collection.

A generic loading of data in a DropDownList using caching mechanism

6 Apr 2005 by santosh poojari

This article shows you how to make use of DataAccessLayer and caching.

SQL-server-2000

A Handy Code to Get Your Project Connected to Any Database by ADO.NET

16 Jul 2009 by MeraMBA.com

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.

A Helpful Database Library

6 Dec 2006 by ~~_{lost in transition}~~

This article illustrates a helpful database library.

A Master-Detail Solution Using Single Input Controls

25 Nov 2005 by TofuBug24

Shows a solution for creating a Master-Detail relation using textboxes.

SQL-server-2000

A master-detail view with Entity Framework

22 Jul 2016 by Mohamed Kalmoua

In this article, I will create a master-detail view using the Entity Framework.

A Modified C# Implementation of Tony Selke's TextFieldParser

27 Feb 2005 by WendellH

A C# implementation of the TextFieldParser class submitted by Tony Selkes that includes the ability to put the schema in an XML file and load the data directly into a DataTable.

A N-Tier Architecture Sample with ASP.NET MVC3, WCF, and Entity Framework

11 Sep 2012 by Ws Hu

This article tries to introduce a decoupled, unit-testable, deployment-flexible, implementation-efficient and validation-flexible N-Tier architecture in .NET

A Nice Way to Collect All Input Errors in a Submit and Feedback to the User at a Time

2 Mar 2010 by Eunge

ValidationScope is used to collect all input errors in a context although validation code exists in independent APIs.

A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 4

23 Feb 2004 by Pete2004

The purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid

A pragmatic introduction to DOJO for form based CRUD database operations with ASP.NET

20 Jul 2012 by FiegeU

A pragmatically introduction to DOJO for form based CRUD database operations with ASP.NET

web_development

A propertymapping Extension for DataReaders

26 Jan 2016 by Jörgen Andersson

A propertymapping extension for DataReaders

A RichTextBox that can Bind to the RTF Property

24 Jun 2010 by Mike Baldini

Finally, a RichTextBox that can bind to the RTF property

A Server Control Authoring JavaScript

12 Jun 2006 by David Donovan

This is a short series of articles about Abstract Programming. This part is a look at C# authoring a JavaScript file at design time.

A simple Database Viewer - DBViewer

18 Apr 2005 by Uri Lavi

A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).

SQL-server-2000

A simple POC using ASP.NET Web API, Entity Framework, Autofac, Cross Domain Support

27 Oct 2012 by Anand Ranjan Pandey

The purpose of this article is to create a proof of concept to demonstrate the feasibility of ASP.NET Web API Beta Version.

A Simple RSS News Generating Tool

28 Apr 2005 by Stephan Pilz

A tool to generate/manage news and provide news via RSS.

SQL-server-2000

A Simplified SQL-CSV Import/Export Functionality

20 Oct 2005 by codeajay

A simplified SQL-CSV import/export functionality.

SQL-server-2000

A Small ADO.NET Library with Some ORM Capabilities

10 Dec 2011 by Sergey Busel

Basic CRUD methods with some other interesting features

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

22 Aug 2005 by Patrice Borne

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.

A two-way sortable DataGrid with a colors column

3 Nov 2008 by chiranjeeviD

A two-way sortable DataGrid with a colors column whose colors are dependent on a particular column value of your choice.

A very standard, powerful and easy to use Sample and Library for working on RSS 2.0

18 Feb 2005 by Dariush Tasdighi

With this library, you can easily create some RSS 2.0 files for your site and/or use some RSS 2.0 files from other sites into your site.

A Visual SQL Query Designer

23 Oct 2009 by Bernardo Castilho

This article describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OLEDB connection string.

A Web Server Authoring Dynamic JavaScript

12 Jun 2006 by David Donovan

This is a short series of articles about Abstract Programming. This part details how Abstract Programming can be used at runtime to create JavaScript that will serve as a .NET DataSet, only living on the client.

Absolute Beginner's Tutorial on Understanding and Using Dapper ORM

3 Aug 2018 by Rahul Rajat Singh

This article introduces Dapper to absolute beginners.

entity-framework

Abstract Simplified Stored Procedure Execution using .NET Interfaces

18 Aug 2010 by Oleg Vorkunov

Abstract simplified stored procedure execution using .NET interfaces without dealing with ADO.NET classes

Access Sessions from Silverlight and ASP.NET

20 Jan 2009 by A. Rajesh Kumar

Add or Retrieve Session Object from Silverlight and ASP.NET

Access to Oracle without tnsnames.ora

25 Oct 2005 by fstrahberger

Access to Oracle without tnsnames.ora

Accessing CommandTimeout Properties in a TableAdapter

9 Feb 2006 by PIEBALDconsult

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

AccountPlus

10 Sep 2009 by Ashish Tripathi

A Complete Account Management System

Add a Tree Menu to DataGrid Header Text

9 Nov 2005 by Florence FZ Li

This article shows how to add a JavaScript tree menu to a DataGrid head text.

Add, Edit, and Delete in DataGridView with Paging

24 Jan 2007 by jdkulkarni

This article describes DataGridView manipulation like add, edit, and delete, with paging, and using asynchronous method calls.

Add-in Programming

12 Jul 2010 by hamityildirim

Add-in - add-on programming and an example for Outlook add-in regions, views, rules, and reports.

Address Book and Events Reminder

13 Feb 2009 by SHRIDHAR TL

Allows to maintain and backup your contacts and also maintains a reminder. You can store data in any of the three different databases like Microsoft SQL Server, MySql, Microsoft Access

Admin Generator Part 1-3 -INSERT view

15 Nov 2011 by saharkiz

Using a table name as the querystring to generate admin views

ADO+.NET

5 May 2013 by Paulo Zemek

This library is intended to "replace" ADO.NET by solving type mismatches and by creating typed readers that are faster and easier to use than DataTables.

ADO.NET

23 Dec 2008 by logicchild

Understanding ADO.NET

ADO.NET

11 Oct 2013 by ASP.NET Community

ADO.NET stands for ActiveX Data Objects for .NET. It refers to the suite of data access technologies used to manipulate databases. ADO.NET is part

ADO.NET 101: SQL Connection

31 Aug 2004 by mysorian

A tutorial on connecting to SQL 2000 Server.

SQL-server-2000

ADO.NET and OPENXML to Perform Bulk Database Operations

17 Dec 2007 by mfmaneef

Explains how to send bulk records to a database using OPENXML.

SQL-Server-2005

SQL-server-2000

ADO.NET and Stored Procedures Code Generator

4 Sep 2008 by Johnny Worker

A VB code generator that reads a SQL Server table and generates ADO.NET code and also Stored Procedures.

ADO.NET and UDL

30 Sep 2005 by ra1234567890

Using Data Link files with SQLClient and OracleClient.

ADO.NET Asynchronous SQL Calls

10 Sep 2009 by gbd77rc

How to use asynchronous calls to SQL to receive progress information

ADO.NET Connection Pooling at a Glance

14 May 2008 by Neeraj Saluja

Connection pooling can increase the performance of any application by using active connections of the pool for consecutive requests, rather than creating a new connection each time.And at the same time, the developer who is the best judge of his/her application, can configure the connection pooling.

ADO.NET Data Access Component for SQL Server in C# and VB.NET

28 Sep 2012 by AdamNThompson

A data access component for SQL Server in VB.NET.

SQL-Server-2005

ADO.NET DataTable as XML parameter to an Oracle/SQL Server Database Stored Procedure

27 Jan 2010 by Bibhas Paul

ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.

ADO.NET Entity Framework as Data Access Layer

30 Oct 2009 by sarvesh.upadhyay

ADO.NET Entity Framework as Data Access Layer

entity-framework

ADO.NET Entity Framework Interview Questions

11 Dec 2013 by Shivprasad koirala

Quick revision of 25 important ADO.NET Entity Framework interview questions with answers.

entity-framework

ADO.NET for Beginners

22 Apr 2008 by logicchild

How to Create an Application to Access Data

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

10 Feb 2006 by David Veeneman

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.

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

19 Jan 2006 by David Veeneman

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.

ADO.NET Generic Copy Table Data Function

25 Jul 2007 by Michael Ceranski

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

ADO.NET Interview Questions: Part 1

20 Mar 2012 by Shivprasad koirala

Ado Dot Net Interview Question Part 1

ADO.NET RecordSet Library

18 Jul 2006 by João Martins

An ADO.NET recordset class.

Advanced FTP Server

24 Oct 2009 by SHRIDHAR TL

Enables remote access to your files and folders via FTP

Advanced SQL Server Monitor with Performance Graph, Analysis and Version Control

10 Jan 2012 by Huisheng Chen

monitor sql server processes and jobs, analyse performance, object version control, view executing sql query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach etc

stored-procedure

Advanced using OData in .NET: WCF Data Services

16 Dec 2010 by Vincent-Philippe Lauzon

Samples showcasing usage of OData in .NET (WCF Data Services); samples go in increasing order of complexity, addressing more and more advanced scenarios.

entity-framework

Agile software development methodologies and how to apply them

30 Dec 2013 by Monjurul Habib

Introduction to Agile software development methodologies and how to apply them. It is about how to work together to achieve a common goal. This article focus on how technology team work together well to plan, build and deliver software.

19 Nov 2004 by Alexander German

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

SQL-server-2000

28 Sep 2005 by azamsharp

See AJAX in action.

An Adventure in Creating a SOLID DAL

6 Jul 2014 by Dave Elliott

An attempt to create a flexible and re-usable Data Access Layer

An Approach to Viewing the Structure of a Database Using VB 2005

14 Sep 2006 by salysle

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

SQL-Server-2005

SQL-server-2000

An ASP.NET Application Using a MySQL Database

28 Nov 2005 by vivekthangaswamy

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

An Experimental Performance Comparison on the Methods to Pass Structured Data to SQL Server Stored Procedures from ADO.NET

23 Dec 2009 by Dr. Song Li

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.

An Introduction to Oracle's Berkeley XML Database

20 Mar 2007 by Handpeople

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

An Open Source ORM Framework - Light.Data

22 May 2019 by aquila huang

Introduction of the open source project Light.Data

An Oracle Query Tool (part 1)

23 Feb 2006 by Danilo Corallo

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

An overview of Open Data Protocol (OData)

28 Jun 2010 by Vincent-Philippe Lauzon

Overview of the OData protocol: what it is, how it works, and where it makes sense to use it.

An Overview on ADO.NET

22 Aug 2009 by logicchild

How to understand data access in .NET.

An SQL execution engine for DataSets

29 Jun 2006 by Lachlan Keown

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

Angular.js Example Application

4 Jun 2019 by Sacha Barber

An example application using angular/Rx for JavaScript/Web Sockets/jQuery

Angular2 & WebApi (SPA) for Enterprise App - Part 7 - Manage Application Lifecycle

29 May 2017 by tranthanhtu.vn

In this article, We will learn why do we need to manage the stages of our application.

Angular2 & WebApi (SPA) for Enterprise App - Part 8 - Build & Deploy Application

29 May 2017 by tranthanhtu.vn

In this article, we will learn how to build and deploy the code

AoB: A Base Windows Form for displaying, editing and automatically updating Many-to-Many relationships – Part 3

21 Oct 2005 by Gordon Moore

In this part I explain how to deal with concurrency issues.

Append Word documents using interop services

12 May 2005 by Rabeek

An article on Word append using interop.

Application Settings the .NET way. INI, Registry, or XML

27 Oct 2004 by Chad Z. Hower aka Kudzu

In this article, I’ll explain how you can easily store and retrieve your application settings with just a few lines of code