ADO.NET is a set of classes (a framework) to interact with data sources such as databases and XML files. ADO is the acronym for ActiveX Data Objects. It allows us to connect to underlying data or databases. It has classes and methods to retrieve and manipulate data.

Here I show you some code that how to connect with a database using

1. How to create connection and fetch data from SQL Server and bind data on gridview 

2. How to insert, delete and update data into table using stored procedure and show data in gridview.