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

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

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

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

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

Passing Object Collections to ASP.NET Web API

16 Jan 2014 by Tom Glick Philadelphia, US

POC to demonstrate passing of collections of complex objects to ASP.NET Web API Controllers.

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.

Continuous Integration and Delivery for Beginners (DevOps)

3 Feb 2019 by Thinira

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

Multilevel Nested Gridview in ASP.NET

2 Jul 2014 by Chakravarthi Elchuri

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

Data Access using ServiceStack

6 Feb 2015 by Daniel Santillanes

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

Probable leak while using SqlDataReader in ADO.NET

5 Aug 2010 by Vinayaka Krishna Shenoy

Probable leak while using SqlDataReader in ADO.NET

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.

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.

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)

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

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

Debugging DataSet Constraint Errors

18 Jun 2012 by cjb110

How to identify the cause of the DataSet Constraint Exception

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

How to Implement ObjectStatus with EntityWorker.Core and JavaScript

8 Jul 2018 by Alen Toma

How to implement ObjectStatus with EntityWorker.Core and JavaScript

Converting DataView to Table

24 Dec 2010 by Sunasara Imdadhusen

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

Transparent Database Encryption Tool

25 May 2012 by Tauseef M

This tool is used for Encryption of Database in SQL Server 2008 Enterprise Edition

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.

nKnight - Role Based Access Control(RBAC) Solution for C#.NET

7 Apr 2014 by subhajit bhadury

nKnight - RBAC Solution for C#.NET

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

Pass Parameters from Web Page to Telerik Report

19 Jan 2015 by Thinira

In this tip, we discuss how to pass report parameters from web page to Telerik report programmatically.

SQL-Server-2008R2

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

Working with MS Chart

6 Apr 2012 by Chamara Janaka

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

Passing parameters to Success method in executeQueryAsync in SharePoint

21 Aug 2013 by shahed.sohail

Passing Parameters to Success method in executeQueryAsync.

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!

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.

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

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.

Yet Another Duplicate File Detector

22 Jan 2016 by kaviteshsingh

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

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

How to Create Subreport using Microsoft Reporting Service

18 May 2010 by T.Ashraf

Introduction...

Increase update performance of sqlDataAdapter

29 Aug 2011 by Shining Legend

Increase update performance of sqlDataAdapter

Database project diff SQL script utility (Using VSDBCMD)

26 Mar 2012 by Umesh Khandelwal

Database project diff SQL script utility (using VSDBCMD).

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.

Combobox Data Binding and Sorting Tip

2 Oct 2012 by wkiess01

How to sort a data bound combobox

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

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

Using Explicit Cast instead of Databinder.Eval to Increase Performance

27 Nov 2012 by Fenil Desai

Increase ASP.NET Application performance with explicit casting

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

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

.NET Reporting Tool Tutorial - 3

23 Apr 2013 by emadns

Using the Chart control in ReportMax

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.

Failproof Bulk Upload SqlBulkCopy

29 Nov 2013 by lalitsrana

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

To Generate XML File from Datatable using LINQ

23 Feb 2014 by puja11191

This tip shows how can we generate and save XML files

EF Remove If Exists

12 Apr 2014 by Robert Lindblom

Removing entity if it exists

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.

SSRS Reports: Show Data from Non-standard Provider

21 Jul 2017 by Michael Ecklin

SSRS Reports: Show Data from Non-standard Provider

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

Xamarin Forms: Check and Request for Permissions

11 Jan 2019 by Harshit Gindra

Check and request for Permissions in Xamarin Forms mobile application

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.

How-To Create a CLR Function with EffiProz Database

17 Mar 2010 by arith silva

