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

.NET Reporting Tool Tutorial - 1

28 Apr 2013 by emadns

A basic tutorial for ReportMax tool

.NET Reporting Tool Tutorial - 3

23 Apr 2013 by emadns

Using the Chart control in ReportMax

.NET TransactionScope and its default Transaction Isolation level issue

1 Feb 2013 by S. M. Ahasan Habib

.NET TransactionScope and its default Transaction Isolation level issue.

3 Layer Architecture for Beginners in ASP.NET C#

19 Jan 2015 by JatinKhimani

Develop a web application in 3 layer architecture code style

A Generic ADO.NET Overlay to Simplify DB Calls to SQL Server and Oracle

12 Jan 2016 by shijo joseph

An ADO.NET Layer for SQL Server and Oracle which makes it easier for interfacing with database

A Plug and Play Logging Library for Dummies

20 Dec 2015 by shijo joseph

An easy to implement yet powerful logging library which requires absolute zero learning curve

Achieve performance while updating a datatable bound to a bindingsource or datagridview

15 Feb 2010 by Ravi LVS

Datatable in ADO.NET is highly useful to do in memory data related operations. But it is very painful to update data when it is bound to a datagridview or bindingsource.While I was developing an application in .NET with C#, I came across this problem in which I had to modify a data table of...

ADO.Net Connectivity using Stored Procedure and Output parameters

10 May 2015 by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Auto Complete Control Like in GMail/Hotmail/Facebook

1 Aug 2013 by Bikash Prakash Dash

How to create an auto suggestion control like Gmail/Hotmail/Facebook to add items in list.

Auto Generate Code (CRUD) for 3 Layered architecture

12 Dec 2016 by Suresh Dasari's

Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.

SQL-Server-2005

AutoComplete ComboBox Control From Database

26 Aug 2010 by alrosan

AutoCompleteExtender working with EntityFramework! (Reload 2015)

12 Nov 2015 by Eduardo Yost

Creating a Web User Control containing an AutoCompleteExtender for data through WCF (JSON) allowing to store the entity selected through EntityFramework. Entity object serialization from the server to the client and the client to the server.

Bulk Copy/Insert from a CSV file to SQL Directly

14 Jan 2016 by Bhishma Anil Kajaria

Browse and Copy data from your CSV file to SQL directly without any Windows application...

C# Photo Viewer with Windows Forms

16 Feb 2014 by puja11191

This is an extension of Photo Viewer on MSDN

Changing Databases at Run-time using Entity Framework

18 Jul 2014 by Matthew Givens

How to change databases at run-time in a user-friendly manner.

entity-framework

Check Network V1.0

23 Apr 2014 by mohamedkamaleed

Network check v1.0

SQL-Server-2012

Clientside GridView with jQuery template and AJAX in ASP.NET

4 Jul 2013 by sumit_kapadia

Create and Bind gridview at client side with Jquery Template and ajax in asp.net

Clone an Entity in Entity Framework 4

11 Oct 2012 by markmnl

Method to clone an EntityObject without serilization or detaching it

Combobox Data Binding and Sorting Tip

2 Oct 2012 by wkiess01

How to sort a data bound combobox

Connecting Windows Form Application With ADO.NET in C#

2 Dec 2012 by Bikash Karmokar

Connecting Windows Form Application With ADO.NET in C#

Continuous Integration and Delivery for Beginners (DevOps)

3 Feb 2019 by Thinira

Continuous Integration and Delivery with VSTS (Visual Studio Team Services)

Convert CellSet to HTML Table, and From HTML to Json, Array

17 Oct 2014 by Sibeesh KV

Convert CellSet to HTML table

SQL-Server-2008R2

Convert Outlook Table Content into Datatable using C# EWS and HtmlAgilitypack

1 Nov 2017 by Saurav J

Convert table from outlook email body into datatable or list using .NET C# EWS Managed API and HtmlAgilitypack

Converting DataView to Table

24 Dec 2010 by Sunasara Imdadhusen

Creating a DataTable from a DataView - DataView.ToTable()

Create CSV from JSON in C#

