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

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.

MySqlCommand, MySqlParameter and "LIKE" with Percent Symbol

5 Aug 2013 by AlbertoLeon CSharpMan

How to search text with LIKE with MySQLParameter in MySQL .NET / Connector

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

EntityWorker.Core - An Alternative to Entity Framework

3 Oct 2018 by Alen Toma

EntityWorker.Core - an alternative to entity Framework

How to Implement ObjectStatus with EntityWorker.Core and JavaScript

8 Jul 2018 by Alen Toma

How to implement ObjectStatus with EntityWorker.Core and JavaScript

Introduction to EntityWorker

23 Dec 2019 by Alen Toma

EntityWorker ORM

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.

Storing Dataset in a file using Object Serialization

26 Aug 2010 by alrosan

AutoComplete ComboBox Control From Database

26 Aug 2010 by alrosan

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.

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.

How-To Create a CLR Function with EffiProz Database

17 Mar 2010 by arith silva

EffiProz(www.e...

7 May 2014 by Ashish Tripathi

Sharp RepoGen is a simple tool to create repository interface having methods for CRUD operation and its implementing class. Using this tool easily you can generate your repositry class and interface. Code is generated with the help of xml template, so very easily you may change the template to creat

Set the connection string for Entity Framework at runtime

2 Aug 2011 by Bahram Ettehadieh

This shows how to set or change the connection string for Entity Framework at run time (programmatically)

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

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...

Connecting Windows Form Application With ADO.NET in C#

2 Dec 2012 by Bikash Karmokar

Connecting Windows Form Application With ADO.NET in C#

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.

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

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.

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

Multilevel Nested Gridview in ASP.NET

2 Jul 2014 by Chakravarthi Elchuri

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

Working with MS Chart

6 Apr 2012 by Chamara Janaka

Article Describes how to Generate a Simple Chart using ASP.NET chart control

Perfect Pagination with Repeater Control in ASP.NET C#

10 Oct 2015 by ChienVH

Perfect Pagination with Repeater Control in ASP.NET C#

Simple Client Side Consume ASP.NET Web API Server

12 May 2017 by Chinh Vo Wili

Send HTTP GET requests, consume ASP.NET Web API server

Debugging DataSet Constraint Errors

18 Jun 2012 by cjb110

How to identify the cause of the DataSet Constraint Exception

SQL Server FILESTREAM with Nhibernate

23 Oct 2015 by Codeman the Barbarian

In the tip, I go through one approach to integrating SQL Server's FILESTREAM type with Nhibernate.

LINQ Tutorial for Beginners

10 May 2013 by d.ban

A LINQ tutorial for beginners.

Data Access using ServiceStack

6 Feb 2015 by Daniel Santillanes

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

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

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

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

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.

SqlServer: Parameterized Query With IN() Clause C#

14 Feb 2019 by DiponRoy

A utility class to send parameters for IN() operator in SQL using parameterized queries

entity-framework

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

14 Jun 2020 by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

entity-framework

SQL to ADO.NET API (Automated ADO.NET or DB API)

10 Apr 2017 by dmytro.sen

SQL to ADO.NET API (Automated ADO.NET)

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.

Pure SQL solution to Database Table Paging

15 Aug 2012 by DrABELL

Portable solution encapsulated in single SQL query allows to select N rows offsetting M records

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.

.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

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

12 Jan 2015 by Emiliarge

Queries in Microsoft Access (MDB) databases.

Selecting Distinct Records Using LINQ

15 Oct 2012 by Eric Shandil

How to get dictinct records from a datatable in .NET.

Using Explicit Cast instead of Databinder.Eval to Increase Performance

27 Nov 2012 by Fenil Desai

Increase ASP.NET Application performance with explicit casting

Strategy for Separating UI and Back-end Code Development

15 Jan 2015 by Giancarlo Rhodes

Creating the Web UI

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

12 Aug 2014 by Gihan Liyanage

Simple Dapper.NET Example with MVC

SQL Query with C# Typed Library - CooQ

2 Nov 2015 by Guni Van

Mapping your database with C# object class, then make typed-safe query like SQL syntax

Xamarin Forms: Check and Request for Permissions

11 Jan 2019 by Harshit Gindra

Check and request for Permissions in Xamarin Forms mobile application

Querying DataSet With LINQ in ASP.NET

31 Jul 2012 by HemendraSingh88

Hi, here we will see how to query a DataSet with LINQ(Language Integrated Query).

SQL Server Connection Dialog

29 Oct 2012 by Hernán Hegykozi

Show you how to make a connection dialog developed completely from scratch.

String Interpolation or String Handling in C# 6.0 with New Feature

1 Sep 2015 by idreeskhan

String interpolation or String handling in C# 6.0 with new feature

DataTable from Excel

28 Jul 2015 by Igor Krupitsky

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

Export to Excel in ASP.NET C#

24 Feb 2014 by JatinKhimani

Export Gridview data in Excel formate with gridview design.

Nested gridview Edit

25 Feb 2014 by JatinKhimani

Nested GridView With Editing Facility of both gridview.

3 Layer Architecture for Beginners in ASP.NET C#

19 Jan 2015 by JatinKhimani

Develop a web application in 3 layer architecture code style

DataReader into IEnumerable with C#

4 Nov 2013 by Jaume González

How to convert any datareader into generic list.

Preventing SQL Injection in ADO.NET

12 Nov 2012 by K C R

This article is to help beginners understand what is SQL injection and how to prevent it

Yet Another Duplicate File Detector

22 Jan 2016 by kaviteshsingh

Simple utility to scan and find duplicate files in a directory.

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.

Understanding Normal Forms of Relationship for database

15 Apr 2014 by Kirill__

How to create databese with forst 3 normal forms of relationship

WCF, Entity Framework, and Data Contracts

11 Jan 2013 by Kumar_Jitendra

Expose an Entity Framework class entity as a data contract.

Failproof Bulk Upload SqlBulkCopy

29 Nov 2013 by lalitsrana

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

GMaps Control Simplified in VB.NET

16 Feb 2018 by Len van den berg

GMaps Control Simplified in VB.NET

Using SQLite: An Example of CRUD Operations in C#.NET

20 Nov 2015 by Lộc Nguyễn

With a DEMO WPF application (WinNotif)

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.

PostgreSQL-ADO.NET Framework

15 Mar 2018 by M.M.Mohseni

The simple sample that shows how to connect the ADO.NET Framework to the PostgreSQL

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.

Mocking EF DbContext and DbContextTransaction with Proxy

12 Oct 2016 by MaDOnos

How to mock EF DbContext and DbContextTransaction with Proxy

entity-framework

Executing Stored Procedure using Entity Framework DataContext

26 Jun 2015 by Manoj Deshmukh

Executing Stored Procedure that returns resultset using Entity Framework DataContext

Microsoft ASP.NET Identity MerlinFramework 2.0

28 Apr 2014 by Marc Leger

Microsoft ASP.NET Identity MerlinFramework

Pass Variables From Server to JavaScript after JavaScript is Loaded.

5 Mar 2013 by Marcio_Coelho

This sample demonstrates how to pass data (variables) from code behind to JavaScript.

Clone an Entity in Entity Framework 4

11 Oct 2012 by markmnl

Method to clone an EntityObject without serilization or detaching it

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

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

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

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

SQL-Server-2008

Set the connection string for Entity Framework at runtime

20 Nov 2011 by member60

One possible way is to do it the following way: How to change the connection string in the EntityFramework? [^].

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

Dodgy Database Solution with JSON

30 Nov 2016 by Michael Breeden

Using JSON to simplify, solve and enhance SQL Database issues

SSRS Reports: Show Data from Non-standard Provider

21 Jul 2017 by Michael Ecklin

SSRS Reports: Show Data from Non-standard Provider

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!

Check Network V1.0

23 Apr 2014 by mohamedkamaleed

Network check v1.0

SQL-Server-2012

Know More about SQL Constrains

21 Aug 2014 by Mohammed Nazer

SQL Constrains details and its types

Database Driven Dynamic Menu Control

6 Oct 2013 by Muhammad Ahmed Azam

"Database Driven Dynamic Menu Control"

Forgot Password With Check Email From Database

22 Oct 2013 by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

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

Using SQL Bulk Copy with your LINQ-to-Entities datacontext - Part 1

27 Aug 2013 by Måns Tånneryd

This tip shows how to significantly speed up inserts of large amounts of data using the entity framework.

Using SQL bulk copy with your LINQ-to-Entities datacontext - Part 2

26 Aug 2013 by Måns Tånneryd

This tip shows how to speed up inserts using POCO objects and the entity framework version 5.

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.

Example of gridview rowcommand on Button Click

29 Mar 2013 by Nandakishore G N

Example For Gridview RowCommand Event

SQL-Server-2005

Update Database using Stored Procedure and DataAdapter

20 Jun 2015 by Naresh Patidar

Insert, update and delete operations using stored procedure and DataAdapter in C#

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Split comma separated IDs to get batch of records through Stored Procedure

1 May 2013 by Nasser Malik

Split comma separated IDs to get batch of records through Stored Procedure.

SP Beginners Part 1 – Create a Web Application on Farm and Getting It Functioning in Visual Studio

15 May 2015 by NikiGrly

Steps to create a web application on your farm.

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

24 Jun 2021 by Oleksandr Viktor (UkrGuru)

Minimally simple UkrGuru.SqlJson package for modern data manipulation

SQL-Server-2016

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)

Possible solutions for an .Net 4 compiler bug that raise an MissingMemberException by acessing the index property of an SqlParameterCollection from an SqlCommand

14 May 2014 by Peter BCKR

In legacy applications you can get a MissingMemberException bei acessing a SqlParameterCollection if you work with object-variables there are reference a SqlCommand-Instance.

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

Enumerating OleDb Providers

22 Feb 2018 by PIEBALDconsult

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