ADO.NET Blogs

ADO.NET

ADO.NET introduced as a part of .NET 1.0, is an API (set of classes) that is used to connect and access various data sources including XML, flat files, relational databases, and more. Here you may find ADO.NET related articles and news.

Blogs

Solution - The 'Microsoft.ACE.OLEDB.12.0' Provider Is Not Registered On The Local Machine

While working with Microsoft Access database connectivity with ado.NET, you may have received this error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine or T...
Nikunj Satasiya Oct 26, 2017
How To Connect To SQL Database Using ADO.NET From C# Program

In this article, I have explained how to use ADO.NET to interact with the database.
ram dungar Jun 23, 2017
How To Create The Data Adapter Object Using ADO.NET

This blog imparts knowledge on how to create the data adapter object, Using ADO.NET.
Rathrola Prem Kumar Mar 15, 2017
Executing SQL Query in Entity Framework

In this blog, I will explain to you how we can use different types of SQL Query methods.
El Mahdi Archane Jul 23, 2016
Delete Rows from DataGridView using Checkbox with ADO.NET

This blog describe how to delete rows from dataGridView based on checkbox component using ADO.NET and C#.
El Mahdi Archane Jun 07, 2016
Insert(Bulk) DataTable Data in Database

In this blog we will Insert(Bulk) Entire DataTable Data in Database.
Abrar Ahmad Ansari Apr 15, 2015
Validation Error for Invalid Values in Decimal Columns

How to raise validation error for invalid values in decimal columns.
Mitesh Patel Dec 21, 2014
Bulk Copy in SQL server using c#.net

This blog explains how to copy data of one table to another table using bulk copy.
Manish Kumar Choudhary Sep 29, 2014
Entity Framework 6.1.0 RTM Released

This blog describes the latest released RTM version of the Entity Framework: EF 6.1.0.
Nimit Joshi May 05, 2014
Handling DBNull in C#

This blog explains the behavior of DBNull in C# and explains the methods to handle it.
Prakash Tripathi Mar 26, 2014
Efficiently Remove Duplicates in Dataset

This blog discusses the efficient way to remove duplicates in datasets.
Prakash Tripathi Jan 07, 2014
How to Set Isolation Level in TransactionScope

This blog defines how to set isolation level in TransactiScope.
Ravi Shekhar Dec 09, 2013
Closing the Database Connection using CommandBehavior.CloseConnection

Advantage of CommandBehavior.CloseConnection in ADO.NET.
Devesh Omar Dec 01, 2013
Method that returns Datatable object passing sql and connecting string in C#

Generic methods to return Datatable from sql query.
joaquin lopez Nov 03, 2013
How to use Distinct only in single Column, While you Getting Multiple Columns from Database.

Use Distinct in single column, while you getting multiple columns from database.
Santosh Thakur Oct 01, 2013
How to Connect .Net Application with Access Database

This blog will tell you that how to make connection with access database and how to read the value from access database.
Pawan Negi Sep 16, 2013
Listing available Databases using c#

This blogs lists all the available databases of your database server.
Kailash Chandra Behera Sep 03, 2013
Listing Available SQL Servers Using C#

This blog lists available SQL Servers.
Kailash Chandra Behera Sep 03, 2013
Listing all the Tables of Current database

In this blog I will let you know how to list all the table available in the current database.
Kailash Chandra Behera Aug 30, 2013
Listing Database Store Procedurs using C# ADO.Net

This blog lists all the Sote Procedures available in the database using ado.net.
Kailash Chandra Behera Aug 30, 2013

Get Certified

Test-01