Click here to Skip to main content
14,546,625 members

ADO.NET

Great Reads

by David Rogers Dev
Learn how to load related entities using the Entity Framework with simple examples
by Jovan Popovic(MSFT)
Complex properties in entity Framework models such as arrays, dictionaries, and objects can be serialized in SQL Server database in JSON format. In this article I will show you how to map your properties in EF model to database columns that contain JSON.
by dotnetdan
VS 2005 debug visualizers for DataSet, DataTable, DataView, DataRow and DataColumn objects.
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

by Joydip Kanjilal
Building an ASP.NET Core Web API application using Entity Developer
by evry1falls
How to implement Google.Apis.Drive.v3 in a WinForms Project using VB 2015 and .NET 4.5
by Alexandros Pappas
This project describes how to use Entity Framework Core with update triggers and audit tables.
by #realJSOP
A rewrite of a previous article with more liquid nitrogen and bacon

All Articles

Sort by Updated

ADO.NET 

26 Oct 2001
Sandy Place
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.
22 Jul 2019
#realJSOP
Avoid ORMs with this reasonably generic approach to ADO
10 Apr 2020
#realJSOP
A rewrite of a previous article with more liquid nitrogen and bacon
9 Apr 2020
#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.
27 Sep 2018
Akhil Mittal
In this article, we look at how we can leverage Entity Framework approaches and, as per need, use those.
7 Jan 2014
Vinay Jade
ModalPopupExtender and ConfirmButtonExtender with GridView to View/Add/Edit data
22 Mar 2008
Muammar©
How to use a DataGrid control.
27 Sep 2009
Muammar©
How to read, filter and write your CSV files
17 Aug 2012
AmitGajjar
Create, Read, Update and Delete operations in ASP.Net with MySQL database with N-Tier Architecture
15 Jul 2019
DiponRoy
Conditinal filter query example in SQL, Lambda Expression, C#
6 Jul 2005
PSK_
Using a simple example, I'll explain how to prevent a program that can register thousands of dummy users to your database and play with your database and application performance.
18 Mar 2009
Shivprasad koirala
Dynamic validation according to logged in user
5 Jul 2009
Shivprasad koirala
One-many and one-one relationships using LINQ to SQL.
18 Jun 2012
Shivprasad koirala
Difference between BasicHttpBinding and WsHttpBinding.
11 Dec 2013
Shivprasad koirala
Quick revision of 25 important ADO.NET Entity Framework interview questions with answers.
26 Jun 2012
tanweer
Easy way to implement ASP.NET GridView paging .
6 Dec 2006
lost in transition
This article illustrates a helpful database library.
19 Dec 2008
Sandeep Mewara
A client callback custom control and how to use it in WebForms.
6 Jan 2006
Alvaro Mendez
A simple class library for database access without the pervasive and often-fragile connection management details.
11 Jan 2009
6opuc
Fast and easy to use data access class library.
17 Sep 2008
A$TRAL Moristar
Using this FastDataTable you can serialize your data with fast and good compressing.
7 Jun 2014
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 . . .
20 Jan 2009
A. Rajesh Kumar
Add or Retrieve Session Object from Silverlight and ASP.NET
14 Aug 2012
Abdul Quader Mamun
Custom TreeView web user control for parent child relatioinal data upto infinity
16 Nov 2010
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.
4 Aug 2010
Abdul Quadir Saifee
Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005
9 Dec 2010
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
7 Jul 2009
Abhijit Jana
Beginners Introduction to Rendering XML data using XSL transformation, a step by step guide to rendering XML data using XSL
15 Aug 2009
Abhijit Jana
This article describes how to use RAISERROR in SQL Server 2005
1 Aug 2009
Abhijit Jana
Overview of Error and Exception Handling in SQL Server 2005 using @@Error and Try-Catch
3 Nov 2009
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.
3 Nov 2012
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.
5 Oct 2005
Abi Bellamkonda
ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper
2 Mar 2005
Ach1lles
A simple technique for selecting random records from a table.
6 Nov 2006
adamAFA46
Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.
23 Nov 2007
adambl
Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors
14 Feb 2006
Addison-Wesley
Chapter 6: Presenting Data with the DataGridView Control.
9 May 2017
Adriaan Booysen
Adding Seeding Framework towards EntityFrameworkCore that can be wired up in either a dotnet core Web Application or WebAPI
8 Mar 2009
Adrian Pasik
This article is about transferring backups without raising the privileges of SQL Server, or using custom copying tools.
19 Jun 2005
Adrian_Moore
Using .NET 2.0 DeflateStream and GZipStream to compress persisted DataSets.
13 Dec 2006
Afrasiab Cheraghi
An article on printing selected columns and rows in a DataGrid.
8 Mar 2015
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.
29 Oct 2008
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.
21 Sep 2004
Ahmed jamil Kattan
An article explaining how to link your home database in your C# application.
24 Sep 2008
Ahmed R El Bohoty
How to Fill dataGridview Using DataReader in Win App
24 Dec 2009
Aj 2010
A simple data access component for connecting with different types of data sources.
2 Dec 2009
Akram Mellice
Generate strongly typed datasets
19 Sep 2005
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
31 Jul 2011
Alaric Dailey
Building an O/R Mapper: step 3.
8 Feb 2010
Alaric Dailey
Building An O/R Mapper Step 1
1 Feb 2010
Alaric Dailey
Correctly using provider factories to create database independant code
14 Jan 2010
Alaric Dailey
Using information from the .NET DataProvider to improve dynamic SQL and allow the use of multiple databases
2 Apr 2014
Alaric Dailey
Simple code and explanations to enable secure password authentication.
29 Jan 2010
Alaric Dailey
Working around issues when using SQL Server indexed views.
2 Oct 2004
Alberto Venditti
A proposed class to simulate the ADODB.Recordset behavior in .NET.
3 Mar 2009
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.
6 Jan 2012
Aleksey Shurtygin
An easy way to manage application configuration with a wide range of options for storage.
16 Mar 2008
Alessandro Del Sole
Binding a generic collection to a DataGridView in VB 2008, with a few lines of code.
14 Nov 2008
Alex Kolesnichenko
Article describes design, development and testing of a home-grown tool for database schema updates using TDD approach.
26 Sep 2006
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.
19 Jan 2010
alex turner
How about a .NET COBOL program which uses ADO.NET to connect to either MySQL or SQL Server?
17 Apr 2016
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.
27 Nov 2012
Alex_Xia
A simple introduction for beginner to jump start on Entity Framework. The Model and query language are explained.
3 Jul 2011
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.
19 Nov 2004
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.
31 May 2005
Alexander German
Displays data contained in a DataSet into a RichEdit control.
4 Dec 2013
Alexander Iskhakov
A comparison Entity Framework 5 and NHibernate 3.3 on a real-world .NET application with Oracle 11g.
7 Mar 2008
Alexander Kojevnikov
sqlTunes is a small tool that exports iTunes library information to the SQL server.
1 Jun 2005
Alexander Shirshov
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
18 Apr 2012
Alexandros Pappas
This project implements caching of DataTables and provides functionality for testing performance.
15 Apr 2020
Alexandros Pappas
This project describes how to use Entity Framework Core with update triggers and audit tables.
10 Sep 2019
Alexandros Pappas
This project describes how to use Entity Framework with update triggers and audit tables.
22 Sep 2016
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.
21 Jun 2016
Alexandros Pappas
Measuring COM+ performance
23 Mar 2009
Al-Farooque Shubho
Exploring Set based and Procedural approaches to write better SQL in SQL Server.
28 Aug 2016
Ali Adly
A simple example that shows how to create detail grid template at runtime using ASPxGridView
22 Jan 2012
Ali Daneshmandi
Restaurant and Waiter project! (WPF - Windows Mobile)
15 Apr 2008
Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
6 Feb 2010
Ali Marzban
Changing ConnectionString like an attribute in C#
21 Jul 2010
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.
15 Jun 2007
alifaraze
A trick to use config file for Custom assembly in reporting services
21 Feb 2005
Alon_Catz
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
30 Sep 2008
alon1980
An open source password manager with some advanced features and cool interface
20 Mar 2010
Svante Seleborg, Alphons van der Heijden, Dave Shaw, katakana2
A Windows Mobile C# reader for the popular Password Safe archive files.
31 Mar 2005
Amalorpavanathan Yagulasamy(AMAL)
This article demonstrates Excel report generation in ASP.NET using C# and DataGrid.
25 Dec 2008
Aman Bhullar
An article to explain the use of SqlBulkCopy class in ASP.NET
23 Jun 2006
Ambalavanar Thirugnanam
The HTML report engine is a .NET class library which helps in generating well formatted HTML reports.
24 Jun 2013
ambilykk
GlobalMeet -An Event Management Site for all events across globe powered by Azure and ASP.Net
20 Apr 2009
Amgad Fahmi
This an easy way to interact with your mysql database.
8 Jan 2009
Amir Mehrabi-Jorshari
With this tool, you can compare two databases and generate a difference report.
23 Apr 2009
Amit Chaudhary
SQLDoc Sharp, an interactive tool designed to generate the SQL Server 2005/2008 documentation.
4 Aug 2009
anagram of iEnableMuch = Michael Buen
This article presents how to load rows virtually in a DataGridView without using its RowCount (memory hog).
30 Sep 2014
anand P Singh
This is a simple example to show how to connect to SAP using SAP .Net Connector 3.0
27 Oct 2012
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.
4 Nov 2008
András Slyuch
This article introduces import and export functions between a flat CSV file and a SQL server.
31 Dec 2007
Andrew Smith, Josh Smith, Karl Shifflett
A high performance, full featured, multifunction visualizer allows detailed inspection of WPF, WCF, ASP.NET, XBAP's and WinForm applications. This includes viewing and drilling into public, protected and non-public members of any element or sub-element in the application. Current Version 3.0.0.4
29 Jan 2008
Andrew Smith, Josh Smith, Karl Shifflett
New Silverlight Movies For Mole. Mole v4.2 has GREAT new features! Visualizer with property editing. Mole is a high performance, full featured, multifunction visualizer that allows detailed inspection of WPF, WCF, WF, ASP.NET, XBAP's and WinForm applications. Editing of properties is now support
12 Jun 2005
Andrey Shchurov
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
20 Mar 2012
Andy Marshall
Basic Introduction to jQuery using SQL Server, Web Services
19 Apr 2009
Aneesur Rehman Khan
This article demonstrates how to develop client side calculations in a GridView, and calculation expressions are configurable at the DB side.
22 Mar 2018
Angel Gabriel Valdés Sarduy
This project is an ASPNET Core MVC site with a generic controller for CRUD and searchs.
11 Feb 2010
Angsuman Chakraborty
In this article, we will discuss how to use sqlbulkcopy.
3 Jul 2013
Anil kumar Bhardwaj
Create HTML tree or organization structure for web applications.
4 Sep 2005
Ansil
This is an article about maintaining checked state across pages in a DataGrid.
3 Jul 2004
Ansil
This article is about using CheckBoxes in a Datagrid control to select records as in a mail box.
1 May 2009
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.
22 Oct 2009
Antonello Provenzano
A description of the base functionalities and usage of a full-featured open-source pure .NET/Mono embedded RDBMS
14 Jul 2010
Anuj Khadloya
Implementing paging in any ASP.NET grid using SQL Server 2005.
9 Sep 2007
apna
Article describing how to work of girds which needs to add columns dynamically at run time.
22 Dec 2009
App Software
SQL Server Express Automated Backup Console Application
8 May 2012
Appusamy.subbian
Cloning the Entity object and all its children using the Entity Framework, using LINQ and Reflection.
17 Feb 2016
Aqeeel
Though GridView provides a way to implement paging however when the record count in very big we need to optimize it at the query level.
12 Apr 2016
Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table
22 May 2019
aquila huang
Introduction of the open source project Light.Data
27 Jun 2009
Arindam Sinha
Databinding - Searching and sorting BindingList.
31 Jan 2010
Arno Petersen
Classes to build insert and update statements for Microsoft SQL, OleDb and ODBC dataprovider
15 Dec 2004
Arul Nayagam C A
This article demonstrates the DataGrid , ADO.NET components, and storing data into the database and retrieving from the same.
27 Mar 2006
arunlala
.NET Performance Tips & Tricks
21 Apr 2008
aSarafian
Converting a Typed DataSet to and from LINQ entities.
10 Sep 2009
Ashish Tripathi
A Complete Account Management System
20 May 2008
Ashutosh Phoujdar
This article will demonstrate how to generate a data access layer using SubSonic.
29 Mar 2006
Asif Sayed
An article to demonstrate the creating of business document ids without using stored counters.
13 Jun 2006
Asif Sayed
An article to demonstarte the use of Reporting Services using Smart Client interfaces.
22 Oct 2007
Asif Sayed
This article will show you how to report XML data with Crystal Reports and a Windows Forms client.
15 Sep 2006
Asif Sayed
A step by step tutorial demonstrating the power of locally processed Reporting Services with the ASP.NET Web Client..
15 Jan 2007
Asif Sayed
A tutorial demonstrating the power of the AutoComplete feature of the TextBox control using a Windows Forms client and SQL Server 2000 data.
11 Oct 2013
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
11 Oct 2013
ASP.NET Community
Programming theMicrosoft® ADO.NET Entity Framework            by David SceppaPublisher : MicrosoftProgramming EntityFrameworkBuilding Data Centric
25 Jul 2006
avronp
View and update any database table and metadata. Includes sample databases.
2 Mar 2017
Awesh Vishwakarma
The easiest way to use Entity Framework with SQLite databases in C# Winform and Console Applications
26 Feb 2017
AXI_IeD
How to Filter contextually the list shown by a DataGridComboBoxCell?
31 Oct 2018
Aydin Homay
In this article, we will discover the power of generics in C#.
11 Feb 2015
Aydin Homay
In the software implementing business synchronizing structures/templates of the database entities with Data Access Layer SQL (commands/Transactions) is the most expensive thinks because you need to re-implement when you have change/s in your entities structure's such as Data-type, Name, and etc.
7 Nov 2012
Aydin Khatamneajd
Using ModelMetadataProvider to Set Display Name Metadata for the Model Fields at Runtime
28 Oct 2008
Ayman M. El-Hattab
Demistifying the SharePoint delegate controls, allowing fast and painless SharePoint branding.
21 Jul 2005
azamsharp
How to export DataGrid to Excel, Word and Text files.
13 Jul 2006
azamsharp
How to populate a TreeView control from the database.
8 Mar 2006
azamsharp
This article describes how to refresh a GridView control on the parent page, from a pop up window.
10 Jan 2006
azamsharp
How to implement row deletion in GridView, with confirmation.
24 Feb 2010
aztekka
UDL.Net is a ConnectionString editor built from scratch, modeled after the Universal Data Link (UDL) and the Visual Studio DataConnectionDialog.
21 Nov 2004
b_hardman
Generate code classes to access stored procedures via web services.
5 Oct 2008
Babak Ansari
A framework to develop Win-Form and Web-Form applications using generic components
23 Jul 2008
Babak Ansari
A method to create Windows and Web components with the same interface
5 Oct 2007
Babak Ansari
A custom asynchronous setup with progress indicator.
6 Feb 2007
Bala Murali S
This project is used to easily understand and implement Ajax in C#.net , ASP.Net with Ajax.dll
20 Jul 2004
Balachandar Ganesan
Auto Generate the ASPX page quickly
8 Jun 2009
Balamurali Balaji
This article explores the usage of InfoMessage event of SqlConnection object
8 Jan 2005
Barathan
Generic Customizable login control for VB.NET Windows Forms.
21 Mar 2014
Baxter P
Dependency Injection Data Demo with Lazy Loading and Data Mocking
10 Dec 2010
Beavis Killer
This article demonstrates how to write a domain service factory to host plain old class object (POCO) entities and use them through RIA Services in Silverlight version 4.
3 Apr 2008
Ben Kotvis
This article explains about developing abstract functions for accessing Stored Procedures.
9 Jun 2005
Benjamin Mayrargue
Adds support for MySQL databases in the Data Access Application Block.
18 Jul 2009
Benzi K. Ahamed
Presents a simple utility framework that helps in converting DataSets to generic Lists.
28 Jul 2014
Bernardo Castilho
A component that makes it easy to use Entity Framework in WinForms projects, including design-time binding support.
23 Oct 2009
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.
7 Aug 2008
bhadeliaimran
Inserting value of Collection into Database
23 Oct 2013
BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
27 May 2010
Bibhas Paul
CRUD (Create, Read, Update, Delete) Operation With Generic List
27 Jan 2010
Bibhas Paul
ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.
31 Oct 2007
Bill Seddon
Shows how a .NET based WebDAV server can be created by combining two Open Source projects. The example implementation returns files from a file system, but you can extend it to return resources from any repository.
27 Feb 2012
BillLange1968
Solution for creating a Leaderboard for a Windows Phone 7 (WP7) XNA game
13 Aug 2004
billxie
Minimize viewsate and database access to achieve optimized DataGrid sorting.
26 May 2009
Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
28 Jun 2007
blue_arc
This class will help developers to convert their data table into a ready to use JSON string on the client end JavaScript.
23 Jun 2005
Bob Carboni
Use the DataGrid to easily enter new data values with a hidden row.
1 Nov 2016
Bob Crowley
In this article, I will explain the sometimes surprising behavior of  the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.
28 Nov 2017
Bob Stoom
Walkthrough in detail to create a relational database application using C# .NET without code.
9 Mar 2015
bob.bumsuk.lee
Web app that manages customer complaints and demonstrate how to use Web API, SignalR and AngularJS technologies
13 Jun 2018
Bojan Sala
SqlBinder is a free, open-source library that helps you transform a given SQL template and a set of conditions into any number of valid SQL statements along with their associated parameters.
10 Jul 2006
BoneSoft
An API to simplify access to databases through ADO.NET.
20 Sep 2005
Brian Perrin
Eliminate the pain of calling SQL stored procedures from C#.
2 Feb 2007
Brian Rush
In this brief article, the author mentions two techniques that he uses to allow for mapping GridViews to DataTables that are built upon existing middle tier objects.
13 Mar 2008
Brice Schagane
An article on using Transactions with Strongly Typed Datasets and multiple Table Adpaters while taking advantage of Partial Classes.
14 Apr 2008
Broken Bokken
Learn how to use the ReportViewer with any data source, and build reports on the fly for use on the web or in Windows applications.
6 Oct 2010
Bruno Altinet
How to set up a basic application using Silverlight, RIA and NHibernate with top to bottom validation, all nice and fluent:)
13 Aug 2018
Bryian Tan
This article shares the idea on how to utilize free tools to download log files from server, upload IIS log files into the database, display the results and compare the baseline and production files.
11 Feb 2005
Buddhi Dananjaya
This article describes how to add controls to a DataGrid. This will add controls at runtime. I hope this will be helpful for developers who are using DataGrids for data entry forms.
10 Aug 2007
C Razzeto
Database abstraction using factory design pattern
20 Jan 2011
Carlos Conceição
Using data-structures to do away with boiler plate code.
21 Jul 2007
carlos@takeapps
A webservice implementation to connect to POP3 servers
1 Oct 2008
Casper Leon Nielsen
T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)
25 May 2015
César de Souza
Explore your data using statistical distributions: explore, initialize, create, estimate and use statistical distributions from the Accord.NET Framework using an application based entirely on reflection.
25 Oct 2004
Chad Z. Hower aka Kudzu
Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.