19 Mar 2017 by Yaseer Arafat

Using Extension Method and JSON Serializer

Create Table and Stored Procedure in SQL Server and connect it from ASP.NET using C#

17 Aug 2014 by Prakash Lekhak

We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#

SQL-Server-2008R2

Creating a Formatted Column within a DataTable

2 Jul 2014 by Mattintosh

How to create a formatted column with nothing more than a knowledge of which columns you want and the format you want them in

Creating a SQL Server Database Project Use in Visual Studio 2012 and Use TFS for Version Control

8 Jun 2015 by Diluka Wittahachchige

Creating SQL Server database project use in Visual Studio 2012 and maintain versions use in TFS

SQL-Server-2008

SQL-Server-2005

Creating null value SqlParameter parameter objects with AddWithValue

7 Jan 2012 by Brady Kelly

On problems that arise tying to add a null valued SqlParameter using the SqlParameterCollection.AddWithValue method.

Custom Treeview

19 Feb 2013 by sri senthil kumar

Custom Treeview control useful when multilevel hierarchical data need to be displayed and setting default can go at any level and providing access to each level then this can be the right choice.

Dapper.NET Sample with MVC 4- Add,Edit,Update,Delete

12 Aug 2014 by Gihan Liyanage

Simple Dapper.NET Example with MVC

Data Access using ServiceStack

6 Feb 2015 by Daniel Santillanes

Using ServiceStack's ORMLite framework as part of your MVC project's database access

Database Driven Dynamic Menu Control

15 Jan 2013 by Yugal Pandya

Database driven N-Level Dynamic Menu Control using C#.NET and SQL Server with stylesheet CSS

Database Driven Dynamic Menu Control

6 Oct 2013 by Muhammad Ahmed Azam

"Database Driven Dynamic Menu Control"

Database project diff SQL script utility (Using VSDBCMD)

26 Mar 2012 by Umesh Khandelwal

Database project diff SQL script utility (using VSDBCMD).

DataReader into IEnumerable with C#

4 Nov 2013 by Jaume González

How to convert any datareader into generic list.

DataTable from Excel

28 Jul 2015 by Igor Krupitsky

This article shows how to get ADO.NET DataTable out of Excel

Datatables.net Deferred Loading of Data using ASP.NET MVC and jQuery

4 Apr 2018 by Deepan Maheswaran

Implementing dynamic or deferred loading of data using datatables.net plugin in ASP.NET MVC

Day 1 : Database Connectivity ASP.NET/C# with SQL Server (Create Operation)

29 Mar 2016 by VijayRana

CRUD operation in ASP.NET/C# with SQL Server for beginners

Day 2 - Database Connectivity (Retrieve Value from Database and Bind to Gridview)

18 Oct 2015 by VijayRana

Retrieve value from database and bind to gridview

DBConnect

9 Jun 2018 by Sina Shiri Hamedani

This is a simple C# class for connect and using SQL Server easily (SELECT, INSERT, UPDATE, DELETE)

Debug ASP.NET MVC Application with Glimpse

11 Jan 2015 by Muhammad Hassan Tariq

Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications

SQL-Server-2008R2

Debugging DataSet Constraint Errors

18 Jun 2012 by cjb110

How to identify the cause of the DataSet Constraint Exception

Detecting Concurrency Issues with Entity Framework

14 Mar 2014 by Robert Lindblom

Detecting concurrency issues when using Entity Framework model first and SQL Server

Dodgy Database Solution with JSON

30 Nov 2016 by Michael Breeden

Using JSON to simplify, solve and enhance SQL Database issues

DuplicateNameException when adding columns to a DataTable dynamically

24 Jun 2011 by David C. Williams

When building an ADO.NET DataTable dynamically in your code, each column name must be unique or you get a System.Data.DuplicateNameException. If you don't know at design time that the columns you will be adding are certain to have unique names, you can use this method to avoid a runtime error.

Dynamic ASP.NET Web API Controller - Part 1. Dynamic DTO

8 Jun 2016 by David Lee 145

How to make dynamic DTO with ExpandoObject

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

SQL-Server-2008

