Click here to Skip to main content
15,860,972 members
Everything / ADO.NET

ADO.NET

ADO.NET

Great Reads

by David Rogers Dev
Learn how to load related entities using the Entity Framework with simple examples
by dotnetdan
VS 2005 debug visualizers for DataSet, DataTable, DataView, DataRow and DataColumn objects.
by LarryCharlton
Dynamic data forms.
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 Jani Giannoudis
REST API Reporting for .NET
by freedeveloper
How to create a data access class in a way, that is possible to execute unit test on it
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.
by Oleksandr Viktor (UkrGuru)
Minimally simple UkrGuru.SqlJson package for modern data manipulation

All Articles

Sort by Score

ADO.NET 

24 Jul 2014 by David Rogers Dev
Learn how to load related entities using the Entity Framework with simple examples
30 May 2005 by dotnetdan
VS 2005 debug visualizers for DataSet, DataTable, DataView, DataRow and DataColumn objects.
11 Aug 2013 by LarryCharlton
Dynamic data forms.
15 Jul 2014 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.
31 Oct 2007 by 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.
17 Aug 2009 by vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
25 Jan 2013 by FatCatProgrammer
StarReport: WPF-less GDI+.NET report component.
5 Nov 2018 by Jovan Popovic(MSFT)
Create powerful REST API with just few lines of C# code using MsSql.RestApi package
31 Mar 2006 by Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
29 Aug 2012 by linush
Explains how to mock test an EF Model-First project using ADO.NET Entity Data Model template
25 Nov 2016 by kannankeril
This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.
24 Nov 2009 by raelango
This is a sample project to access Microsoft Access MDB data in Silverlight via OLEDB and dynamically populate a DataGrid.
21 Feb 2018 by Yunus Emre Kalkan
How to create custom repostories in ASP.NET Boilerplate and use stored procedure, view, user defined functions inside your repository
13 Mar 2006 by Marc Clifton
An investigation into different data entry modalities and the need for a transaction sandbox.
29 May 2017 by tranthanhtu.vn
In this article, We will learn why do we need to manage the stages of our application.
6 Apr 2010 by seejay1120
A Fast Way to Update Treeview Nodes Using a Database as a Source
18 Apr 2012 by Alexandros Pappas
This project implements caching of DataTables and provides functionality for testing performance.
25 Apr 2012 by Razi Syed
Easily bind a class to .NET data controls like GridView, FormView, etc., and get an updated object or list back in the code-behind effortlessly.
16 Aug 2018 by Proneetkumar Pradeep Ray
JQuery Datatable (Dynamic columns) populate after Ajax JSON response via server side processing - Using EF Raw SQL query
10 Sep 2019 by Alexandros Pappas
This project describes how to use Entity Framework with update triggers and audit tables.
10 Jun 2016 by Emiliano Musso
In this article, we will see how to use entity framework in our Applications, developed through the various languages that Visual Studio allows us to use. The examples in this article and probably in the next, will be C # used under WinForms, but - as mentioned - this choice is not going to affect a
8 Nov 2016 by mblataric
Instructions on how to migrate existing XAF security system to new permission policy.
7 May 2017 by Michael Lockwood
How to call a web service using SSIS, store XML results and then query XML using XQuery
16 Apr 2013 by Muhammed Anseer K K
Creating a metro style application with WCF
28 Aug 2016 by Ali Adly
A simple example that shows how to create detail grid template at runtime using ASPxGridView
10 Feb 2018 by Changming Wang
A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar
13 Mar 2009 by Tiago Freitas Leal
This project shows how to have a master/detail DataGridView using CSLA EditableRootListBase (or DynamicRootList) as the master list object. It shows how to have sorted list and auto save on both the master and detail DataGridView.
30 Oct 2012 by Tom Cook (UK)
How to asynchronously poll a database for an Entity with EntityFramework 5
25 Nov 2014 by David Killian
A reflective approach to providing stored procedure based data access methods with a reuse pattern based on polymorphic Types as arguments in ObjectResult
14 Oct 2016 by George MVC Study
How to use ODP.NET user defined type feature
3 Aug 2011 by Eric Lynch
Flexible CSV reader/writer with progress reporting and many file format variations.
23 Feb 2009 by Walid Abdulrazik
An extension to the Microsoft SqlProfileProvider, to provide a search interface. This article is based on Shawn Wildermuth's - "a.k.a. ADO Guy" - work.
18 Feb 2010 by Alaric Dailey
Building an O/R Mapper: Step 2.
14 Jan 2012 by Henry He
In this article, I will explain what transparent lazy loading is and how it's implemented in NHibernate and Entity Framework.
20 Jul 2012 by FiegeU
A pragmatically introduction to DOJO for form based CRUD database operations with ASP.NET
7 Nov 2012 by Aydin Khatamneajd
Using ModelMetadataProvider to Set Display Name Metadata for the Model Fields at Runtime
17 Jul 2013 by Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
11 Oct 2013 by ASP.NET Community
Programming theMicrosoft® ADO.NET Entity Framework            by David SceppaPublisher : MicrosoftProgramming EntityFrameworkBuilding Data Centric
10 Jun 2021 by Vadim Loboda
A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.
10 Nov 2019 by Marc Clifton
Another rabbit hole, this time how to handle AJAX calls in a manner that lets you roll back the entire set of transactions if any particular AJAX call fails.
1 Dec 2019 by Fedor Dzjuba
Sometimes, we need to present MDX result on the web or a client application that has no native provider to Microsoft Analysis Service. Solution is to use Adodm.Client CellSet, serialize it into sensible JSON and spit it out to the client to render.
10 Feb 2009 by Derwin Dexter Sy
This is a base class that can be used to create model objects for database connectivity via ODBC in C# .NET.
6 Apr 2010 by Rainer Halanek
A Connection Scope for the Entity Framework that allows to execute commands in a single connection
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
15 Apr 2020 by Alexandros Pappas
This project describes how to use Entity Framework Core with update triggers and audit tables.
9 Sep 2005 by SoftWidgets
In just a few minutes, predefined templates, containing formatted sheets and charts, can be generated from any database using simple SQL statements, macros and/or custom C# or VB.NET snap-ins. Generated files can be distributed to a file server or as an email attachment. Usually, no coding is needed
17 Dec 2007 by mfmaneef
Explains how to send bulk records to a database using OPENXML.
7 Jan 2008 by Visual Numerics, Inc.
This document focuses on the combination of VSTO 2005 and Visual Studio 2005 Team Edition.
26 Mar 2008 by DataDirect
The Internet Security Advisors Group reviewed the DataDirect Technologies Connect product line of standards-based data access components. The DataDirect Connect products provide high performance access to a wide range of relational databases and incorporate a variety of important security features.
14 Aug 2008 by gnk424
How to merge two DataSets by eliminating the duplicate rows.
29 Apr 2009 by Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
28 Sep 2009 by mrjvdveen
How to change column collations through C# and ADO.NET
25 Dec 2009 by db_developer
Establishing of an existent connection to SQL Server with a sample: XML/A script execution tracing.
23 Aug 2011 by Radu Pascal
Support for enums in Entity Framework is probably the most desired feature, and it's strange it is not supported. This article will show a way to implement it using templates.
7 Nov 2011 by Paul_Gordon
An easy way to call and manage Stored Procedures in .NET.
30 Apr 2013 by Rawat Sandeep
Platform for people to share their emotions
3 Jun 2013 by Mark Kestenbaum
An entry to the Windows Azure Developer Challenge.
20 Apr 2015 by Jeffrey T. Fritz
How IT operations can engage more with a customer’s experience and assist software development in isolating problems in a production environment with no code changes needed from the development engineers.
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.
3 Jul 2016 by cyqdata
This is a presentation of a cyq.data ORM article.
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.
25 May 2015 by 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.
23 Jul 2009 by Johnson Manuel Devadoss ("Johnson Smith")
Way to export search results(BDC datalist/Enterprise Search) to Excel/PDF
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.
25 Mar 2008 by Qwertie
Demonstrates a variety of Windows Forms data binding features through several simple examples.
12 Mar 2012 by Marc Clifton
An Integrated Development Environment (IDE) for the Relationship Oriented Programming Tool.
21 Aug 2015 by Wendelius
Article describes how to encrypt a dataset using AES. Optionally the dataset is compressed before the encryption.
12 Oct 2013 by Dr. Song Li
This is the part 1 of a comparison on Data Access methods in the .NET environment.
19 Jun 2012 by David Catriel
How to get a list of data rows that caused an exception (or several of them) in a SqlBulkCopy operation
6 Sep 2017 by Debendra0256
In this article we will learn to create MVC project from scratch following n-tier architecture.Along with this we will focus on designing views.
16 Jan 2018 by Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
28 Oct 2008 by Marc Clifton
When you override GetRowType, you also need to override NewRowFromBuilder().
20 Dec 2011 by Shahriar Iqbal Chowdhury/Galib
T4 templetes with built-in support for CRUD operations, that utilize XML/XSD for DAL/BLL generation.
1 Jun 2013 by shah vatsal
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
16 Jan 2010 by Uwe Keim
A small set of general-purpose classes for using in .NET applications (2.0 or higher)
21 Mar 2014 by Baxter P
Dependency Injection Data Demo with Lazy Loading and Data Mocking
1 Mar 2015 by mbarbac
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
25 Dec 2008 by Samir NIGAM
This article describes how to manage states of the Checkboxes inside the GridView in different pages.
1 Mar 2015 by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
22 May 2008 by S. M. SOHAN
An article that shows a simple way of changing the default value of the DataContext CommandTimeout
5 Oct 2016 by Sahil Saini @ Software Developer
This article starts with creating the project in MVC with using the bootstrap classes to give better look to the UI and controls used on UI.
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.
3 Jan 2005 by Mike Ellison
A user interface web control for building conditions suitable for use in a SQL statement.
1 Jun 2009 by Dan-el Khen
An open source utility that synchronizes your database structure with a LINQ to SQL model.
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.
30 Nov 2015 by Sreekanth Mothukuru
The idea is to use Dependency Injector (DI) framework Ninject to dynamically target our application to SQL Server or Oracle database either by using Entity framework (EF) or Dapper ORM using global settings
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.
4 Jun 2019 by Sacha Barber
An example application using angular/Rx for JavaScript/Web Sockets/jQuery
2 Oct 2009 by Samir NIGAM
This article describes how to toggle the states of all CheckBoxes inside a particular DataGridView column.
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.
12 Oct 2013 by Dr. Song Li
This is part 2 of a comparison on Data Access methods in the .NET environment.
26 Mar 2009 by Joerg Lang
The article describes how to create a Deep Zoom image and store the tiles in a database, and how to read the image from the database and display it in the browser.
26 Oct 2001 by 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.