In Focus
Introduction to Microsoft Azure

C# Corner

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.

RECENT POSTS

  • Save, Delete, Search And Update Records in ADO.NET

    In this article you will learn to save, delete, search and update records in ADO.NET.

  • ADO.NET Interview Questions And Answers

    This article lists top ADO.NET Interview questions and answers.

  • Converting Datatable And Dataset To JSON String And Vice Versa

    In this blog, we will learn how to convert a datatable and dataset into a JSON string and vice versa.

  • Calling Oracle stored procedures from Microsoft.NET

    This article is intended to illustrate how to illustrate how to call Oracle stored procedures and functions from Microsoft.NET through the Microsoft.NET Oracle provider and its object model residing i

  • Oracle Connection String using C#

    In this article, we will see the different data providers available with Oracle to fetch records in .Net. We will learn the syntax for Oracle data providers.

  • DataTable In C#

    The DataTable class of ADO.NET represents a data table in C#. Code sample in this article demonstrates how to create a DataTable dynamically in C# code and DataTable rows and DataTable columns and dis

  • DataReader In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • DataView In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • DataAdapter In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • Generic Data Access Component using Factory Pattern

    The article A Generic Data Access Component using Factory Pattern provides a very good way of creating ADO.Net data provider independent applications, but there is one problem with it. Different ADO.N

  • Writing a Generic Data Access Component

    I've received couple of emails people asking me how can they use a common data provider to access various types of data sources without loosing the power and flexibility of native data provider li

  • A Generic Data Access Component using Factory Pattern

    This article shows to utilize the System.Activator class and a factory pattern to create the concrete provider classes.

  • Improve SQL Server Connection Performance In ADO.NET

    This little tip will boost the speed of SQL Server connection using ADO.NET. I was using ADO.NET to connect to an SQL Server database on a local network. I noticed that the connection speed seems off.

  • How To Transform A Class Into DataSource

    A class can be transformed into a DataSource object using Visual Studio IDE. Let's learn how.

  • Exploring SQLConnection In ADO.NET

    In this article, you will learn what the SQL connection class in ADO.NET. and how to use SQL connection class in ADO.NET.

  • ADO.Net and MySQL Connection

    Since there is no out-of-the-box MySQL support, connecting to this popular DMBS might get tricky. Learn how to connect to MySQL using a third-party ADO.Net connector.

  • What You Should Prefer For Performance Among Entity Framework, Dapper, And ADO.NET

    Basically, when we design an application in .NET or any other technology, then how we are loading your data for application really impact the performance of our application. So, I will tell you what y

  • Difference Between DataReader, DataSet, DataAdapter and DataTable in C#

    what is the difference between DataReader, DataSet, DataAdapter and DataTable in C#.

  • Data Binding in DataGrid Control using C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • DataSet In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • DataTable In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • How To Join Two DataTables Using C# In ADO.NET

    In this tutorial, I will explain about Data table by using Primary Key Property. Primary Key Property Return Type is "DataColumn" it was an Array. Return An array of System.Data.DataColumn o

  • ADO.Net Constraints - Unique and Primary Key

    This video explains how we can implement Unique and Primary Key and FrontEnd. It then walks you through DataTable merge and checks the Constraints behavior.

  • 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 The

  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data Model

    You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity fram
    • View More