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

Generic DAL using ADO

22 Jul 2019 by #realJSOP

Avoid ORMs with this reasonably generic approach to ADO

Generic DAL for ADO.Net - A Revisit

10 Apr 2020 by #realJSOP

A rewrite of a previous article with more liquid nitrogen and bacon

Generic DAL Revisit - Making it Your Own, A Practical Example

9 Apr 2020 by #realJSOP

When you're using other people's code, especially code that might get updated from time to time, it's important to remember that you can probably extend it and make it in your own image, without necessarily changing the original code, and by using the power of object-oriented programming.

Simple Data Access in C#

11 Jan 2009 by 6opuc

Fast and easy to use data access class library.

SQL-Server-2005

SQL-server-2000

Compressed DataTable serialization using GZip

17 Sep 2008 by A$TRAL Moristar

Using this FastDataTable you can serialize your data with fast and good compressing.

Save Zip File in Access Database With File Encryption in C#

7 Jun 2014 by A. Najafzadeh

Saving zip files in access database with encrypting bytes when file saved in access database and decrypting bytes when extracting files from database . . .

Access Sessions from Silverlight and ASP.NET

20 Jan 2009 by A. Rajesh Kumar

Add or Retrieve Session Object from Silverlight and ASP.NET

Copy Data from a DataTable to a SQLServer Database using SQLServer Management Objects and SqlBulkCopy

15 Jan 2007 by Aaron VanWieren

How to copy data from a modified dataset into a SQL Server Database

Parent/Child (Hierarchical) Relational Treeview User Control Development in ASP.NET

14 Aug 2012 by Abdul Quader Mamun

Custom TreeView web user control for parent child relatioinal data upto infinity

Effective Paging with GridView Control in ASP.NET

16 Nov 2010 by Abdul Quader Mamun

Paging must be effective for large scaleable applications. Without smart and effective paging and sorting for huge amount of data, user request takes more time and uses more resources.

Crystal Reports with Dynamic Number of Columns with Typed Dataset

4 Aug 2010 by Abdul Quadir Saifee

Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005

SQL-Server-2005

Displaying Images from a Database in a GridView

9 Dec 2010 by Abhijit Jana

A simple guide for beginners, explaining one method of displaying images taken from a database on a GridView inside an ASP.NET web page

web_development

Beginners Introduction To XSL Transform: Rendering XML Data using XSL - Get HTML Output

7 Jul 2009 by Abhijit Jana

Beginners Introduction to Rendering XML data using XSL transformation, a step by step guide to rendering XML data using XSL

Overview of Error Handling in SQL Server 2005

1 Aug 2009 by Abhijit Jana

Overview of Error and Exception Handling in SQL Server 2005 using @@Error and Try-Catch

A Closer Look Inside RAISERROR - SQLServer 2005

15 Aug 2009 by Abhijit Jana

This article describes how to use RAISERROR in SQL Server 2005

Simplify Code Using NDepend

3 Nov 2009 by Abhishek Sur

Using this article you will get the basic idea of how you could use NDepend to control/analyze your application. It allows to apply design rules and refactor code.

Query Notification using SqlDependency and SqlCacheDependency

3 Nov 2012 by Abhishek Sur

The article demonstrates how you can use SQL Server Query Notification feature to get notification from database whenever the result of a command gets changed. Sample application demonstrating SqlDependency and SqlCacheDependency is also included.

ASP.NET TimeTracker Starter Kits Porting from Windows to Linux (Race to Linux)

5 Oct 2005 by Abi Bellamkonda

ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper

SQL-server-2000

How to make a random selection from an SQL table

2 Mar 2005 by Ach1lles

A simple technique for selecting random records from a table.

Auto-Generating a Comprehensive C# Data Access Layer

6 Nov 2006 by adamAFA46

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

SqlProcedure - Improve Database Performance, Eliminate Errors and Reduce Code

23 Nov 2007 by adambl

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

SQL-Server-2005

SQL-server-2000

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

Data Binding with Windows Forms 2.0: Programming Smart Client Data Applications with .NET

14 Feb 2006 by Addison-Wesley

Chapter 6: Presenting Data with the DataGridView Control.

EntityFrameworkCore Seeding Component

9 May 2017 by Adriaan Booysen