EffiProz(www.e...

Storing Dataset in a file using Object Serialization

26 Aug 2010 by alrosan

Probable leak while using SqlDataReader in ADO.NET

14 Apr 2011 by Sabrina Hope

If you want to be sure that every object is closed, I would use this method: while (true){ Thread.Sleep(2000); using (SqlConnection objConnection = new SqlConnection(@"Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Northwind;Data Source=.;Max Pool Size=1"))...

Use UserControls to substitute the job DataList Server Control does in WebForms

26 May 2012 by pramodchand

Using collection of UserControls in WinForm since WinForm does not have a control like DataList server control of WebForm.

Selecting Distinct Records Using LINQ

15 Oct 2012 by Eric Shandil

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

Entity Framework: ProviderManifestToken not valid

8 Jan 2013 by User 4324523

This tip attempts to solve ProviderManifestToken issue

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.

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

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.

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.

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

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.

Perfect Pagination with Repeater Control in ASP.NET C#

10 Oct 2015 by ChienVH

Perfect Pagination with Repeater Control in ASP.NET C#

SQL Server Connection Dialog

29 Oct 2012 by Hernán Hegykozi

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

SimpleThreading Makes Threading Easy!

4 Aug 2017 by Sharp Ninja

Threading can be a daunting topic. This library takes much of the worry (and mistakes) out of multi-threaded application programming.

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

8 Jun 2016 by David Lee 145

How to make dynamic DTO with ExpandoObject

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

Nested gridview Edit

25 Feb 2014 by JatinKhimani

Nested GridView With Editing Facility of both gridview.

Detecting Concurrency Issues with Entity Framework

14 Mar 2014 by Robert Lindblom

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

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.

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.

Parameters - SqlCommand vs. OledbCommand and OdbcCommand

25 Jul 2011 by walterhevedeich

A quick tip on using OledbCommand and OdbcCommand

.NET Reporting Tool Tutorial - 1

28 Apr 2013 by emadns

A basic tutorial for ReportMax tool

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.

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

DataReader into IEnumerable with C#

4 Nov 2013 by Jaume González

How to convert any datareader into generic list.

Setting up SQLite and Entity Framework 6 (Code First and Database First)

16 Nov 2015 by User 10668410

How to get SQLite 1.0.98.1 working with Entity Framework 6.1.3 without a massive headache using the Database First Model and Code First Model.

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

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

SQL-Server-2008

Create CSV from JSON in C#

19 Mar 2017 by Yaseer Arafat

Using Extension Method and JSON Serializer

Export to Excel in ASP.NET C#

24 Feb 2014 by JatinKhimani

Export Gridview data in Excel formate with gridview design.

Connecting Windows Form Application With ADO.NET in C#

2 Dec 2012 by Bikash Karmokar

Connecting Windows Form Application With ADO.NET in C#

GMaps Control Simplified in VB.NET

16 Feb 2018 by Len van den berg

GMaps Control Simplified in VB.NET

Clone an Entity in Entity Framework 4

11 Oct 2012 by markmnl

Method to clone an EntityObject without serilization or detaching it

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

Example of gridview rowcommand on Button Click

29 Mar 2013 by Nandakishore G N

Example For Gridview RowCommand Event

SQL-Server-2005

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 get Connection String from App.Config in C#

15 Oct 2013 by Alireza C

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

Quickest Way to Create a .NET Database Application

4 May 2012 by Subha.N

Tip to create a database application using C# .NET in the shortest time possible.

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

Understanding Normal Forms of Relationship for database

15 Apr 2014 by Kirill__

How to create databese with forst 3 normal forms of relationship

Working with LINQ to Entities & LINQ to DataTable

31 Oct 2014 by ShaikAnwar

This topic gives us an idea of how to write Linq queries on Entities & DataTable. This covers some basic querying and also usage of joins and group by using LINQ.

SQL Server 2008 Error: Saving changes is not permitted

22 Apr 2012 by Prasad CM

How to fix this error.

SQL-Server-2008R2

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.

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

Using Effort - Entity Framework Unit Testing Tool

9 Dec 2015 by Roger C Moore

This tip is a guide for using the Codeplex project Effort for testing Entity Framework applications without requiring the unit tests to actually hit the SQL Server database.