Dynamic SQL Connection in ASP.NET 3.5 with User Controls

19 Jun 2015 by ss9o9o9o

Transferring backup files from a remote SQL Server and Dynamic SQL Connection with Restore utility.

SQL-Server-2005

Dynamically created menu bar from the database according to user credential using C#.NET

11 Jun 2013 by Dipankar Hazari

How to populate a dynamically created menu bar from the database according to user credentials using C# .NET and ASP.NET.

Dynamically Setting a Parameter from a C# Variable in Crystal Reports

2 Apr 2014 by Kinyanjui Kamau

I have written this tip to help developers automatically set Crystal Report parameters from variables in code (WinForms) at report run time.

EF Remove If Exists

12 Apr 2014 by Robert Lindblom

Removing entity if it exists

Ensure Your Code First DB is Always Initialized

27 Jun 2012 by Brady Kelly

A quick and easy way to ensure that your Code First DB Initializer is always run when your app starts, not just on the first data access operation

Enterprise Library 6 with SQLite Logging and Exception Handling, REAL!

25 Sep 2013 by ModMa

Real and fully functional connection Database Provider and DatabaseTraceListener for SQLite!

Entity Framework: ProviderManifestToken not valid

8 Jan 2013 by User 4324523

This tip attempts to solve ProviderManifestToken issue

EntityWorker.Core - An Alternative to Entity Framework

3 Oct 2018 by Alen Toma

EntityWorker.Core - an alternative to entity Framework

Enumerating OleDb Providers

22 Feb 2018 by PIEBALDconsult

A simple way to enumerate the OleDb Providers installed on the system

Example of gridview rowcommand on Button Click

29 Mar 2013 by Nandakishore G N

Example For Gridview RowCommand Event

SQL-Server-2005

Execute Long Running SQL Statements Asynchronously from .NET

21 Oct 2015 by Anil Kumar @AnilAwadh

A beginner's tutorial for understanding Asynchronous execution of SQL statements using a simple application.

Executing Stored Procedure using Entity Framework DataContext

26 Jun 2015 by Manoj Deshmukh

Executing Stored Procedure that returns resultset using Entity Framework DataContext

Export and Import Database using SMO

30 Apr 2014 by Sridhar Pasham

Export and import database using SMO

Export to Excel in ASP.NET C#

24 Feb 2014 by JatinKhimani

Export Gridview data in Excel formate with gridview design.

Exporting a DataTable to PDF

27 Mar 2012 by M.AFTAB.ALAM

Using MigraDoc as an open source .NET library to export a DataTable to PDF.

Extract All Schema Information From Your Database

16 Apr 2015 by sx2008

how to get as much information about your database as possible via ADO.NET

Extract Image Files from Database Image Data

20 Feb 2014 by PallavSingh

Converting data column (contains OLE db image binary Format) to image file (.jpg)

Failproof Bulk Upload SqlBulkCopy

29 Nov 2013 by lalitsrana

Demonstrate a simple yet efficient way to upload the data (SqlBulkCopy)

Fast and Simple IDataReader Implementation to Read CSV Files

3 Oct 2015 by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Five different overloads of the DataAdapter.Fill() method

20 Sep 2012 by Ravindra T C

A look into the five different overloads of the DataAdapter.Fill() method.

Forgot Password With Check Email From Database

22 Oct 2013 by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Generating and Splitting a Delimited String Column

17 Jan 2013 by Tharaka MTR

This article describes the easiest way to create and process delimited row using SQL XQuery.

SQL-Server-2005

SQL-server-2000

Generic Method to Convert DataReader Result into List of CLR Objects

24 Apr 2014 by Bankey Sharma

Converting DataReader Result into List of Objects Using Generic Type, Property Attribute and Reflection

entity-framework

Geolocation wifi Scanner and Finder

2 Apr 2015 by Dr Gadgit

Written in C# and VS2010 as a class libary to be used in your own project.

Get SQL Server Database Connection String Easily from Visual Studio

14 May 2013 by Srinubabu Ravilla

How to get SQL Server database connection string easily from Visual Studio

GMaps Control Simplified in VB.NET