Adding Seeding Framework towards EntityFrameworkCore that can be wired up in either a dotnet core Web Application or WebAPI

entity-framework

Transferring backup files from a remote SQL Server instance to a local machine without network shares, FTP, HTTP

8 Mar 2009 by Adrian Pasik

This article is about transferring backups without raising the privileges of SQL Server, or using custom copying tools.

Compressing Persisted DataSets

19 Jun 2005 by Adrian_Moore

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

Printing Selected Columns and Rows in a DataGrid

13 Dec 2006 by Afrasiab Cheraghi

An article on printing selected columns and rows in a DataGrid.

DataGridView Printing by Selecting Columns and Rows

11 Mar 2007 by Afrasiab Cheraghi

An article on DataGrdView printing.

Complex numbers library in multiple languages

8 Mar 2015 by Afzaal Ahmad Zeeshan

This article contains a basic overview of the complex numbers, and their creation and functions most specifically the operator overloading for arithmetic functions. Programming languages include Java, C++, C# and VB.NET at the moment.

Provider Design Patterns in NET 2.0

29 Oct 2008 by Ahmad Eid Salim

Provider Design Pattern is a new pattern that Microsoft formalized in .NET 2 to increase application performance where there is no need to explicitly instantiate classes.

SQL-Server-2005

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

21 Sep 2004 by Ahmed jamil Kattan

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

dataGridview Using DataReader

24 Sep 2008 by Ahmed R El Bohoty

How to Fill dataGridview Using DataReader in Win App

Data Access Component

24 Dec 2009 by Aj 2010

A simple data access component for connecting with different types of data sources.

Learning Entity Framework (Day 1) : Data Access Approaches of Entity Framework in .NET

27 Sep 2018 by Akhil Mittal

In this article, we look at how we can leverage Entity Framework approaches and, as per need, use those.

Learning Entity Framework (Day 2): Code First Approach and Migrations in Microsoft .NET Entity Framework

28 Sep 2018 by Akhil Mittal

Code First Approach and Migrations in Microsoft .NET Entity Framework

Learning Entity Framework (Day 3): ASP.NET Web API 2 with Entity Framework 6 Code First Migrations

1 Oct 2018 by Akhil Mittal

ASP.NET Web API 2 with Entity Framework 6 Code First Migrations

Strongly Typed DataSet Generator

2 Dec 2009 by Akram Mellice

Generate strongly typed datasets

Understanding “Set based” and “Procedural” approaches in SQL

23 Mar 2009 by Al-Farooque Shubho

Exploring Set based and Procedural approaches to write better SQL in SQL Server.

Improving Web Application User Experience using AJAX and ASP.NET

19 Sep 2005 by Alagarsamy, Srinivas

This article explains AJAX and shows a sample using ASP.NET demonstating how it can be used to improve user experience of our web applications

Using Information from the .NET DataProvider

14 Jan 2010 by Alaric Dailey

Using information from the .NET DataProvider to improve dynamic SQL and allow the use of multiple databases

Secure Password Authentication Explained Simply

2 Apr 2014 by Alaric Dailey

Simple code and explanations to enable secure password authentication.

Working Around Issues When Using SQL Server Indexed Views

29 Jan 2010 by Alaric Dailey

Working around issues when using SQL Server indexed views.

Don't Hard Code Your DataProviders

1 Feb 2010 by Alaric Dailey

Correctly using provider factories to create database independant code

Load Any Object From Most Any Database

8 Feb 2010 by Alaric Dailey

Building An O/R Mapper Step 1

Using Custom Attributes to Map Database Tables and Columns to Classes and Fields

18 Feb 2010 by Alaric Dailey

Building an O/R Mapper: Step 2.

Handling database connections more easily

31 Jul 2011 by Alaric Dailey

Building an O/R Mapper: step 3.

Simulating Recordsets with ADO.NET

2 Oct 2004 by Alberto Venditti

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

SQL-server-2000

Using SQL Bulk Load to Upload Fixed Width Text Files

3 Mar 2009 by Alden John Snow

This project demonstrates what is likely the fastest way to upload one of those fixed width reports from a mainframe to a SQL server table.

SQL-Server-2005

SQL-server-2000

Simple and flexible way to access and store configuration settings

6 Jan 2012 by Aleksey Shurtygin

