Electrical Friend: 2019

ADO.NET is that technology by Microsoft which enables us to connect any .NET application with different type of Database easily and unanimously. thus it acts as a layer between .NET Application and Database as shown in following picture.

Three important classes in ADO.NET frame work are 1) Connection 2) DataAdapter and 3) DataSet. Using objects of these class types in .NET application we can access from database and use the data as per our needs.

Obviously to connect with different type of database we have to use different type of data adapter and connection string.

Thus for understanding the whole thing in a better way we shall try for writing the actual code. To try with databases here are some ready database files of different type having the Same name Contacts and having a single table with name contacts1 with a very small amount of data (5 records)

1) ACCESS Database File Contacts.accdb

2) SQL Express Database file Contacts.mdf

3) SQL Compact Edition Database file Contacts.sdf

4) SQLite Database file Contacts.db

5) Excel as Database file Contacts.xlsx

And here are the Zip file for VS2012 Solution and VB.NET Project to connect to each type of database.

1) Connect To Access Database

2) Connect to SQL Express Database

3) Connect To SQL CE Database

4) Connect To SQLite Database

5) Connect To Excel

And here are videos which will explain how to write the code