16 Feb 2018 by Len van den berg

GMaps Control Simplified in VB.NET

High Performance ADO Database Library

7 Feb 2018 by Matthew Ruffell

A high-performance and well tested C# ADO library for connecting and querying a SQL database

Highlight Search Text in Search Result

5 Aug 2013 by Bikash Prakash Dash

How to highlight search text in a search result using ASP.NET

How to Change Date Format in Crystal Report

23 Jul 2015 by Mian Adnan

Using Microsoft Visual Studio Professional 2012, .NET 4.5 and Crystal Report Version regarding .NET 4.5 and VS 2012

SQL-Server-2014

How to Check Opened Connection in SQL Server

13 Nov 2015 by Najmul Hoda

Here is the code snippet to check how many database connections are opened in SQL Server.

How to Copy Data from SqlDataSource to Datatable and Operations Using Datatable

18 Jan 2013 by Nandakishore G N

I'll Try To Explain Some Methods of Datatables.

How to Create Subreport using Microsoft Reporting Service

18 May 2010 by T.Ashraf

Introduction...

How to execute multiple database script files from a specific directory

18 Feb 2013 by S. M. Ahasan Habib

I will explain very simple way to execute multiple script files (*.sql) from a directory.

How to fix Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

2 Aug 2013 by AlbertoLeon CSharpMan

Insert Ignore with select thousands of rows threw timeout expired exception

How to get Connection String from App.Config in C#

15 Oct 2013 by Alireza C

This code helps you to grab ConnectionString from App.config.

How to Implement ObjectStatus with EntityWorker.Core and JavaScript

8 Jul 2018 by Alen Toma

How to implement ObjectStatus with EntityWorker.Core and JavaScript

How to: Get Data from Multiple Workbooks using One OleDbConnection?

3 Jan 2014 by Maciej Los

This tip shows how to get data from multiple workbooks using one OledbConnection.

How-To Create a CLR Function with EffiProz Database

17 Mar 2010 by arith silva

EffiProz(www.e...

Increase productivity with Visual Studio extensions

30 May 2012 by Ahsan Murshed

This article gives ideas to developers to increase development time productivity using the free Visual Studio 2010 extensions.

Increase update performance of sqlDataAdapter

29 Aug 2011 by Shining Legend

Increase update performance of sqlDataAdapter

Insert Multiples Records to SQL Server Database

15 Mar 2017 by Ricardo_Torres_Torres

Read text file and insert mutiples records in just one SQL Sentence

Introduction to EntityWorker

23 Dec 2019 by Alen Toma

EntityWorker ORM

Know More about SQL Constrains

21 Aug 2014 by Mohammed Nazer

SQL Constrains details and its types

21 Jan 2013 by Srinivasu Pemma

This tip provides an easy way of dealing with different types of data sources for LINQ Group By taken from my blog http://www.srinetinfo.com/2012/12/linq-group-by.html

LINQ Tutorial for Beginners

10 May 2013 by d.ban

A LINQ tutorial for beginners.

Listing Sheets in an Excel File

21 Feb 2018 by PIEBALDconsult

A simple way to use ADO.NET to get a list of sheets in an Excel file

Load a ComboBox at Runtime

7 Jan 2011 by Tim Corey

Learn how to use a dataset object to load a combobox (or other similar objects) at runtime instead of needing to set anything up at design time.

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

17 Apr 2022 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.

Microsoft ASP.NET Identity MerlinFramework 2.0

28 Apr 2014 by Marc Leger

Microsoft ASP.NET Identity MerlinFramework

Mocking EF DbContext and DbContextTransaction with Proxy

12 Oct 2016 by MaDOnos

How to mock EF DbContext and DbContextTransaction with Proxy

entity-framework

MS Access (*.mdb) + C#: SELECT, INSERT, DELETE and UPDATE Queries

12 Jan 2015 by Emiliarge

Queries in Microsoft Access (MDB) databases.

Multilevel Nested Gridview in ASP.NET

2 Jul 2014 by Chakravarthi Elchuri

Display data in Multi nested gridview using C# in ASP.NET