An easy way to manage application configuration with a wide range of options for storage.

Binding a generic collection to a DataGridView via Visual Basic 2008 code

16 Mar 2008 by Alessandro Del Sole

Binding a generic collection to a DataGridView in VB 2008, with a few lines of code.

DBTool - Database Schema Versioning Helper Tool and a TDD Primer

14 Nov 2008 by Alex Kolesnichenko

Article describes design, development and testing of a home-grown tool for database schema updates using TDD approach.

Class Data Binding using Custom Attributes

26 Sep 2006 by Alex S. Robson

This article is intended to introduce custom attributes and show how they can be used to create a lightweight data access layer.

Connecting to MySQL or SQL-Server from COBOL using ADO.NET

19 Jan 2010 by alex turner

How about a .NET COBOL program which uses ADO.NET to connect to either MySQL or SQL Server?

This will not be in BI (Purchasing a BI tool, you do not get this)

17 Apr 2016 by Alex_2979

A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.

Introduction to Entity Framework

27 Nov 2012 by Alex_Xia

A simple introduction for beginner to jump start on Entity Framework. The Model and query language are explained.

Benchmarking the Performance of Embedded DB for .NET: SQL CE 4.0 vs SQLite

3 Jul 2011 by Alexander Galkin

Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.

Windows-Phone-7

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

ResultSetTextBox

31 May 2005 by Alexander German

Displays data contained in a DataSet into a RichEdit control.

Entity Framework 5 vs. NHibernate 3.3 with Oracle 11g

4 Dec 2013 by Alexander Iskhakov

A comparison Entity Framework 5 and NHibernate 3.3 on a real-world .NET application with Oracle 11g.

sqlTunes - Query Your iTunes Library

7 Mar 2008 by Alexander Kojevnikov

sqlTunes is a small tool that exports iTunes library information to the SQL server.

SQL-server-2000

TransactionScope in .NET 1.1

1 Jun 2005 by Alexander Shirshov

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

SQL-Server-2005

SQL-server-2000

DataTable caching performance

18 Apr 2012 by Alexandros Pappas

This project implements caching of DataTables and provides functionality for testing performance.

SQL Simple Utilities

22 Sep 2016 by Alexandros Pappas

This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.

Measuring COM+ Performance

21 Jun 2016 by Alexandros Pappas

Measuring COM+ performance

Entity Framework with Audit Tables

10 Sep 2019 by Alexandros Pappas

This project describes how to use Entity Framework with update triggers and audit tables.

Entity Framework Core with Audit Tables

15 Apr 2020 by Alexandros Pappas

This project describes how to use Entity Framework Core with update triggers and audit tables.

Creating detail grid template at runtime using devexpress gridview

28 Aug 2016 by Ali Adly

A simple example that shows how to create detail grid template at runtime using ASPxGridView

Restaurant and Waiter project! (WPF - Windows Mobile)

22 Jan 2012 by Ali Daneshmandi

Restaurant and Waiter project! (WPF - Windows Mobile)

Microsoft Indexing Service and OLEDB

15 Apr 2008 by Ali Hamdar

How we can access the Windows Indexing Service using OLEDB.

SQL-Server-2005

SQL-server-2000

How to change ConnectionString easily

6 Feb 2010 by Ali Marzban

Changing ConnectionString like an attribute in C#

SQL-Server-2005

Entity Framework 4 Tips for WinForms Development

21 Jul 2010 by Ali Ozgur

I've been recently working on a smart client (WinForms) application backed by Entitiy Framework 4 (EF4) on Visual Studio 2010. In this blog post I will try to give you some tips regarding some limitations and points to be careful about EF4.

entity-framework

Using config file for Custom Assembly in Reporting Services (Step by Step)

15 Jun 2007 by alifaraze

A trick to use config file for Custom assembly in reporting services

SQL-server-2000

SingleSimon - Password Manager Application

30 Sep 2008 by alon1980

An open source password manager with some advanced features and cool interface

SQL-Server-2005

Paging and Sorting on SQL Server and Oracle using Sql.Net

21 Feb 2005 by Alon_Catz

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

SQL-Server-2005

SQL-server-2000

Stop writing connection management code every time you access the database

6 Jan 2006 by Alvaro Mendez

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

Excel reporting in ASP.NET using C# and DataGrid

31 Mar 2005 by Amalorpavanathan Yagulasamy(AMAL)

This article demonstrates Excel report generation in ASP.NET using C# and DataGrid.

Using SqlBulkCopy with ASP.NET 2.0

25 Dec 2008 by Aman Bhullar

An article to explain the use of SqlBulkCopy class in ASP.NET

The HTML Report Engine

23 Jun 2006 by Ambalavanar Thirugnanam

The HTML report engine is a .NET class library which helps in generating well formatted HTML reports.

Copy Database Schema and Data Using SQL Server Management Objects (SMO)

28 May 2008 by Ameet Parse

How to use SMO to copy database schema and data using C#.

Mysql Data Access Layer

20 Apr 2009 by Amgad Fahmi

This an easy way to interact with your mysql database.

Database Comparator

8 Jan 2009 by Amir Mehrabi-Jorshari

With this tool, you can compare two databases and generate a difference report.

SQL-server-2000

23 Apr 2009 by Amit Chaudhary

SQLDoc Sharp, an interactive tool designed to generate the SQL Server 2005/2008 documentation.

Insert, Update, Search and Delete (CRUD operation) using ASP.Net and MySQL

17 Aug 2012 by AmitGajjar

Create, Read, Update and Delete operations in ASP.Net with MySQL database with N-Tier Architecture

web_development

Load a billion rows in a DataGridView

4 Aug 2009 by anagram of iEnableMuch = Michael Buen

This article presents how to load rows virtually in a DataGridView without using its RowCount (memory hog).

SAP .Net Connector 3.0 (NCo) Example

30 Sep 2014 by anand P Singh

This is a simple example to show how to connect to SAP using SAP .Net Connector 3.0

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.

Composed LINQ Queries using the Decorator Pattern

28 Jun 2010 by Anas Karkoukli

Design Patterns Series - Part I

Data Access Layer (DAL) with SqlWrapper library

12 Jun 2005 by Andrey Shchurov

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

SQL-server-2000

Introduction to using jQuery with Web Services

20 Mar 2012 by Andy Marshall

Basic Introduction to jQuery using SQL Server, Web Services

Database driven client side calculations in GridView

19 Apr 2009 by Aneesur Rehman Khan

This article demonstrates how to develop client side calculations in a GridView, and calculation expressions are configurable at the DB side.

ASP.NET MVC (NetCore 2.0) Generic Controller and Views for Handling Entity Frameworks DbContexts and Objects

22 Mar 2018 by Angel Gabriel Valdés Sarduy

This project is an ASPNET Core MVC site with a generic controller for CRUD and searchs.

Reading .CSV File and Inserting Data to SQL Table using SqlBulkCopy

11 Feb 2010 by Angsuman Chakraborty

In this article, we will discuss how to use sqlbulkcopy.

Tree/Organization structure

3 Jul 2013 by Anil kumar Bhardwaj

Create HTML tree or organization structure for web applications.

Using CheckBoxes within the DataGrid control to select records

3 Jul 2004 by Ansil

This article is about using CheckBoxes in a Datagrid control to select records as in a mail box.

SQL-server-2000

Persisting checked state across pages in a DataGrid

4 Sep 2005 by Ansil

This is an article about maintaining checked state across pages in a DataGrid.

Architectural Best Practices - Automating SQL Parameter Creation and Assignment

18 Jul 2007 by Anton Pious Alfred

Most systems that use Stored Procedures make use of SQL parameters to send and receive information from the database. The code to create these SQL parameters and then populating them is repeated throughout the system. This article describes how to automate this code.

SQL-server-2000

Yet Another Filter Library

1 May 2009 by Antonello Genuario

A class library that helps to create WHERE clauses in a SQL statement or a filter expression for a System.Data.DataRow select operation.

DeveelDB - A Brief Introduction

22 Oct 2009 by Antonello Provenzano

A description of the base functionalities and usage of a full-featured open-source pure .NET/Mono embedded RDBMS

Paging in any ASP.NET grid using SQL Server 2005

14 Jul 2010 by Anuj Khadloya

Implementing paging in any ASP.NET grid using SQL Server 2005.

Cross-Tab Reports : Dynamically add columns to grid

9 Sep 2007 by apna

Article describing how to work of girds which needs to add columns dynamically at run time.